SELECT STRAIGHT_JOIN 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, WebshopProducts.ExternalUID AS ProductExternalUID, WebshopProducts.Name AS ProductName, WebshopProducts.NameTranslations AS ProductNameTranslations, WebshopProducts.Description AS ProductDescription, WebshopProducts.DescriptionTranslations AS ProductDescriptionTranslations, 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,
CheapestDetail.Price,
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 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 STRAIGHT_JOIN
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 (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) 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 LEFT JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID WHERE (WebshopProductVariants.WebshopProductVariantID IN (531,,317,1314)) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY FIELD(WebshopProductVariants.WebshopProductVariantID,531,,317,1314) LIMIT 0, 30SELECT STRAIGHT_JOIN 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, WebshopProducts.ExternalUID AS ProductExternalUID, WebshopProducts.Name AS ProductName, WebshopProducts.NameTranslations AS ProductNameTranslations, WebshopProducts.Description AS ProductDescription, WebshopProducts.DescriptionTranslations AS ProductDescriptionTranslations, 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,
CheapestDetail.Price,
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 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 STRAIGHT_JOIN
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 (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) 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 LEFT JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID WHERE (WebshopProductVariants.WebshopProductVariantID IN (531,,317,1314)) AND (WebshopProductVariants.Spotlight = 1) GROUP BY WebshopProductVariants.WebshopProductVariantID ORDER BY FIELD(WebshopProductVariants.WebshopProductVariantID,531,,317,1314) LIMIT 0, 30
PDOException
| |
PDOException » Main
| Message |
SQLSTATE[42000]: Syntax error or access violation: 1064 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 '317,1314)) AND (WebshopProductVariants.Spotlight = 1)' at line 4 |
| File |
/home/rentevent/domains/rentevent.be/public_html/library/database/data
base.class.php |
| Line |
560 |
| Date |
Sat, 18 May 2024 06:09:18 +0200 |
| URL |
http://www.rentevent.be/fr/webshop/1263/algemeen///
|
| Referring URL |
Unknown Referrer
|
| Request Method |
GET |
| PHP error |
Undefined index: CustomerSettings |
|
| |
PDOException » Variables
| $_GET |
Array
(
[s1] => algemeen
[s2] =>
[s3] =>
[s4] =>
[n1] => 63
[set_lang] => fr
[SuperCategoryName] => algemeen
[MainCategoryName] =>
[CategoryName] =>
[Name] =>
[WebshopProductVariantID] => 63
)
|
| $_POST |
Array
(
)
|
| $_SESSION |
Array
(
[SelectedDeliveryCountry] => 20
[SelectedDeliveryMethod] => 2
[Discounts] => Array
(
)
[DiscountCodes] => Array
(
)
[ReservedCadeaucheque] => Array
(
)
[ChequesToUseToPay] => Array
(
)
[rentevent.beRequestPage_keypage_nl] => Array
(
[0] => Array
(
[RequestPage] => aanmelden
[keypage] => aanmelden
)
[1] => Array
(
[RequestPage] => activate
[keypage] => activate
)
[2] => Array
(
[RequestPage] => admin
[keypage] => admin
)
[3] => Array
(
[RequestPage] => admin
[keypage] => algemene-verhuurvoorwaarden
)
[4] => Array
(
[RequestPage] => algemene-voorwaarden
[keypage] => algemene-voorwaarden
)
[5] => Array
(
[RequestPage] => Array
[keypage] => Array
)
[6] => Array
(
[RequestPage] => betaalmethode
[keypage] => betaalmethode
)
[7] => Array
(
[RequestPage] => betalen
[keypage] => betalen
)
[8] => Array
(
[RequestPage] => bevestigen
[keypage] => bevestigen
)
[9] => Array
(
[RequestPage] => bevestiging
[keypage] => bevestiging
)
[10] => Array
(
[RequestPage] => contact
[keypage] => contact
)
[11] => Array
(
[RequestPage] => cookies
[keypage] => cookies
)
[12] => Array
(
[RequestPage] => disclaimer
[keypage] => disclaimer
)
[13] => Array
(
[RequestPage] => faq
[keypage] => faq
)
[14] => Array
(
[RequestPage] => frontendtemplate
[keypage] => frontendtemplate
)
[15] => Array
(
[RequestPage] => home
[keypage] => home
)
[16] => Array
(
[RequestPage] => horloges
[keypage] => horloges
)
[17] => Array
(
[RequestPage] => admin
[keypage] => info
)
[18] => Array
(
[RequestPage] => inloggen
[keypage] => inloggen
)
[19] => Array
(
[RequestPage] => je-gegevens
[keypage] => je-gegevens
)
[20] => Array
(
[RequestPage] => leveringsmethode
[keypage] => leveringsmethode
)
[21] => Array
(
[RequestPage] => mailing
[keypage] => mailing
)
[22] => Array
(
[RequestPage] => mijn-gegevens
[keypage] => mijn-gegevens
)
[23] => Array
(
[RequestPage] => mijn-orders
[keypage] => mijn-orders
)
[24] => Array
(
[RequestPage] => mijn-profiel
[keypage] => mijn-profiel
)
[25] => Array
(
[RequestPage] => nieuwigheden
[keypage] => nieuwigheden
)
[26] => Array
(
[RequestPage] => nieuws
[keypage] => nieuws
)
[27] => Array
(
[RequestPage] => nieuwsbrief
[keypage] => nieuwsbrief
)
[28] => Array
(
[RequestPage] => nieuwsbrief-optin
[keypage] => nieuwsbrief-optin
)
[29] => Array
(
[RequestPage] => overons
[keypage] => overons
)
[30] => Array
(
[RequestPage] => privacy
[keypage] => privacy
)
[31] => Array
(
[RequestPage] => reset
[keypage] => reset
)
[32] => Array
(
[RequestPage] => seopage
[keypage] => seopage
)
[33] => Array
(
[RequestPage] => synchronize
[keypage] => synchronize
)
[34] => Array
(
[RequestPage] => tracking
[keypage] => tracking
)
[35] => Array
(
[RequestPage] => uitloggen
[keypage] => uitloggen
)
[36] => Array
(
[RequestPage] => veelgestelde-vragen
[keypage] => veelgestelde-vragen
)
[37] => Array
(
[RequestPage] => webshoo
[keypage] => webshoo
)
[38] => Array
(
[RequestPage] => webshop
[keypage] => webshop
)
[39] => Array
(
[RequestPage] => webshop-detail
[keypage] => webshop-detail
)
[40] => Array
(
[RequestPage] => winkelmandje
[keypage] => winkelmandje
)
[41] => Array
(
[RequestPage] => zoeken
[keypage] => zoeken
)
)
[VARIANT_HISTORY] => Array
(
[0] => 1155
[1] => 1211
[2] => 748
[3] => 1038
[4] => 137
[5] => 1314
[6] => 317
[7] =>
[8] => 531
[9] => 63
)
[Products] => Array
(
)
[Sequence] =>
[rentevent.beRequestPage_keypage_fr] => Array
(
[0] => Array
(
[RequestPage] => inscrivez
[keypage] => aanmelden
)
[1] => Array
(
[RequestPage] => activate
[keypage] => activate
)
[2] => Array
(
[RequestPage] => admin
[keypage] => admin
)
[3] => Array
(
[RequestPage] => admin
[keypage] => algemene-verhuurvoorwaarden
)
[4] => Array
(
[RequestPage] => conditions-generales
[keypage] => algemene-voorwaarden
)
[5] => Array
(
[RequestPage] => Array
[keypage] => Array
)
[6] => Array
(
[RequestPage] => betaalmethode
[keypage] => betaalmethode
)
[7] => Array
(
[RequestPage] => payer
[keypage] => betalen
)
[8] => Array
(
[RequestPage] => confirmation
[keypage] => bevestigen
)
[9] => Array
(
[RequestPage] => confirmation
[keypage] => bevestiging
)
[10] => Array
(
[RequestPage] => contact
[keypage] => contact
)
[11] => Array
(
[RequestPage] => cookies
[keypage] => cookies
)
[12] => Array
(
[RequestPage] => disclaimer
[keypage] => disclaimer
)
[13] => Array
(
[RequestPage] => faq
[keypage] => faq
)
[14] => Array
(
[RequestPage] => frontendtemplate
[keypage] => frontendtemplate
)
[15] => Array
(
[RequestPage] => acceuil
[keypage] => home
)
[16] => Array
(
[RequestPage] => horloges
[keypage] => horloges
)
[17] => Array
(
[RequestPage] => admin
[keypage] => info
)
[18] => Array
(
[RequestPage] => inloggen
[keypage] => inloggen
)
[19] => Array
(
[RequestPage] => je-gegevens
[keypage] => je-gegevens
)
[20] => Array
(
[RequestPage] => leveringsmethode
[keypage] => leveringsmethode
)
[21] => Array
(
[RequestPage] => mailing
[keypage] => mailing
)
[22] => Array
(
[RequestPage] => mijn-gegevens
[keypage] => mijn-gegevens
)
[23] => Array
(
[RequestPage] => mes-commandes
[keypage] => mijn-orders
)
[24] => Array
(
[RequestPage] => mon-profil
[keypage] => mijn-profiel
)
[25] => Array
(
[RequestPage] => nouvelles
[keypage] => nieuwigheden
)
[26] => Array
(
[RequestPage] => nouvelles
[keypage] => nieuws
)
[27] => Array
(
[RequestPage] => bulletin
[keypage] => nieuwsbrief
)
[28] => Array
(
[RequestPage] => nieuwsbrief-optin
[keypage] => nieuwsbrief-optin
)
[29] => Array
(
[RequestPage] => a-propos-de-nous
[keypage] => overons
)
[30] => Array
(
[RequestPage] => privacy
[keypage] => privacy
)
[31] => Array
(
[RequestPage] => reset
[keypage] => reset
)
[32] => Array
(
[RequestPage] => seopage
[keypage] => seopage
)
[33] => Array
(
[RequestPage] => synchronize
[keypage] => synchronize
)
[34] => Array
(
[RequestPage] => tracking
[keypage] => tracking
)
[35] => Array
(
[RequestPage] => deconnecter
[keypage] => uitloggen
)
[36] => Array
(
[RequestPage] => questions-frequentes
[keypage] => veelgestelde-vragen
)
[37] => Array
(
[RequestPage] => webshoo
[keypage] => webshoo
)
[38] => Array
(
[RequestPage] => webshop
[keypage] => webshop
)
[39] => Array
(
[RequestPage] => webshop-detail
[keypage] => webshop-detail
)
[40] => Array
(
[RequestPage] => panier
[keypage] => winkelmandje
)
[41] => Array
(
[RequestPage] => zoeken
[keypage] => zoeken
)
)
)
|
| $_COOKIE |
Array
(
[PHPSESSID] => 62lvd63tvtbiej2ngj18c6e7r0
)
|
| $_FILES |
Array
(
)
|
|
| |
PDOException » Trace
| File |
/home/rentevent/domains/rentevent.be/public_html/library/database/data
base.class.php
|
| Line |
560
|
| Class |
PDOStatement
|
| Function |
execute
|
|
| File |
/home/rentevent/domains/rentevent.be/public_html/frontend/webshopprodu
cts/webshopproductvariants.php
|
| Line |
460
|
| Class |
Database
|
| Function |
getVar
|
| Argument(s) |
Array
(
[0] => SELECT STRAIGHT_JOIN
COUNT( DISTINCT WebshopProductVariants.WebshopProductVariantID) AS NumberOfResults
FROM WebshopProductVariants
INNER JOIN VariantTypes ON WebshopProductVariants.VariantTypeID = VariantTypes.VariantTypeID LEFT JOIN WebshopProductVariantDetails AS WebshopProductVariantStock ON WebshopProductVariantStock.WebshopProductVariantID = WebshopProductVariants.WebshopProductVariantID LEFT JOIN WebshopProductVariantDetails ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantDetails.WebshopProductVariantID 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 LEFT JOIN WebshopProductVariantPhotos ON WebshopProductVariants.WebshopProductVariantID = WebshopProductVariantPhotos.WebshopProductVariantID WHERE (WebshopProductVariants.WebshopProductVariantID IN (531,,317,1314)) AND (WebshopProductVariants.Spotlight = 1)
)
|
|
| File |
/home/rentevent/domains/rentevent.be/public_html/frontend/webshopprodu
cts/webshopproductcontroller.php
|
| Line |
1253
|
| Class |
WebshopProductVariants
|
| Function |
getVariantCount
|
|
| File |
/home/rentevent/domains/rentevent.be/public_html/frontend/webshopprodu
cts/webshopproductcontroller.php
|
| Line |
239
|
| Class |
WebshopProductController
|
| Function |
getVariantCount
|
|
| File |
/home/rentevent/domains/rentevent.be/public_html/frontend/webshopprodu
cts/webshopproductcontroller.php
|
| Line |
188
|
| Class |
WebshopProductController
|
| Function |
collectData
|
|
| File |
/home/rentevent/domains/rentevent.be/public_html/pages/customer_settin
gs.php
|
| Line |
369
|
| Class |
WebshopProductController
|
| Function |
getOverview
|
|
|
|
|