Array
(
[lang] => en
[id_masterGamme_LAVAL] => 4
[id_masterFamille_LAVAL] => 4
[id_masterSSFamille_LAVAL] => 36
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 623
)
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
WHERE tC.actif = 1 AND tC.EN = 1 AND tC.id_masterTrieurParent NOT IN (9,15) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND tC.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND tC.id_masterTrieurEnfant IN (623) GROUP BY tC.id_masterPrix ) GROUP BY tC.id_masterPrix
[NUMBER] => 312
[texte] => (312 products)
[received] => Array
(
[lang] => en
[id_masterGamme_LAVAL] => 4
[id_masterFamille_LAVAL] => 4
[id_masterSSFamille_LAVAL] => 36
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 623
)
)
)
ARBORESCENCE => TRIEUR
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND mPrix.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND tC.id_masterTrieurEnfant IN (623) GROUP BY tC.id_masterPrix ) ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_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)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND mPrix.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL AND tC.id_masterTrieurEnfant IN (623) GROUP BY tC.id_masterPrix ) ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 4
:id_masterFamille_LAVAL 4
:id_masterSSFamille_LAVAL 36
:eclatement
:id_masterTrieurEnfant Array
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 312
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"TRIEUR","array_received":{"arborescence":"TRIEUR","id_masterGamme_LAVAL":"4","id_masterFamille_LAVAL":"4","id_masterSSFamille_LAVAL":"36","id_masterTrieurEnfant":["623"],"price_asked":null,"id_masterBoutikB":null,"lang":"en"},"id_client_received":"","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},"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 312
items