Overzicht van auteurs
No brands could be found
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 WebshopProductVariants ON WebshopProducts.WebshopProductID = WebshopProductVariants.WebshopProductID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN 1_WebshopProductProperties ON WebshopProducts.1_WebshopProductPropertyID = 1_WebshopProductProperties.1_WebshopProductPropertyID LEFT JOIN 2_WebshopProductProperties ON WebshopProducts.2_WebshopProductPropertyID = 2_WebshopProductProperties.2_WebshopProductPropertyID WHERE (ProductBrands.Name IS NOT NULL AND ProductBrands.Name != "") AND (WebshopProductSuperCategories.OnWebsiteEN = 1) AND (WebshopProductMainCategories.OnWebsiteEN = 1) AND (WebshopProductCategories.OnWebsiteEN = 1) GROUP BY ProductBrands.ProductBrandID ORDER BY ProductBrands.NameSELECT
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 WebshopProductVariants ON WebshopProducts.WebshopProductID = WebshopProductVariants.WebshopProductID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN 1_WebshopProductProperties ON WebshopProducts.1_WebshopProductPropertyID = 1_WebshopProductProperties.1_WebshopProductPropertyID LEFT JOIN 2_WebshopProductProperties ON WebshopProducts.2_WebshopProductPropertyID = 2_WebshopProductProperties.2_WebshopProductPropertyID WHERE (ProductBrands.Name IS NOT NULL AND ProductBrands.Name != "") AND (WebshopProductSuperCategories.OnWebsiteEN = 1) AND (WebshopProductMainCategories.OnWebsiteEN = 1) AND (WebshopProductCategories.OnWebsiteEN = 1) GROUP BY ProductBrands.ProductBrandID ORDER BY ProductBrands.NameUnknown column 'WebshopProductSuperCategories.OnWebsiteEN' in 'where clause'Searching