Array
(
[lang] => en
[id_masterGamme_LAVAL] => 2
[id_masterFamille_LAVAL] => 2900
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 1768
)
[sort] =>
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
WHERE ( tC.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE 1=1 AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND ( tC.id_masterTrieurParent = 6 AND tC.id_masterTrieurEnfant IN (1768) )) GROUP BY tC.id_masterPrix
[NUMBER] => 131
[texte] => 131 products
[received] => Array
(
[lang] => en
[id_masterGamme_LAVAL] => 2
[id_masterFamille_LAVAL] => 2900
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 1768
)
[sort] =>
)
)
ARBORESCENCE => TRIEUR
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND mPrix.id_masterPrix IN ( SELECT DISTINCT(mPrix.id_masterPrix) FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterTrieurEnfant IN (1768) ) ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND mPrix.id_masterPrix IN ( SELECT DISTINCT(mPrix.id_masterPrix) FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterTrieurEnfant IN (1768) ) ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 2
:id_masterFamille_LAVAL 2900
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant Array
:price_asked
:id_masterBoutikB =>
:search
:sort
NB PRODUIT => 131
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"TRIEUR","array_received":{"arborescence":"TRIEUR","id_masterGamme_LAVAL":"2","id_masterFamille_LAVAL":"2900","id_masterSSFamille_LAVAL":"","id_masterTrieurEnfant":["1768"],"price_asked":"","id_masterBoutikB":"","id_masterNiveau":null,"sort":"","lang":"en"},"id_client_received":null,"client":{"id_client":null,"email_client":null,"num_client":null,"statut_client":null,"id_masterNiveau":null,"label_niveau":null,"adresse":null,"ville":null,"id_pays":null,"pays":null,"id_masterCondition":null,"id_masterDelais":null,"condition_paiement":null,"delais_paiement":null,"tva":1,"ecotaxe":0,"compte_or":0,"langue":"fr","pbx_nom":null,"pbx_prenom":null,"pbx_adresse":null,"pbx_adresse2":null,"pbx_zipcode":null,"pbx_city":null,"pbx_countrycode":null,"pbx_mobilephone":null,"pbx_countrycodemobilephone":null},"autorisation":true}
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Viewing:
20 out of 131
items