SELECT
ProductBrands.*,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Width,
RepositoryFiles.Height,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
IF (ParentDirectory.RepositoryDirectoryID IS NULL, Directory.Name, CONCAT(ParentDirectory.Name,'/',Directory.Name)) AS FolderName,
Directory.RepositoryDirectoryID AS CurrentDirID,
ParentDirectory.RepositoryDirectoryID AS ParentDirID,COUNT(DISTINCT WebshopProductVariants.WebshopProductVariantID) AS WebshopProductVariantCount, null AS Photos
FROM ProductBrands
LEFT JOIN RepositoryFiles ON ProductBrands.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS Directory ON RepositoryFiles.RepositoryDirectoryID = Directory.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS ParentDirectory ON Directory.ParentID = ParentDirectory.RepositoryDirectoryID INNER JOIN WebshopProducts ON ProductBrands.ProductBrandID = WebshopProducts.ProductBrandID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductLinks ON WebshopProducts.WebshopProductID = WebshopProductLinks.WebshopProductID INNER JOIN WebshopProductCategories ON WebshopProductLinks.WebshopProductCategoryID = WebshopProductCategories.WebshopProductCategoryID INNER JOIN WebshopProductMainCategories ON WebshopProductCategories.WebshopProductMainCategoryID = WebshopProductMainCategories.WebshopProductMainCategoryID LEFT JOIN WebshopProductSuperCategories ON WebshopProductMainCategories.WebshopProductSuperCategoryID = WebshopProductSuperCategories.WebshopProductSuperCategoryID INNER JOIN WebshopProductVariants ON WebshopProducts.WebshopProductID = WebshopProductVariants.WebshopProductID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID LEFT JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductVariantProperties ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantProperties.WebshopProductVariantID LEFT JOIN WebshopPropertyValues ON WebshopProductVariantProperties.WebshopPropertyValueID = WebshopPropertyValues.WebshopPropertyValueID LEFT JOIN WebshopProperties ON WebshopPropertyValues.WebshopPropertyID = WebshopProperties.WebshopPropertyID LEFT JOIN Designers ON WebshopProducts.DesignerID = Designers.DesignerID WHERE (ProductBrands.ExternalUID = ) GROUP BY ProductBrands.ProductBrandID ORDER BY ProductBrands.Name
SELECT
ProductBrands.*,
RepositoryFiles.RepositoryDirectoryID,
RepositoryFiles.Name as FileName,
RepositoryFiles.Width,
RepositoryFiles.Height,
RepositoryFiles.Extension,
RepositoryFiles.ResizeSizes,
RepositoryFiles.OriginalResized,
IF (ParentDirectory.RepositoryDirectoryID IS NULL, Directory.Name, CONCAT(ParentDirectory.Name,'/',Directory.Name)) AS FolderName,
Directory.RepositoryDirectoryID AS CurrentDirID,
ParentDirectory.RepositoryDirectoryID AS ParentDirID,COUNT(DISTINCT WebshopProductVariants.WebshopProductVariantID) AS WebshopProductVariantCount, null AS Photos
FROM ProductBrands
LEFT JOIN RepositoryFiles ON ProductBrands.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS Directory ON RepositoryFiles.RepositoryDirectoryID = Directory.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS ParentDirectory ON Directory.ParentID = ParentDirectory.RepositoryDirectoryID INNER JOIN WebshopProducts ON ProductBrands.ProductBrandID = WebshopProducts.ProductBrandID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductLinks ON WebshopProducts.WebshopProductID = WebshopProductLinks.WebshopProductID INNER JOIN WebshopProductCategories ON WebshopProductLinks.WebshopProductCategoryID = WebshopProductCategories.WebshopProductCategoryID INNER JOIN WebshopProductMainCategories ON WebshopProductCategories.WebshopProductMainCategoryID = WebshopProductMainCategories.WebshopProductMainCategoryID LEFT JOIN WebshopProductSuperCategories ON WebshopProductMainCategories.WebshopProductSuperCategoryID = WebshopProductSuperCategories.WebshopProductSuperCategoryID INNER JOIN WebshopProductVariants ON WebshopProducts.WebshopProductID = WebshopProductVariants.WebshopProductID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID LEFT JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductVariantProperties ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantProperties.WebshopProductVariantID LEFT JOIN WebshopPropertyValues ON WebshopProductVariantProperties.WebshopPropertyValueID = WebshopPropertyValues.WebshopPropertyValueID LEFT JOIN WebshopProperties ON WebshopPropertyValues.WebshopPropertyID = WebshopProperties.WebshopPropertyID LEFT JOIN Designers ON WebshopProducts.DesignerID = Designers.DesignerID WHERE (ProductBrands.ExternalUID = ) GROUP BY ProductBrands.ProductBrandID ORDER BY ProductBrands.Name
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 ProductBrands.ProductBrandID ORDER BY ProductBrands.Name' at line 16
Bestand " /home/bohero/domains/bohero.eu/public_html/core/frontend/webshopproducts/webshopproductbrands.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/bohero/domains/bohero.eu/public_html/core/frontend/webshopproducts/webshopproductbrands.php op lijn 199
Implementatie bestand /home/bohero/domains/bohero.eu/public_html/pages/webshop_overview.php op lijn 45