Array
(
[lang] => en
[id_masterGamme_LAVAL] => 0
[id_masterFamille_LAVAL] => 0
[id_masterSSFamille_LAVAL] => 0
[id_masterBoutikB] => 206
[arborescence] => COLLECTION
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] =>
[sort] =>
)
Array
(
[SQL] => SELECT *
FROM selection_EN Selection
INNER JOIN trieurCollection tC USING(id_masterPrix)
INNER JOIN masterPrix mPrix ON mPrix.id_masterPrix = Selection.id_masterPrix
INNER JOIN prix_EN mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_EN GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_EN FAMILLE ON mProd.id_masterFamille_LAVAL = FAMILLE.id_masterFamille_LAVAL
WHERE ( tC.actif = 1 AND mPrixLang.actif = 1 ) AND Selection.id_masterSelection = 268 AND Selection.actif = 1 AND tC.id_masterTrieurParent NOT IN (9,15) AND GAMME.actif = 1 AND FAMILLE.actif = 1 GROUP BY mPrix.id_masterPrix
[NUMBER] => 61
[texte] => 61 products
[received] => Array
(
[lang] => en
[id_masterGamme_LAVAL] => 0
[id_masterFamille_LAVAL] => 0
[id_masterSSFamille_LAVAL] => 0
[id_masterBoutikB] => 206
[arborescence] => COLLECTION
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] =>
[sort] =>
)
)
ARBORESCENCE => COLLECTION
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.*
FROM selection_EN Selection
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_EN mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_EN GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_EN FAMILLE ON mProd.id_masterFamille_LAVAL = FAMILLE.id_masterFamille_LAVAL
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 )
AND GAMME.actif = 1 AND FAMILLE.actif = 1
AND Selection.id_masterSelection = 268 AND Selection.actif = 1 GROUP BY mPrix.id_masterPrix ORDER BY Selection.ordre ASC, Selection.id_selection DESC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.*
FROM selection_EN Selection
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_EN mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_EN GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_EN FAMILLE ON mProd.id_masterFamille_LAVAL = FAMILLE.id_masterFamille_LAVAL
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 )
AND GAMME.actif = 1 AND FAMILLE.actif = 1
AND Selection.id_masterSelection = 268 AND Selection.actif = 1 GROUP BY mPrix.id_masterPrix ORDER BY Selection.ordre ASC, Selection.id_selection DESC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 0
:id_masterFamille_LAVAL 0
:id_masterSSFamille_LAVAL 0
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB => 206
:search
:sort
NB PRODUIT => 61
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"COLLECTION","array_received":{"arborescence":"COLLECTION","id_masterGamme_LAVAL":0,"id_masterFamille_LAVAL":0,"id_masterSSFamille_LAVAL":0,"id_masterTrieurEnfant":"","price_asked":"","id_masterBoutikB":"206","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 61
items