Array
(
[lang] => es
[id_masterGamme_LAVAL] => 7
[id_masterFamille_LAVAL] => 147
[id_masterSSFamille_LAVAL] => 475
[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.ES = 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_ES mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND ES = 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] => 30
[texte] => (30 productos)
[received] => Array
(
[lang] => es
[id_masterGamme_LAVAL] => 7
[id_masterFamille_LAVAL] => 147
[id_masterSSFamille_LAVAL] => 475
[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_ES 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 tC.id_masterTrieurParent IN (13) 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, tC.id_masterTrieurEnfant 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_ES 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 tC.id_masterTrieurParent IN (13) 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, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, mPrix.ordre_SSFamille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 7
:id_masterFamille_LAVAL 147
:id_masterSSFamille_LAVAL 475
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 11
NB BOUTIQUE => 11
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => nullAUTORISATION => {"type":"SSFAMILLE","array_received":{"arborescence":"SSFAMILLE","id_masterGamme_LAVAL":"7","id_masterFamille_LAVAL":"147","id_masterSSFamille_LAVAL":"475","id_masterTrieurEnfant":null,"price_asked":null,"id_masterBoutikB":null,"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},"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
Visualización :
11 de 11
modelos