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 (8721, 8722, 8723, 8725, 8726)) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductMainCategories.WebshopProductMainCategoryID = 8) AND (ProductBrands.ProductBrandID = 254) AND (WebshopProducts.WebshopProductID != 8724) AND (WebshopProductVariantDetails.TotalStock > 0) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY WebshopProductVariants.VariantTypeID = 226 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 (8721, 8722, 8723, 8725, 8726)) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductMainCategories.WebshopProductMainCategoryID = 8) AND (ProductBrands.ProductBrandID = 254) AND (WebshopProducts.WebshopProductID != 8724) AND (WebshopProductVariantDetails.TotalStock > 0) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY WebshopProductVariants.VariantTypeID = 226 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 1067Protest zwemshort | Lingerie Marie
Op zoek naar een nieuwe, geweldige korte broek voor deze zomer? Bekijk dan eens de PRTWYTON uit de PVRE Green-serie van Protest, ons duurzame initiatief om groener te worden. Hij is gemaakt van gerecycled materiaal en er zijn geen PFC's gebruikt bij het aanbrengen van de waterbestendige finish. In plaats daarvan zijn milieuvriendelijke alternatieven gebruikt. De elastische tailleband met trekkoordje zorgt voor aan aansluitende en comfortabele pasvorm. Met handige achter- en zijzakken. Met een lengte van 16 inch langs de buitennaad en voorzien van een binnenslip en keycord is dit de enige boardshort die je deze zomer nodig hebt. De PRTWYTON heeft een regular fit.
Heb je geen idee welke maat je moet kiezen? Of weet je niet zeker wat jouw maat nu precies is? Geen zorgen, wij helpen je alvast op de goede weg. Lees hier onze tips om die te weten te komen!
