Array
(
[lang] => es
[id_masterGamme_LAVAL] => 0
[id_masterFamille_LAVAL] => 0
[id_masterSSFamille_LAVAL] => 0
[id_masterBoutikB] => 290
[arborescence] => COLLECTION
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] =>
[sort] =>
)
Array
(
[SQL] => SELECT *
FROM selection_ES Selection
INNER JOIN trieurCollection tC USING(id_masterPrix)
INNER JOIN masterPrix mPrix ON mPrix.id_masterPrix = Selection.id_masterPrix
INNER JOIN prix_ES mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_ES GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_ES FAMILLE ON mProd.id_masterFamille_LAVAL = FAMILLE.id_masterFamille_LAVAL
WHERE ( tC.actif = 1 AND mPrixLang.actif = 1 ) AND Selection.id_masterSelection = 368 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] => 156
[texte] => 156 productos
[received] => Array
(
[lang] => es
[id_masterGamme_LAVAL] => 0
[id_masterFamille_LAVAL] => 0
[id_masterSSFamille_LAVAL] => 0
[id_masterBoutikB] => 290
[arborescence] => COLLECTION
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] =>
[sort] =>
)
)
ARBORESCENCE => COLLECTION
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.*
FROM selection_ES Selection
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_ES mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_ES GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_ES 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 = 368 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_ES Selection
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_ES mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_ES GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_ES 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 = 368 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 => 290
:search
:sort
NB PRODUIT => 156
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":"290","id_masterNiveau":null,"sort":"","lang":"es"},"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}
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Visualización :
20 de 156
modelos