ARBORESCENCE => BOUTIK
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.* , CASE WHEN (( PHT_forcing < PHT_Promo OR PHT_Promo = 0 ) AND ( PHT_forcing < PHT OR PHT = 0 ) AND (PHT_forcing > 0)) THEN PHT_forcing WHEN PHT_promo < PHT_forcing AND PHT_promo < PHT AND PHT_promo > 0 THEN PHT_promo ELSE PHT END AS FinalPrice FROM masterPrix mPrix INNER JOIN prix_EN mPrixLang USING(id_masterPrix) LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN prixSecondevie prixSec ON mPrix.id_masterPrix = prixSec.id_masterPrix LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 )) AND mPrix.stock > 5 AND ( ( colProd.id_masterBoutikA IN (9001,9005,1000,1500,1600,1700,2000,2500,2600,3100) OR colProd.id_masterBoutikB IN (1020,1523,1702,2012,2510,3106,9003,9300) ) AND ( mPrix.PHT > 0 ) OR ( mPrix.forcing = 1 AND mPrix.PHT_forcing > 0) ) AND ( prixSec.seconde_vie_actif IS NULL || prixSec.seconde_vie_actif = 0 ) GROUP BY mPrix.id_masterPrix ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.* , CASE WHEN (( PHT_forcing < PHT_Promo OR PHT_Promo = 0 ) AND ( PHT_forcing < PHT OR PHT = 0 ) AND (PHT_forcing > 0)) THEN PHT_forcing WHEN PHT_promo < PHT_forcing AND PHT_promo < PHT AND PHT_promo > 0 THEN PHT_promo ELSE PHT END AS FinalPrice FROM masterPrix mPrix INNER JOIN prix_EN mPrixLang USING(id_masterPrix) LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN prixSecondevie prixSec ON mPrix.id_masterPrix = prixSec.id_masterPrix LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 )) AND mPrix.stock > 5 AND ( ( colProd.id_masterBoutikA IN (9001,9005,1000,1500,1600,1700,2000,2500,2600,3100) OR colProd.id_masterBoutikB IN (1020,1523,1702,2012,2510,3106,9003,9300) ) AND ( mPrix.PHT > 0 ) OR ( mPrix.forcing = 1 AND mPrix.PHT_forcing > 0) ) AND ( prixSec.seconde_vie_actif IS NULL || prixSec.seconde_vie_actif = 0 ) GROUP BY mPrix.id_masterPrix ORDER BY mPrix.reference ASC, mPrix.reference_fournisseur ASC LIMIT 0, 40
id_masterSurBoutik
id_masterBoutikA
id_masterBoutikB
id_masterBoutikC
id_masterTrieurEnfant ""
price_asked
search
order
int(1) shop
int(0) secondevie
NB PRODUIT => 573
NB BOUTIQUE => 40
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1