SELECT WebshopProductSuperCategories.WebshopProductSuperCategoryID AS SuperCategoryID, WebshopProductSuperCategories.Name AS SuperCategoryName, WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations, WebshopProductMainCategories.WebshopProductMainCategoryID AS MainCategoryID, WebshopProductMainCategories.Name AS MainCategoryName, WebshopProductMainCategories.NameTranslations AS MainCategoryNameTranslations, WebshopProductCategories.WebshopProductCategoryID AS CategoryID, WebshopProductCategories.Name AS CategoryName, WebshopProductCategories.NameTranslations AS CategoryNameTranslations, WebshopProductCategories.ExternalUID AS CategoryExternalUID, 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, 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, WebshopProductVariants.*, null AS Details, null AS Photos, null AS Documents, null AS Relations FROM WebshopProductVariants INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails AS CheapestDetail ON CheapestDetail.WebshopProductVariantDetailID = (SELECT WebshopProductVariantDetails.WebshopProductVariantDetailID FROM WebshopProductVariantDetails INNER JOIN WebshopProductVariants AS SubWebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = SubWebshopProductVariants.WebshopProductVariantID WHERE SubWebshopProductVariants.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID GROUP BY WebshopProductVariantDetails.WebshopProductVariantDetailID ORDER BY 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 WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN SizeTables_Sizes ON WebshopProductVariantDetails.SizeTables_SizeID = SizeTables_Sizes.SizeTables_SizeID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductGroupVariants ON WebshopProductVariants.WebshopProductVariantID = WebshopProductGroupVariants.WebshopProductVariantID LEFT JOIN WebshopProductGroups ON WebshopProductGroupVariants.WebshopProductGroupID = WebshopProductGroups.WebshopProductGroupID 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 (ProductBrands.ProductBrandID = ) AND (ProductBrands.ProductBrandID = 973) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY WebshopProductVariants.PublishingDate DESC LIMIT 0, 1
SELECT WebshopProductSuperCategories.WebshopProductSuperCategoryID AS SuperCategoryID, WebshopProductSuperCategories.Name AS SuperCategoryName, WebshopProductSuperCategories.NameTranslations AS SuperCategoryNameTranslations, WebshopProductMainCategories.WebshopProductMainCategoryID AS MainCategoryID, WebshopProductMainCategories.Name AS MainCategoryName, WebshopProductMainCategories.NameTranslations AS MainCategoryNameTranslations, WebshopProductCategories.WebshopProductCategoryID AS CategoryID, WebshopProductCategories.Name AS CategoryName, WebshopProductCategories.NameTranslations AS CategoryNameTranslations, WebshopProductCategories.ExternalUID AS CategoryExternalUID, 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, 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, WebshopProductVariants.*, null AS Details, null AS Photos, null AS Documents, null AS Relations FROM WebshopProductVariants INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails AS CheapestDetail ON CheapestDetail.WebshopProductVariantDetailID = (SELECT WebshopProductVariantDetails.WebshopProductVariantDetailID FROM WebshopProductVariantDetails INNER JOIN WebshopProductVariants AS SubWebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = SubWebshopProductVariants.WebshopProductVariantID WHERE SubWebshopProductVariants.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID GROUP BY WebshopProductVariantDetails.WebshopProductVariantDetailID ORDER BY 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 WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID INNER JOIN SizeTables_Sizes ON WebshopProductVariantDetails.SizeTables_SizeID = SizeTables_Sizes.SizeTables_SizeID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductGroupVariants ON WebshopProductVariants.WebshopProductVariantID = WebshopProductGroupVariants.WebshopProductVariantID LEFT JOIN WebshopProductGroups ON WebshopProductGroupVariants.WebshopProductGroupID = WebshopProductGroups.WebshopProductGroupID 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 (ProductBrands.ProductBrandID = ) AND (ProductBrands.ProductBrandID = 973) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY WebshopProductVariants.PublishingDate DESC LIMIT 0, 1You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (ProductBrands.ProductBrandID = 973) GROUP BY WebshopProductVariants.Websh' at line 74
SELECT WebshopProductVariants.*, WebshopProductVariantDetails.WebshopProductVariantDetailID, 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), 1, 0 ), 1 ), 0 ) AS LowestbPromo, (MIN(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS LowestOldPriceVATin, 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 ), MIN(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MIN(WebshopProductVariantDetails.Price) ) * (1 + (VATRates.Rate / 100)) AS LowestPriceVATin, (MIN(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS PriceVATin, 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.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ), 0 ), IF (WebshopProductVariantDetails.PromoPercentage > 0, WebshopProductVariantDetails.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ) ) ), 0 ) AS PromoPercentage FROM WebshopProductVariantDetails INNER JOIN WebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID INNER JOIN WebshopProducts ON WebshopProductVariants.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductVariantDetails AS WebshopProductVariantStock ON WebshopProductVariantStock.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID 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 WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductGroupVariants ON WebshopProductVariants.WebshopProductVariantID = WebshopProductGroupVariants.WebshopProductVariantID LEFT JOIN WebshopProductGroups ON WebshopProductGroupVariants.WebshopProductGroupID = WebshopProductGroups.WebshopProductGroupID 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 (ProductBrands.ProductBrandID = ) AND (ProductBrands.ProductBrandID = 973) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductVariantDetails.Price != 0) 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 ), MIN(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MIN(WebshopProductVariantDetails.Price) )) ASC LIMIT 1
SELECT WebshopProductVariants.*, WebshopProductVariantDetails.WebshopProductVariantDetailID, 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), 1, 0 ), 1 ), 0 ) AS LowestbPromo, (MIN(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS LowestOldPriceVATin, 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 ), MIN(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MIN(WebshopProductVariantDetails.Price) ) * (1 + (VATRates.Rate / 100)) AS LowestPriceVATin, (MIN(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS PriceVATin, 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.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ), 0 ), IF (WebshopProductVariantDetails.PromoPercentage > 0, WebshopProductVariantDetails.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ) ) ), 0 ) AS PromoPercentage FROM WebshopProductVariantDetails INNER JOIN WebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID INNER JOIN WebshopProducts ON WebshopProductVariants.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductVariantDetails AS WebshopProductVariantStock ON WebshopProductVariantStock.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID 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 WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductGroupVariants ON WebshopProductVariants.WebshopProductVariantID = WebshopProductGroupVariants.WebshopProductVariantID LEFT JOIN WebshopProductGroups ON WebshopProductGroupVariants.WebshopProductGroupID = WebshopProductGroups.WebshopProductGroupID 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 (ProductBrands.ProductBrandID = ) AND (ProductBrands.ProductBrandID = 973) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductVariantDetails.Price != 0) 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 ), MIN(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MIN(WebshopProductVariantDetails.Price) )) ASC LIMIT 1You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (ProductBrands.ProductBrandID = 973) AND (WebshopProductSuperCategories.On' at line 57
SELECT WebshopProductVariants.*, WebshopProductVariantDetails.WebshopProductVariantDetailID, 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), 1, 0 ), 1 ), 0 ) AS LowestbPromo, (MAX(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS LowestOldPriceVATin, 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 ), MAX(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MAX(WebshopProductVariantDetails.Price) ) * (1 + (VATRates.Rate / 100)) AS LowestPriceVATin, (MAX(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS PriceVATin, 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.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ), 0 ), IF (WebshopProductVariantDetails.PromoPercentage > 0, WebshopProductVariantDetails.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ) ) ), 0 ) AS PromoPercentage FROM WebshopProductVariantDetails INNER JOIN WebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID INNER JOIN WebshopProducts ON WebshopProductVariants.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductVariantDetails AS WebshopProductVariantStock ON WebshopProductVariantStock.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID 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 WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductGroupVariants ON WebshopProductVariants.WebshopProductVariantID = WebshopProductGroupVariants.WebshopProductVariantID LEFT JOIN WebshopProductGroups ON WebshopProductGroupVariants.WebshopProductGroupID = WebshopProductGroups.WebshopProductGroupID 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 (ProductBrands.ProductBrandID = ) AND (ProductBrands.ProductBrandID = 973) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductVariantDetails.Price != 0) 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 ), MAX(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MAX(WebshopProductVariantDetails.Price) )) DESC LIMIT 1
SELECT WebshopProductVariants.*, WebshopProductVariantDetails.WebshopProductVariantDetailID, 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), 1, 0 ), 1 ), 0 ) AS LowestbPromo, (MAX(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS LowestOldPriceVATin, 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 ), MAX(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MAX(WebshopProductVariantDetails.Price) ) * (1 + (VATRates.Rate / 100)) AS LowestPriceVATin, (MAX(WebshopProductVariantDetails.Price) * (1 + (VATRates.Rate / 100))) AS PriceVATin, 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.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ), 0 ), IF (WebshopProductVariantDetails.PromoPercentage > 0, WebshopProductVariantDetails.PromoPercentage, (100 / (WebshopProductVariantDetails.Price / (WebshopProductVariantDetails.Price - WebshopProductVariantDetails.PromoPrice))) ) ) ), 0 ) AS PromoPercentage FROM WebshopProductVariantDetails INNER JOIN WebshopProductVariants ON WebshopProductVariantDetails.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID INNER JOIN WebshopProducts ON WebshopProductVariants.WebshopProductID = WebshopProducts.WebshopProductID INNER JOIN VATRates ON WebshopProducts.VATRateID = VATRates.VATRateID INNER JOIN WebshopProductVariantDetails AS WebshopProductVariantStock ON WebshopProductVariantStock.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID 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 WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID LEFT JOIN WebshopProductSeasons ON WebshopProducts.WebshopProductSeasonID = WebshopProductSeasons.WebshopProductSeasonID LEFT JOIN Seasons ON WebshopProductSeasons.SeasonID = Seasons.SeasonID LEFT JOIN Years ON WebshopProductSeasons.YearID = Years.YearID LEFT JOIN ProductBrands ON WebshopProducts.ProductBrandID = ProductBrands.ProductBrandID LEFT JOIN ProductCollections ON WebshopProducts.ProductCollectionID = ProductCollections.ProductCollectionID LEFT JOIN WebshopProductGroupVariants ON WebshopProductVariants.WebshopProductVariantID = WebshopProductGroupVariants.WebshopProductVariantID LEFT JOIN WebshopProductGroups ON WebshopProductGroupVariants.WebshopProductGroupID = WebshopProductGroups.WebshopProductGroupID 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 (ProductBrands.ProductBrandID = ) AND (ProductBrands.ProductBrandID = 973) AND (WebshopProductSuperCategories.OnWebsite = 1) AND (WebshopProductMainCategories.OnWebsite = 1) AND (WebshopProductCategories.OnWebsite = 1) AND (WebshopProducts.OnWebsite = 1) AND (WebshopProductVariants.OnWebsite = 1) AND (WebshopProductVariantDetails.Price != 0) 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 ), MAX(WebshopProductVariantDetails.Price) ), IF (WebshopProductVariantDetails.PromoPercentage > 0, (WebshopProductVariantDetails.Price - ((WebshopProductVariantDetails.Price / 100) * WebshopProductVariantDetails.PromoPercentage)), WebshopProductVariantDetails.PromoPrice ) ) ), MAX(WebshopProductVariantDetails.Price) )) DESC LIMIT 1You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (ProductBrands.ProductBrandID = 973) AND (WebshopProductSuperCategories.On' at line 57
Searching