Query: SELECT SQL_CALC_FOUND_ROWS products.*, (SELECT StrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatStrId, (SELECT Title FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatTitle, (SELECT enStrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatStrId, (SELECT enTitle FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatTitle, img.Id AS ImgId, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( img2.DirectoryPath IS NULL, '', CONCAT( img2.DirectoryPath, '/' ) ), img2.Id, '_', img2.FileName ) AS ImgPath2, CONCAT( '/attachment/', IF( img3.DirectoryPath IS NULL, '', CONCAT( img3.DirectoryPath, '/' ) ), img3.Id, '_', img3.FileName ) AS ImgPath3, img.Name AS ImgName, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=1) AS Prod1, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=2) AS Prod2, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=3) AS Prod3, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=4) AS Prod4 FROM products LEFT JOIN product_image ON product_image.ProductId = products.Id LEFT JOIN attachments AS img ON img.ParentId = product_image.AttachmentId AND img.CopyId = 1 LEFT JOIN attachments AS img2 ON img2.ParentId = product_image.AttachmentId AND img2.CopyId = 2 LEFT JOIN attachments AS img3 ON img3.ParentId = product_image.AttachmentId AND img3.CopyId = 3 WHERE products.Id = AND products.Deleted IS NULL GROUP BY products.Id ORDER BY SortBy ASC 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 'AND products.Deleted IS NULL GROUP BY products.Id ORDER BY S...' at line 28

(mysqli): SELECT SQL_CALC_FOUND_ROWS products.*, (SELECT StrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatStrId, (SELECT Title FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatTitle, (SELECT enStrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatStrId, (SELECT enTitle FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatTitle, img.Id AS ImgId, CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( img2.DirectoryPath IS NULL, '', CONCAT( img2.DirectoryPath, '/' ) ), img2.Id, '_', img2.FileName ) AS ImgPath2, CONCAT( '/attachment/', IF( img3.DirectoryPath IS NULL, '', CONCAT( img3.DirectoryPath, '/' ) ), img3.Id, '_', img3.FileName ) AS ImgPath3, img.Name AS ImgName, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=1) AS Prod1, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=2) AS Prod2, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=3) AS Prod3, (SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=4) AS Prod4 FROM products LEFT JOIN product_image ON product_image.ProductId = products.Id LEFT JOIN attachments AS img ON img.ParentId = product_image.AttachmentId AND img.CopyId = 1 LEFT JOIN attachments AS img2 ON img2.ParentId = product_image.AttachmentId AND img2.CopyId = 2 LEFT JOIN attachments AS img3 ON img3.ParentId = product_image.AttachmentId AND img3.CopyId = 3 WHERE products.Id = AND products.Deleted IS NULL GROUP BY products.Id ORDER BY SortBy ASC  
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 'AND products.Deleted IS NULL GROUP BY products.Id ORDER BY S...' at line 28
Query: SELECT attachments.Id AS ImgId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+1), '_', REPLACE(attachments.FileName,'copy_2','copy_3') ) AS NImgPath, attachments.Name AS ImgName, attachments.Width AS ImgWidth FROM attachments WHERE CopyId=2 AND ParentId=(SELECT Id FROM attachments WHERE attachments.CopyId IS NULL AND attachments.PrimePic=1 AND attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = )) GROUP BY attachments.Id LIMIT 1 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 ')) GROUP BY attachments.Id LIMIT 1' at line 16

(mysqli): SELECT attachments.Id AS ImgId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+1), '_', REPLACE(attachments.FileName,'copy_2','copy_3') ) AS NImgPath, attachments.Name AS ImgName, attachments.Width AS ImgWidth FROM attachments WHERE CopyId=2 AND ParentId=(SELECT Id FROM attachments WHERE attachments.CopyId IS NULL AND attachments.PrimePic=1 AND attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = )) GROUP BY attachments.Id LIMIT 1  
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 ')) GROUP BY attachments.Id LIMIT 1' at line 16
Query: SELECT attachments.Id AS ImgId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+2), '_', REPLACE(attachments.FileName,'copy_1','copy_3') ) AS NImgPath, attachments.Name AS ImgName, attachments.PrimePic AS PrimePic FROM attachments WHERE CopyId=1 AND ParentId IN (SELECT Id FROM attachments WHERE attachments.CopyId IS NULL AND attachments.PrimePic IS NULL AND attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = )) GROUP BY attachments.Id 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 ')) GROUP BY attachments.Id' at line 16

(mysqli): SELECT attachments.Id AS ImgId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+2), '_', REPLACE(attachments.FileName,'copy_1','copy_3') ) AS NImgPath, attachments.Name AS ImgName, attachments.PrimePic AS PrimePic FROM attachments WHERE CopyId=1 AND ParentId IN (SELECT Id FROM attachments WHERE attachments.CopyId IS NULL AND attachments.PrimePic IS NULL AND attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = )) GROUP BY attachments.Id  
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 ')) GROUP BY attachments.Id' at line 16
Query: SELECT attachments.Id AS DocId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS DocPath, attachments.Name AS DocName, attachments.enName AS enDocName FROM attachments WHERE ParentId IS NULL AND attachments.Id IN (SELECT AttachmentId FROM product_document WHERE ProductId = ) GROUP BY attachments.Id 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 ') GROUP BY attachments.Id' at line 11

(mysqli): SELECT attachments.Id AS DocId, CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS DocPath, attachments.Name AS DocName, attachments.enName AS enDocName FROM attachments WHERE ParentId IS NULL AND attachments.Id IN (SELECT AttachmentId FROM product_document WHERE ProductId = ) GROUP BY attachments.Id  
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 ') GROUP BY attachments.Id' at line 11
Növények - Biota Szolgáltató és Oktató Bt.
Növénykereső




BIOTA Szolgáltató és Oktató Bt. © 2011 | Minden jog fenntartva!