SELECT WebshopProductSuperCategories.WebshopProductSuperCategoryID, WebshopProductSuperCategories.Name AS SuperCategoryName, WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations, WebshopProductSuperCategories.Slug AS SuperCategorySlug, WebshopProductSuperCategories.SlugTranslations AS SuperCategorySlugTranslations, WebshopProductMainCategories.WebshopProductMainCategoryID, WebshopProductMainCategories.Name AS MainCategoryName, WebshopProductMainCategories.NameTranslations AS MainCategoryNameTranslations, WebshopProductCategories.WebshopProductCategoryID, WebshopProductCategories.Name AS CategoryName, WebshopProductCategories.NameTranslations AS CategoryNameTranslations, WebshopProductSubCategories.WebshopProductSubCategoryID, WebshopProductSubCategories.Name AS SubCategoryName, WebshopProductSubCategories.NameTranslations AS SubCategoryNameTranslations, ProductBrands.ProductBrandID, ProductBrands.Name AS BrandName, ProductBrands.NameTranslations AS BrandNameTranslations, ProductCollections.ProductCollectionID, ProductCollections.Name AS CollectionName, ProductCollections.NameTranslations AS CollectionNameTranslations, WebshopProducts.Name AS ProductName, WebshopProducts.NameTranslations AS ProductNameTranslations, VATRates.Rate AS VATRate, VATRates.Name AS VATName, WebshopProducts.WebshopProductSeasonID, CheapestDetail.WebshopProductVariantDetailID,
IF (CheapestDetail.PromoPercentage > 0 OR CheapestDetail.PromoPrice > 0,
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
1,
0
),
1
),
0
) AS LowestbPromo,
IF (CheapestDetail.PromoPercentage > 0,
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
1,
0
),
1
),
0
) AS LowestbPromoPercentage,
(MIN(CheapestDetail.Price) * (1 + (VATRates.Rate / 100))) AS LowestOldPriceVATin,
IF (CheapestDetail.PromoPercentage > 0 OR CheapestDetail.PromoPrice > 0,
(
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
IF (CheapestDetail.PromoPercentage > 0,
(CheapestDetail.Price - ((CheapestDetail.Price / 100) * CheapestDetail.PromoPercentage)),
CheapestDetail.PromoPrice
),
MIN(CheapestDetail.Price)
),
IF (CheapestDetail.PromoPercentage > 0,
(CheapestDetail.Price - ((CheapestDetail.Price / 100) * CheapestDetail.PromoPercentage)),
CheapestDetail.PromoPrice
)
)
),
MIN(CheapestDetail.Price)
) * (1 + (VATRates.Rate / 100)) AS LowestPriceVATin,
(MIN(CheapestDetail.Price) * (1 + (VATRates.Rate / 100))) AS PriceVATin,
IF (CheapestDetail.PromoPercentage > 0 OR CheapestDetail.PromoPrice > 0,
(
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
IF (CheapestDetail.PromoPercentage > 0,
CheapestDetail.PromoPercentage,
(100 / (CheapestDetail.Price / (CheapestDetail.Price - CheapestDetail.PromoPrice)))
),
0
),
IF (CheapestDetail.PromoPercentage > 0,
CheapestDetail.PromoPercentage,
(100 / (CheapestDetail.Price / (CheapestDetail.Price - CheapestDetail.PromoPrice)))
)
)
),
0
) AS PromoPercentage, VariantTypes.Name AS VariantTypeName,
VariantTypes.NameTranslations AS VariantTypeNameTranslations,
VariantTypes.Color,
VariantSubTypes.Name AS VariantSubTypeName,
VariantSubTypes.NameTranslations AS VariantSubTypeNameTranslations,
WebshopProductVariants.*,
WebshopProducts.Description AS ProductDescription,
WebshopProducts.DescriptionTranslations AS ProductDescriptionTranslations,
WebshopProducts.Description2 AS Description2,
WebshopProducts.Description2Translations AS Description2Translations,
VariantSubTypes.RepositoryFileID,
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,
null AS Details,
null AS Photos,
null AS Documents,
null AS Relations, WebshopProductVariantDetailReferences.ExternalUID, WebshopProductVariantDetailReferences.ArticleNumber FROM WebshopProductVariants
INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID
LEFT JOIN VariantSubTypes ON WebshopProductVariants.VariantSubTypeID = VariantSubTypes.VariantSubTypeID
LEFT JOIN RepositoryFiles ON VariantSubTypes.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 WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID INNER JOIN WebshopProductVariantDetailReferences ON WebshopProductVariantDetails.WebshopProductVariantDetailReferenceID = WebshopProductVariantDetailReferences.WebshopProductVariantDetailReferenceID INNER JOIN WebshopProductVariantDetails AS CheapestDetail ON CheapestDetail.WebshopProductVariantDetailID = (SELECT
WebshopProductVariantDetails.WebshopProductVariantDetailID
FROM WebshopProductVariantDetails
INNER JOIN WebshopProductVariants AS SubWebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = SubWebshopProductVariants.WebshopProductVariantID
INNER JOIN WebshopProductVariantDetailReferences AS SubWebshopProductVariantDetailReferences ON WebshopProductVariantDetails.WebshopProductVariantDetailReferenceID = SubWebshopProductVariantDetailReferences.WebshopProductVariantDetailReferenceID
WHERE SubWebshopProductVariants.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID
AND SubWebshopProductVariantDetailReferences.OnWebsite = 1
GROUP BY WebshopProductVariantDetails.WebshopProductVariantDetailID
ORDER BY IF (WebshopProductVariantDetails.PromoPercentage > 0 OR WebshopProductVariantDetails.PromoPrice > 0,
(
IF ((WebshopProductVariantDetails.PromoDateFrom > 0 AND WebshopProductVariantDetails.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(WebshopProductVariantDetails.PromoDateFrom) AND FROM_UNIXTIME(WebshopProductVariantDetails.PromoDateTill),
IF (WebshopProductVariantDetails.PromoPercentage > 0,
(WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)),
WebshopProductVariantDetails.PromoPrice
),
WebshopProductVariantDetails.Price
),
IF (WebshopProductVariantDetails.PromoPercentage > 0,
(WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)),
WebshopProductVariantDetails.PromoPrice
)
)
),
WebshopProductVariantDetails.Price
) ASC
LIMIT 1) INNER JOIN WebshopProducts ON WebshopProductVariants.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductLinks ON WebshopProducts.WebshopProductID = WebshopProductLinks.WebshopProductID INNER JOIN WebshopProductCategories ON WebshopProductLinks.WebshopProductCategoryID = WebshopProductCategories.WebshopProductCategoryID INNER JOIN WebshopProductMainCategories ON WebshopProductCategories.WebshopProductMainCategoryID = WebshopProductMainCategories.WebshopProductMainCategoryID INNER JOIN WebshopProductSuperCategories ON WebshopProductMainCategories.WebshopProductSuperCategoryID = WebshopProductSuperCategories.WebshopProductSuperCategoryID INNER JOIN WebshopProductSubCategories ON WebshopProductCategories.WebshopProductCategoryID = WebshopProductSubCategories.WebshopProductCategoryID INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID WHERE (WebshopProductVariants.WebshopProductID IN (7626, 7627, 7628, 7629, 894)) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductMainCategories.WebshopProductMainCategoryID = 17) AND (ProductBrands.ProductBrandID = 6) AND (WebshopProducts.WebshopProductID != 22) AND (WebshopProductVariantDetails.TotalStock > 0) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY WebshopProductVariants.VariantTypeID = 213 DESC, WebshopProductVariants.VariantSubTypeID = DESC, WebshopProductVariants.DateAdd DESC, WebshopProductVariants.Position
SELECT WebshopProductSuperCategories.WebshopProductSuperCategoryID, WebshopProductSuperCategories.Name AS SuperCategoryName, WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations, WebshopProductSuperCategories.Slug AS SuperCategorySlug, WebshopProductSuperCategories.SlugTranslations AS SuperCategorySlugTranslations, WebshopProductMainCategories.WebshopProductMainCategoryID, WebshopProductMainCategories.Name AS MainCategoryName, WebshopProductMainCategories.NameTranslations AS MainCategoryNameTranslations, WebshopProductCategories.WebshopProductCategoryID, WebshopProductCategories.Name AS CategoryName, WebshopProductCategories.NameTranslations AS CategoryNameTranslations, WebshopProductSubCategories.WebshopProductSubCategoryID, WebshopProductSubCategories.Name AS SubCategoryName, WebshopProductSubCategories.NameTranslations AS SubCategoryNameTranslations, ProductBrands.ProductBrandID, ProductBrands.Name AS BrandName, ProductBrands.NameTranslations AS BrandNameTranslations, ProductCollections.ProductCollectionID, ProductCollections.Name AS CollectionName, ProductCollections.NameTranslations AS CollectionNameTranslations, WebshopProducts.Name AS ProductName, WebshopProducts.NameTranslations AS ProductNameTranslations, VATRates.Rate AS VATRate, VATRates.Name AS VATName, WebshopProducts.WebshopProductSeasonID, CheapestDetail.WebshopProductVariantDetailID,
IF (CheapestDetail.PromoPercentage > 0 OR CheapestDetail.PromoPrice > 0,
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
1,
0
),
1
),
0
) AS LowestbPromo,
IF (CheapestDetail.PromoPercentage > 0,
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
1,
0
),
1
),
0
) AS LowestbPromoPercentage,
(MIN(CheapestDetail.Price) * (1 + (VATRates.Rate / 100))) AS LowestOldPriceVATin,
IF (CheapestDetail.PromoPercentage > 0 OR CheapestDetail.PromoPrice > 0,
(
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
IF (CheapestDetail.PromoPercentage > 0,
(CheapestDetail.Price - ((CheapestDetail.Price / 100) * CheapestDetail.PromoPercentage)),
CheapestDetail.PromoPrice
),
MIN(CheapestDetail.Price)
),
IF (CheapestDetail.PromoPercentage > 0,
(CheapestDetail.Price - ((CheapestDetail.Price / 100) * CheapestDetail.PromoPercentage)),
CheapestDetail.PromoPrice
)
)
),
MIN(CheapestDetail.Price)
) * (1 + (VATRates.Rate / 100)) AS LowestPriceVATin,
(MIN(CheapestDetail.Price) * (1 + (VATRates.Rate / 100))) AS PriceVATin,
IF (CheapestDetail.PromoPercentage > 0 OR CheapestDetail.PromoPrice > 0,
(
IF ((CheapestDetail.PromoDateFrom > 0 AND CheapestDetail.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(CheapestDetail.PromoDateFrom) AND FROM_UNIXTIME(CheapestDetail.PromoDateTill),
IF (CheapestDetail.PromoPercentage > 0,
CheapestDetail.PromoPercentage,
(100 / (CheapestDetail.Price / (CheapestDetail.Price - CheapestDetail.PromoPrice)))
),
0
),
IF (CheapestDetail.PromoPercentage > 0,
CheapestDetail.PromoPercentage,
(100 / (CheapestDetail.Price / (CheapestDetail.Price - CheapestDetail.PromoPrice)))
)
)
),
0
) AS PromoPercentage, VariantTypes.Name AS VariantTypeName,
VariantTypes.NameTranslations AS VariantTypeNameTranslations,
VariantTypes.Color,
VariantSubTypes.Name AS VariantSubTypeName,
VariantSubTypes.NameTranslations AS VariantSubTypeNameTranslations,
WebshopProductVariants.*,
WebshopProducts.Description AS ProductDescription,
WebshopProducts.DescriptionTranslations AS ProductDescriptionTranslations,
WebshopProducts.Description2 AS Description2,
WebshopProducts.Description2Translations AS Description2Translations,
VariantSubTypes.RepositoryFileID,
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,
null AS Details,
null AS Photos,
null AS Documents,
null AS Relations, WebshopProductVariantDetailReferences.ExternalUID, WebshopProductVariantDetailReferences.ArticleNumber FROM WebshopProductVariants
INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID
LEFT JOIN VariantSubTypes ON WebshopProductVariants.VariantSubTypeID = VariantSubTypes.VariantSubTypeID
LEFT JOIN RepositoryFiles ON VariantSubTypes.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 WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID INNER JOIN WebshopProductVariantDetailReferences ON WebshopProductVariantDetails.WebshopProductVariantDetailReferenceID = WebshopProductVariantDetailReferences.WebshopProductVariantDetailReferenceID INNER JOIN WebshopProductVariantDetails AS CheapestDetail ON CheapestDetail.WebshopProductVariantDetailID = (SELECT
WebshopProductVariantDetails.WebshopProductVariantDetailID
FROM WebshopProductVariantDetails
INNER JOIN WebshopProductVariants AS SubWebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = SubWebshopProductVariants.WebshopProductVariantID
INNER JOIN WebshopProductVariantDetailReferences AS SubWebshopProductVariantDetailReferences ON WebshopProductVariantDetails.WebshopProductVariantDetailReferenceID = SubWebshopProductVariantDetailReferences.WebshopProductVariantDetailReferenceID
WHERE SubWebshopProductVariants.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID
AND SubWebshopProductVariantDetailReferences.OnWebsite = 1
GROUP BY WebshopProductVariantDetails.WebshopProductVariantDetailID
ORDER BY IF (WebshopProductVariantDetails.PromoPercentage > 0 OR WebshopProductVariantDetails.PromoPrice > 0,
(
IF ((WebshopProductVariantDetails.PromoDateFrom > 0 AND WebshopProductVariantDetails.PromoDateTill > 0),
IF (NOW() BETWEEN FROM_UNIXTIME(WebshopProductVariantDetails.PromoDateFrom) AND FROM_UNIXTIME(WebshopProductVariantDetails.PromoDateTill),
IF (WebshopProductVariantDetails.PromoPercentage > 0,
(WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)),
WebshopProductVariantDetails.PromoPrice
),
WebshopProductVariantDetails.Price
),
IF (WebshopProductVariantDetails.PromoPercentage > 0,
(WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)),
WebshopProductVariantDetails.PromoPrice
)
)
),
WebshopProductVariantDetails.Price
) ASC
LIMIT 1) INNER JOIN WebshopProducts ON WebshopProductVariants.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductLinks ON WebshopProducts.WebshopProductID = WebshopProductLinks.WebshopProductID INNER JOIN WebshopProductCategories ON WebshopProductLinks.WebshopProductCategoryID = WebshopProductCategories.WebshopProductCategoryID INNER JOIN WebshopProductMainCategories ON WebshopProductCategories.WebshopProductMainCategoryID = WebshopProductMainCategories.WebshopProductMainCategoryID INNER JOIN WebshopProductSuperCategories ON WebshopProductMainCategories.WebshopProductSuperCategoryID = WebshopProductSuperCategories.WebshopProductSuperCategoryID INNER JOIN WebshopProductSubCategories ON WebshopProductCategories.WebshopProductCategoryID = WebshopProductSubCategories.WebshopProductCategoryID INNER JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID WHERE (WebshopProductVariants.WebshopProductID IN (7626, 7627, 7628, 7629, 894)) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductMainCategories.WebshopProductMainCategoryID = 17) AND (ProductBrands.ProductBrandID = 6) AND (WebshopProducts.WebshopProductID != 22) AND (WebshopProductVariantDetails.TotalStock > 0) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY WebshopProductVariants.VariantTypeID = 213 DESC, WebshopProductVariants.VariantSubTypeID = DESC, WebshopProductVariants.DateAdd DESC, WebshopProductVariants.Position
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC, WebshopProductVariants.DateAdd DESC, WebshopProductVariants.Position' at line 114 Bestand " /var/www/vhosts/lingeriemarie.be/httpdocs/core/frontend/webshopproducts/webshopproductvariants.php " veroorzaakt een fout bij
klant Lingerie Marie.
Functie aanroep bestand /var/www/vhosts/lingeriemarie.be/httpdocs/core/frontend/webshopproducts/webshopproductvariants.php op lijn 445
Implementatie bestand /var/www/vhosts/lingeriemarie.be/httpdocs/core/frontend/webshopproducts/webshopproductcontroller.php op lijn 1067Anita sport Bh Air Control | Lingerie Marie
Stevige ondersteuning, ademend en extreem licht! De sportbeha air control Deltapad garandeert, dankzij de exclusief ontwikkelde en gepatenteerde schuimschalen "Deltapad", optimale ondersteuning en een permanente luchtcirculatie voor een perfect huidklimaat ("Anita Sweat Management"). Door het mesh ontstaat een unieke look met maximale functionaliteit. De schalen zijn smal uitgesneden zodat het decolleté het beste tot haar recht komt.
Heb je geen idee welke maat je hebt? Lees hier onze tips om die te weten te komen!
Hoe kies je de juiste bh-maat? Op zoek naar een nieuwe BH, maar je weet helaas niet 100% zeker wat jouw maat is? Geen zorgen, wij helpen je alvast op de goede weg.
Wij bij Lingerie Marie hebben alvast een mooie stap per stap handleiding uitgeschreven die je helpt bij het uitvoeren van de meting!
