SELECT
Products.*,
ProductCategories.Name as CategoryName,
ProductCategories.NameTranslations as CategoryNameTranlsations,
ProductMainCategories.Name as MainCategoryName,
ProductMainCategories.NameTranslations as MainCategoryNameTranslations,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
RD.Name AS DirName,
IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName,
RD.RepositoryDirectoryID AS CurrentDirID,
JD.RepositoryDirectoryID AS ParentDirIDName
FROM Products
LEFT JOIN ProductCategories ON ProductCategories.ProductCategoryID = Products.ProductCategoryID
LEFT JOIN ProductMainCategories ON ProductMainCategories.ProductMainCategoryID = ProductCategories.ProductMainCategoryID
LEFT JOIN ProductBrands ON Products.BrandID = ProductBrands.ProductBrandID
LEFT JOIN RepositoryFiles ON Products.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID
LEFT JOIN ProductsSelltypeLinks ON ProductsSelltypeLinks.ProductID = Products.ProductID
LEFT JOIN SellTypes on ProductsSelltypeLinks.SellTypeID = SellTypes.SellTypeID INNER JOIN ProductPhotos ON Products.ProductID = ProductPhotos.ProductID WHERE (Products.ProductID = ) GROUP BY Products.ProductID ORDER BY Products.Position
SELECT
Products.*,
ProductCategories.Name as CategoryName,
ProductCategories.NameTranslations as CategoryNameTranlsations,
ProductMainCategories.Name as MainCategoryName,
ProductMainCategories.NameTranslations as MainCategoryNameTranslations,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
RD.Name AS DirName,
IF (JD.RepositoryDirectoryID IS NULL, RD.Name, CONCAT(JD.Name,'/',RD.Name)) AS FolderName,
RD.RepositoryDirectoryID AS CurrentDirID,
JD.RepositoryDirectoryID AS ParentDirIDName
FROM Products
LEFT JOIN ProductCategories ON ProductCategories.ProductCategoryID = Products.ProductCategoryID
LEFT JOIN ProductMainCategories ON ProductMainCategories.ProductMainCategoryID = ProductCategories.ProductMainCategoryID
LEFT JOIN ProductBrands ON Products.BrandID = ProductBrands.ProductBrandID
LEFT JOIN RepositoryFiles ON Products.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS RD ON RepositoryFiles.RepositoryDirectoryID = RD.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS JD ON RD.ParentID = JD.RepositoryDirectoryID
LEFT JOIN ProductsSelltypeLinks ON ProductsSelltypeLinks.ProductID = Products.ProductID
LEFT JOIN SellTypes on ProductsSelltypeLinks.SellTypeID = SellTypes.SellTypeID INNER JOIN ProductPhotos ON Products.ProductID = ProductPhotos.ProductID WHERE (Products.ProductID = ) GROUP BY Products.ProductID ORDER BY Products.Position
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 Products.ProductID ORDER BY Products.Position' at line 24 Bestand " /home/cafespelen/domains/cafespelenvlaeminck.be/public_html/frontend/products/products.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/cafespelen/domains/cafespelenvlaeminck.be/public_html/frontend/products/products.php op lijn 130
Implementatie bestand /home/cafespelen/domains/cafespelenvlaeminck.be/public_html/pages/contact.php op lijn 22Caféspelen Vlaeminck
Contact
Vous souhaitez plus d'informations sur un produit spécifique de Cafespelen Vlaeminck ? Grâce à nos années d'expérience, nous pouvons vous offrir toujours le meilleur et le plus rentable des équipements. Nos valeurs clés sont la confiance, la qualité et le service!
Nous vous répondrons dans les délais les plus brefs !