Query: SELECT SQL_CALC_FOUND_ROWS gallerys.*, img.Id AS ImgId, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath, img.Name AS ImgName, CONCAT( '/attachment/', IF( img2.DirectoryPath IS NULL, '', CONCAT( img2.DirectoryPath, '/' ) ), img2.Id, '_', img2.FileName ) AS ImgPath2, img2.Name AS ImgName2, volumes.StrId AS VolumeStrId, volumes.Name AS VolumeName FROM gallerys LEFT JOIN gallery_image ON gallery_image.GalleryId = gallerys.Id LEFT JOIN attachments AS img ON img.ParentId = gallery_image.AttachmentId AND (img.CopyId = 1) LEFT JOIN attachments AS img2 ON img2.ParentId = gallery_image.AttachmentId AND (img2.CopyId = 2) LEFT JOIN gallery_volume ON gallery_volume.GalleryId=gallerys.Id LEFT JOIN volumes ON volumes.Id=gallery_volume.TagId WHERE gallerys.Deleted IS NULL AND gallery_volume.GalleryId = gallerys.Id AND gallery_volume.TagId = order by gallerys.Id ASC LIMIT 40 OFFSET 0 failed. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by gallerys.Id ASC LIMIT 40 OFFSET 0' at line 24

(mysqli): SELECT SQL_CALC_FOUND_ROWS gallerys.*, img.Id AS ImgId, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath, img.Name AS ImgName, CONCAT( '/attachment/', IF( img2.DirectoryPath IS NULL, '', CONCAT( img2.DirectoryPath, '/' ) ), img2.Id, '_', img2.FileName ) AS ImgPath2, img2.Name AS ImgName2, volumes.StrId AS VolumeStrId, volumes.Name AS VolumeName FROM gallerys LEFT JOIN gallery_image ON gallery_image.GalleryId = gallerys.Id LEFT JOIN attachments AS img ON img.ParentId = gallery_image.AttachmentId AND (img.CopyId = 1) LEFT JOIN attachments AS img2 ON img2.ParentId = gallery_image.AttachmentId AND (img2.CopyId = 2) LEFT JOIN gallery_volume ON gallery_volume.GalleryId=gallerys.Id LEFT JOIN volumes ON volumes.Id=gallery_volume.TagId WHERE gallerys.Deleted IS NULL AND gallery_volume.GalleryId = gallerys.Id AND gallery_volume.TagId = order by gallerys.Id ASC LIMIT 40 OFFSET 0  
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by gallerys.Id ASC LIMIT 40 OFFSET 0' at line 24
Gallery - Hungarian Review
Danube Institute
Batthyány Lajos Alapítvány
www.budapost.eu
Polgári Magyarországért Alapítvány
Friends of Hungary Foundation

Subscription

Hungarian Review annual subscriptions for six issues, including postage (choose one):

 
 
 

 

Picture gallery




HUNGARIAN REVIEW is published by BL Nonprofit Kft.
It is an affiliate of the bi-monthly journal Magyar Szemle, published since 1991
Publisher: Gyula Kodolányi
Editor-in-Chief: Gyula Kodolányi
Editorial Manager: Ildikó Geiger
Editorial office: Budapest, 1067, Eötvös u. 24., HUNGARY
E-mail: hungarianreview[at]hungarianreview[dot]com
Online edition: www.hungarianreview.com

Genereal terms and conditions