SELECT
0 AS Active,Genders.GenderID,Genders.ExternalUID AS GenderUID,Genders.Name AS Gender,Genders.NameTranslations AS GenderTranslations,Genders.Slug AS GenderSlug,Genders.SlugTranslations AS GenderSlugTranslations,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,
WebshopProductSuperCategories.*,
null AS URL,
null AS Photos
FROM WebshopProductSuperCategories
LEFT JOIN RepositoryFiles ON WebshopProductSuperCategories.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 WebshopProductMainCategories ON WebshopProductSuperCategories.WebshopProductSuperCategoryID = WebshopProductMainCategories.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 INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN WebshopProductVariantDetails ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID AND WebshopProductVariantDetails.Stock > 0 INNER JOIN WebshopProductVariantDetailLocations ON WebshopProductVariantDetails.WebshopProductVariantDetailID = WebshopProductVariantDetailLocations.WebshopProductVariantDetailID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID INNER JOIN WebshopProductGenders ON WebshopProducts.WebshopProductID = WebshopProductGenders.WebshopProductID INNER JOIN Genders ON WebshopProductGenders.GenderID = Genders.GenderID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID 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 (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductSeasons.OnWebsite = 1) AND (WebshopProductVariants.Slug IS NOT NULL) AND (Stock > 0) AND (WebshopProductVariantDetails.Stock > 0) GROUP BY WebshopProductSuperCategories.WebshopProductSuperCategoryID, Genders.GenderID ORDER BY WebshopProductSuperCategories.Position
SELECT
0 AS Active,Genders.GenderID,Genders.ExternalUID AS GenderUID,Genders.Name AS Gender,Genders.NameTranslations AS GenderTranslations,Genders.Slug AS GenderSlug,Genders.SlugTranslations AS GenderSlugTranslations,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,
WebshopProductSuperCategories.*,
null AS URL,
null AS Photos
FROM WebshopProductSuperCategories
LEFT JOIN RepositoryFiles ON WebshopProductSuperCategories.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 WebshopProductMainCategories ON WebshopProductSuperCategories.WebshopProductSuperCategoryID = WebshopProductMainCategories.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 INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN WebshopProductVariantDetails ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID AND WebshopProductVariantDetails.Stock > 0 INNER JOIN WebshopProductVariantDetailLocations ON WebshopProductVariantDetails.WebshopProductVariantDetailID = WebshopProductVariantDetailLocations.WebshopProductVariantDetailID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID INNER JOIN WebshopProductGenders ON WebshopProducts.WebshopProductID = WebshopProductGenders.WebshopProductID INNER JOIN Genders ON WebshopProductGenders.GenderID = Genders.GenderID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID 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 (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductSeasons.OnWebsite = 1) AND (WebshopProductVariants.Slug IS NOT NULL) AND (Stock > 0) AND (WebshopProductVariantDetails.Stock > 0) GROUP BY WebshopProductSuperCategories.WebshopProductSuperCategoryID, Genders.GenderID ORDER BY WebshopProductSuperCategories.Position
Column 'Stock' in where clause is ambiguous Bestand " /home/fashiontea/domains/fashionteam.be/public_html/core/frontend/webshopproducts/webshopproductsupercategories.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/fashiontea/domains/fashionteam.be/public_html/core/frontend/webshopproducts/webshopproductsupercategories.php op lijn 228
Implementatie bestand /home/fashiontea/domains/fashionteam.be/public_html/core/frontend/webshopproducts/webshopproductcontroller.php op lijn 615
SELECT
0 AS Active,WebshopProductSuperCategories.WebshopProductSuperCategoryID,WebshopProductSuperCategories.Name AS SuperCategoryName,WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations,Genders.GenderID,Genders.ExternalUID AS GenderUID,Genders.Name AS Gender,Genders.NameTranslations AS GenderTranslations,Genders.Slug AS GenderSlug,Genders.SlugTranslations AS GenderSlugTranslations,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 INNER 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 INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN WebshopProductVariantDetails ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID AND WebshopProductVariantDetails.Stock > 0 INNER JOIN WebshopProductVariantDetailLocations ON WebshopProductVariantDetails.WebshopProductVariantDetailID = WebshopProductVariantDetailLocations.WebshopProductVariantDetailID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID INNER JOIN WebshopProductGenders ON WebshopProducts.WebshopProductID = WebshopProductGenders.WebshopProductID INNER JOIN Genders ON WebshopProductGenders.GenderID = Genders.GenderID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID 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 (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductSeasons.OnWebsite = 1) AND (WebshopProductVariants.Slug IS NOT NULL) AND (Stock > 0) AND (WebshopProductVariantDetails.Stock > 0) GROUP BY WebshopProductMainCategories.WebshopProductMainCategoryID, Genders.GenderID ORDER BY WebshopProductMainCategories.Position
SELECT
0 AS Active,WebshopProductSuperCategories.WebshopProductSuperCategoryID,WebshopProductSuperCategories.Name AS SuperCategoryName,WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations,Genders.GenderID,Genders.ExternalUID AS GenderUID,Genders.Name AS Gender,Genders.NameTranslations AS GenderTranslations,Genders.Slug AS GenderSlug,Genders.SlugTranslations AS GenderSlugTranslations,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 INNER 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 INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN WebshopProductVariantDetails ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID AND WebshopProductVariantDetails.Stock > 0 INNER JOIN WebshopProductVariantDetailLocations ON WebshopProductVariantDetails.WebshopProductVariantDetailID = WebshopProductVariantDetailLocations.WebshopProductVariantDetailID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID INNER JOIN WebshopProductGenders ON WebshopProducts.WebshopProductID = WebshopProductGenders.WebshopProductID INNER JOIN Genders ON WebshopProductGenders.GenderID = Genders.GenderID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID 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 (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductSeasons.OnWebsite = 1) AND (WebshopProductVariants.Slug IS NOT NULL) AND (Stock > 0) AND (WebshopProductVariantDetails.Stock > 0) GROUP BY WebshopProductMainCategories.WebshopProductMainCategoryID, Genders.GenderID ORDER BY WebshopProductMainCategories.Position
Column 'Stock' in where clause is ambiguous Bestand " /home/fashiontea/domains/fashionteam.be/public_html/core/frontend/webshopproducts/webshopproductmaincategories.php " veroorzaakt een fout bij
klant .
Functie aanroep bestand /home/fashiontea/domains/fashionteam.be/public_html/core/frontend/webshopproducts/webshopproductmaincategories.php op lijn 235
Implementatie bestand /home/fashiontea/domains/fashionteam.be/public_html/core/frontend/webshopproducts/webshopproductcontroller.php op lijn 644
Gibsy Middelkerke • Fashion Team
1
Blijf op de hoogte via Whatsapp
GRAAG ALS EERSTE OP DE HOOGTE VAN AL ONZE ACTIES & EVENTS? HELEMAAL GRATIS? DAT KAN VANAF NU OOK VIA WHATSAPP.
Voeg Fashion Team toe aan de contactenlijst van je telefoon, met het nummer +32 (0) 474 843482
Download WhatsApp (als je de app al op je smartphone hebt staan, kan je ineens naar stap 3).
Open WhatsApp en stuur ons een berichtje met je volledige naam en eventueel je favoriete merken.
Klaar! We sturen je een berichtje ter bevestiging en nemen jou op in onze verzendlijst