Array
(
[lang] => fr
[id_masterGamme_LAVAL] => 5
[id_masterFamille_LAVAL] => 18
[id_masterSSFamille_LAVAL] => 189
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
WHERE tC.actif = 1 AND tC.FR = 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_FR mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND FR = 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 GROUP BY tC.id_masterPrix ) GROUP BY tC.id_masterPrix
[NUMBER] => 55
[texte] => (55 produits)
[received] => Array
(
[lang] => fr
[id_masterGamme_LAVAL] => 5
[id_masterFamille_LAVAL] => 18
[id_masterSSFamille_LAVAL] => 189
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
)
)
ARBORESCENCE => SSFAMILLE
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 USING(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 AND mProd.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL GROUP BY mPrix.id_masterProduit ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_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 USING(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 AND mProd.id_masterSSFamille_LAVAL = :id_masterSSFamille_LAVAL GROUP BY mPrix.id_masterProduit ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 5
:id_masterFamille_LAVAL 18
:id_masterSSFamille_LAVAL 189
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 53
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"SSFAMILLE","array_received":{"arborescence":"SSFAMILLE","id_masterGamme_LAVAL":"5","id_masterFamille_LAVAL":"18","id_masterSSFamille_LAVAL":"189","id_masterTrieurEnfant":null,"price_asked":null,"id_masterBoutikB":null,"lang":"fr"},"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}
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 53
modèles