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.PositionSELECT
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.PositionColumn 'Stock' in where clause is ambiguousSELECT
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.PositionSELECT
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.PositionColumn 'Stock' in where clause is ambiguousRestez 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.
Maandag - Zondag
09u30 tot 13u00 en 14u00 tot 18u30
Merken
Anne Claire
Cambio
Cinzia Rocca
Creenstone
Duno
Gigue
Grace
Herzen's
Hubert Gasser
Ilse Jacobsen
La Camicia
Luisa Cerano
Marccain
Mucho Gusto
Ralph Lauren
Riani
Toupy
Xandres