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
Outlet Fashion Team
1
Restez informé par Whatsapp
VOULEZ-VOUS ÊTRE LE PREMIER À ÊTRE INFORMÉ DE TOUTES NOS ACTIONS ET ÉVÉNEMENTS ? ENTIÈREMENT GRATUIT ? À PARTIR DE MAINTENANT, VOUS POUVEZ LE FAIRE VIA WHATSAPP.
Ajoutez Fashion Team à la liste de contacts de votre téléphone, avec le numéro +32 (0) 474 843482.
Téléchargez WhatsApp (si vous avez déjà l'application sur votre smartphone, vous pouvez passer à l'étape 3).
Ouvrez WhatsApp et envoyez-nous un message avec votre nom complet et éventuellement vos marques préférées.
C'est ça ! Nous vous enverrons un message de confirmation et vous ajouterons à notre liste de diffusion.
