MAISON

ARBORESCENCE => BOUTIKA
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS CASE WHEN mPrix.reference = 'EMBALCADEAU' AND ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) < 5 THEN 6 WHEN mPrix.reference = 'EMBALCADEAU' AND ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) >= 5 THEN 4.5 WHEN mPrix.reference <> 'EMBALCADEAU' AND ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) > 5 THEN ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) + 1 ELSE ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) END AS 'ROW', mPrix.* FROM masterPrix mPrix INNER JOIN prix_FR mPrixLang USING(id_masterPrix) LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND ( (mPrix.stock >= 0) OR (mPrix.indisponible = 1 AND mPrix.date_reception BETWEEN CURDATE() AND ADDDATE(CURDATE(), INTERVAL 7 DAY)) ) AND colProd.id_masterBoutikA = :id_masterBoutikA GROUP BY mPrix.id_masterProduit ORDER BY `ROW`ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS CASE WHEN mPrix.reference = 'EMBALCADEAU' AND ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) < 5 THEN 6 WHEN mPrix.reference = 'EMBALCADEAU' AND ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) >= 5 THEN 4.5 WHEN mPrix.reference <> 'EMBALCADEAU' AND ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) > 5 THEN ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) + 1 ELSE ROW_NUMBER() OVER (ORDER BY mPrix.reference ASC) END AS 'ROW', mPrix.* FROM masterPrix mPrix INNER JOIN prix_FR mPrixLang USING(id_masterPrix) LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND ( (mPrix.stock >= 0) OR (mPrix.indisponible = 1 AND mPrix.date_reception BETWEEN CURDATE() AND ADDDATE(CURDATE(), INTERVAL 7 DAY)) ) AND colProd.id_masterBoutikA = :id_masterBoutikA GROUP BY mPrix.id_masterProduit ORDER BY `ROW`ASC, mPrix.reference ASC LIMIT 0, 40
:id_masterBoutikA 5
:id_masterBoutikB 0
:id_masterBoutikC 0
:id_masterTrieurEnfant []
:price_asked
:search
NB PRODUIT => 15
NB BOUTIQUE => 15
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1