ARBORESCENCE => SURBOUTIK
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix INNER JOIN prix_FR mPrixLang USING(id_masterPrix) LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit LEFT OUTER JOIN masterSurBoutik_Navision_Collection MSBNC ON MSBNC.id_masterBoutikA = colProd.id_masterBoutikA AND ( MSBNC.id_masterBoutikB = colProd.id_masterBoutikB OR MSBNC.id_masterBoutikB = 0) AND ( MSBNC.id_masterBoutikC = colProd.id_masterBoutikC OR MSBNC.id_masterBoutikC = 0 ) WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 )) AND MSBNC.value = 1 AND MSBNC.id_masterSurBoutik = :id_masterSurBoutik GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_BoutikA, IF( FIELD( prixExc.code_marque, 20, 11, 40, 90 ) = 0, 1, 0 ) , FIELD( prixExc.code_marque, 20, 11, 40, 90 ), mPrix.reference, mPrix.reference_fournisseur ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix INNER JOIN prix_FR mPrixLang USING(id_masterPrix) LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit LEFT OUTER JOIN masterSurBoutik_Navision_Collection MSBNC ON MSBNC.id_masterBoutikA = colProd.id_masterBoutikA AND ( MSBNC.id_masterBoutikB = colProd.id_masterBoutikB OR MSBNC.id_masterBoutikB = 0) AND ( MSBNC.id_masterBoutikC = colProd.id_masterBoutikC OR MSBNC.id_masterBoutikC = 0 ) WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 )) AND MSBNC.value = 1 AND MSBNC.id_masterSurBoutik = :id_masterSurBoutik GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_BoutikA, IF( FIELD( prixExc.code_marque, 20, 11, 40, 90 ) = 0, 1, 0 ) , FIELD( prixExc.code_marque, 20, 11, 40, 90 ), mPrix.reference, mPrix.reference_fournisseur ASC LIMIT 0, 40
:id_masterSurBoutik 15
:id_masterBoutikA
:id_masterBoutikB
:id_masterBoutikC
:id_masterTrieurEnfant null
:price_asked
:search
NB PRODUIT => 10
NB BOUTIQUE => 10
LIMIT => LIMIT 0, 40
PAGE DEMANDE => 1