SELECT
0 AS Active,WebshopProductSuperCategories.WebshopProductSuperCategoryID,WebshopProductSuperCategories.Name AS SuperCategoryName,WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations,ProductBrands.ProductBrandID,ProductBrands.ExternalUID AS GenderUID,ProductBrands.Name AS Brand,ProductBrands.NameTranslations AS BrandTranslations, 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,
WebshopProductMainCategories.*,
null AS URL,
null AS Categories,
null AS Photos
FROM WebshopProductMainCategories
LEFT JOIN RepositoryFiles ON WebshopProductMainCategories.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS Directory ON RepositoryFiles.RepositoryDirectoryID = Directory.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS ParentDirectory ON Directory.ParentID = ParentDirectory.RepositoryDirectoryID LEFT JOIN WebshopProductSuperCategories ON WebshopProductMainCategories.WebshopProductSuperCategoryID = WebshopProductSuperCategories.WebshopProductSuperCategoryID INNER JOIN WebshopProductCategories ON WebshopProductMainCategories.WebshopProductMainCategoryID = WebshopProductCategories.WebshopProductMainCategoryID INNER JOIN WebshopProductLinks ON WebshopProductCategories.WebshopProductCategoryID = WebshopProductLinks.WebshopProductCategoryID INNER JOIN WebshopProducts ON WebshopProductLinks.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID 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 WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID 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 (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.WebshopProductVariantID = 5981) GROUP BY WebshopProductMainCategories.WebshopProductMainCategoryID ORDER BY WebshopProductMainCategories.Position
SELECT
0 AS Active,WebshopProductSuperCategories.WebshopProductSuperCategoryID,WebshopProductSuperCategories.Name AS SuperCategoryName,WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations,ProductBrands.ProductBrandID,ProductBrands.ExternalUID AS GenderUID,ProductBrands.Name AS Brand,ProductBrands.NameTranslations AS BrandTranslations, 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,
WebshopProductMainCategories.*,
null AS URL,
null AS Categories,
null AS Photos
FROM WebshopProductMainCategories
LEFT JOIN RepositoryFiles ON WebshopProductMainCategories.RepositoryFileID = RepositoryFiles.RepositoryFileID
LEFT JOIN RepositoryDirectories AS Directory ON RepositoryFiles.RepositoryDirectoryID = Directory.RepositoryDirectoryID
LEFT JOIN RepositoryDirectories AS ParentDirectory ON Directory.ParentID = ParentDirectory.RepositoryDirectoryID LEFT JOIN WebshopProductSuperCategories ON WebshopProductMainCategories.WebshopProductSuperCategoryID = WebshopProductSuperCategories.WebshopProductSuperCategoryID INNER JOIN WebshopProductCategories ON WebshopProductMainCategories.WebshopProductMainCategoryID = WebshopProductCategories.WebshopProductMainCategoryID INNER JOIN WebshopProductLinks ON WebshopProductCategories.WebshopProductCategoryID = WebshopProductLinks.WebshopProductCategoryID INNER JOIN WebshopProducts ON WebshopProductLinks.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID 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 WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID 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 (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.WebshopProductVariantID = 5981) GROUP BY WebshopProductMainCategories.WebshopProductMainCategoryID ORDER BY WebshopProductMainCategories.Position
Server shutdown in progress
Bestand " /home/bohero/domains/bohero.eu/public_html/core/frontend/webshopproducts/webshopproductmaincategories.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/bohero/domains/bohero.eu/public_html/core/frontend/webshopproducts/webshopproductmaincategories.php op lijn 217
Implementatie bestand /home/bohero/domains/bohero.eu/public_html/core/frontend/webshopproducts/webshopproductcontroller.php op lijn 708