Array
(
[lang] => fr
[id_masterGamme_LAVAL] => 0
[id_masterFamille_LAVAL] => 0
[id_masterSSFamille_LAVAL] => 0
[id_masterBoutikB] => 289
[arborescence] => COLLECTION
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] =>
[sort] =>
)
Array
(
[SQL] => SELECT *
FROM selection_FR Selection
INNER JOIN trieurCollection tC USING(id_masterPrix)
INNER JOIN masterPrix mPrix ON mPrix.id_masterPrix = Selection.id_masterPrix
INNER JOIN prix_FR mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_FR GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_FR FAMILLE ON mProd.id_masterFamille_LAVAL = FAMILLE.id_masterFamille_LAVAL
WHERE ( tC.actif = 1 AND mPrixLang.actif = 1 ) AND Selection.id_masterSelection = 370 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] => 160
[texte] => 160 produits
[received] => Array
(
[lang] => fr
[id_masterGamme_LAVAL] => 0
[id_masterFamille_LAVAL] => 0
[id_masterSSFamille_LAVAL] => 0
[id_masterBoutikB] => 289
[arborescence] => COLLECTION
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] =>
[sort] =>
)
)
ARBORESCENCE => COLLECTION
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.*
FROM selection_FR Selection
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_FR mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_FR GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_FR 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 = 370 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_FR Selection
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_FR mPrixLang ON mPrix.id_masterPrix = mPrixLang.id_masterPrix
INNER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
INNER JOIN Gamme_LAVAL_FR GAMME ON mProd.id_masterGamme_LAVAL = GAMME.id_masterGamme_LAVAL
INNER JOIN Famille_LAVAL_FR 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 = 370 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 => 289
:search
:sort
NB PRODUIT => 160
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":"289","id_masterNiveau":null,"sort":"","lang":"fr"},"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}
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Affichage :
20 sur 160
modèles