ARBORESCENCE => TRIEUR
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
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 EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (2680) GROUP BY tC.id_masterPrix ) ORDER BY mPrix.date_online DESC, mPrix.ordre_Gamme_LAVAL ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
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 EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (2680) GROUP BY tC.id_masterPrix ) ORDER BY mPrix.date_online DESC, mPrix.ordre_Gamme_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 8
:id_masterFamille_LAVAL
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant Array
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 36
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => nullAUTORISATION => {"type":"TRIEUR","array_received":{"arborescence":"TRIEUR","id_masterGamme_LAVAL":"8","id_masterFamille_LAVAL":null,"id_masterSSFamille_LAVAL":null,"id_masterTrieurEnfant":["2680"],"price_asked":null,"id_masterBoutikB":null,"lang":"en"},"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}
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Viewing:
20 out of 36
items