Array
(
[lang] => es
[id_masterGamme_LAVAL] => 5
[id_masterFamille_LAVAL] => 21
[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_ES 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] => 772
[texte] => 772 productos
[received] => Array
(
[lang] => es
[id_masterGamme_LAVAL] => 5
[id_masterFamille_LAVAL] => 21
[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_ES 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 tC.id_masterTrieurParent IN (9) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.ordre_Famille_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 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 tC.id_masterTrieurParent IN (9) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 5
:id_masterFamille_LAVAL 21
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
:sort
NB PRODUIT => 463
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"FAMILLE","array_received":{"arborescence":"FAMILLE","id_masterGamme_LAVAL":"5","id_masterFamille_LAVAL":"21","id_masterSSFamille_LAVAL":"","id_masterTrieurEnfant":"","price_asked":"","id_masterBoutikB":"","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
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
NUEVO
Registrar como favorito
Visualización :
20 de 463
modelos