Boeken kopen - religieus en spiritueel

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 = 3143) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY 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 = 3143) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY PublishingDate DESC LIMIT 0, 1

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 ') AND (ProductBrands.ProductBrandID = 3143) GROUP BY WebshopProductVariants.Webs' at line 74
Bestand " /home/carmelitan/domains/carmelitana.be/public_html/core/frontend/webshopproducts/webshopproductvariants.php " veroorzaakt een fout bij klant .
Functie aanroep bestand /home/carmelitan/domains/carmelitana.be/public_html/core/frontend/webshopproducts/webshopproductvariants.php op lijn 364
Implementatie bestand /home/carmelitan/domains/carmelitana.be/public_html/pages/webshop_overview.php op lijn 212

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 = 3143) 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 = 3143) 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

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 ') AND (ProductBrands.ProductBrandID = 3143) AND (WebshopProductSuperCategories.O' at line 57
Bestand " /home/carmelitan/domains/carmelitana.be/public_html/core/library/database/database.class.php " veroorzaakt een fout bij klant .
Functie aanroep bestand /home/carmelitan/domains/carmelitana.be/public_html/core/library/database/database.class.php op lijn 572
Implementatie bestand /home/carmelitan/domains/carmelitana.be/public_html/core/frontend/webshopproducts/webshopproductvariants.php op lijn 1059

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 = 3143) 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 = 3143) 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

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 ') AND (ProductBrands.ProductBrandID = 3143) AND (WebshopProductSuperCategories.O' at line 57
Bestand " /home/carmelitan/domains/carmelitana.be/public_html/core/library/database/database.class.php " veroorzaakt een fout bij klant .
Functie aanroep bestand /home/carmelitan/domains/carmelitana.be/public_html/core/library/database/database.class.php op lijn 572
Implementatie bestand /home/carmelitan/domains/carmelitana.be/public_html/core/frontend/webshopproducts/webshopproductvariants.php op lijn 1217 Boeken kopen - religieus en spiritueel - Carmelitana

Searching

Er werden geen resultaten gevonden.

Je kan steeds opnieuw zoeken of de webshop bezoeken.

Deze website maakt gebruik van cookies!
Meer details over onze cookies kan je terugvinden in ons cookiebeleid