Array
(
[lang] => fr
[id_masterGamme_LAVAL] => 8
[id_masterFamille_LAVAL] => 216
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
[sort] =>
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_FR 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) GROUP BY tC.id_masterPrix
[NUMBER] => 22
[texte] => 22 produits
[received] => Array
(
[lang] => fr
[id_masterGamme_LAVAL] => 8
[id_masterFamille_LAVAL] => 216
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
[sort] =>
)
)
ARBORESCENCE => FAMILLE
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
LEFT OUTER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mPrix.CategorieProduit = '' AND mPrix.reference_masterProduit = '' AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
LEFT OUTER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mPrix.CategorieProduit = '' AND mPrix.reference_masterProduit = '' AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 8
:id_masterFamille_LAVAL 216
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
:sort
NB PRODUIT => 22
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"FAMILLE","array_received":{"arborescence":"FAMILLE","id_masterGamme_LAVAL":"8","id_masterFamille_LAVAL":"216","id_masterSSFamille_LAVAL":"","id_masterTrieurEnfant":"","price_asked":"","id_masterBoutikB":"","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 22
modèles