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 FR = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.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_masterTrieurEnfant IN (3107) 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 FR = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.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_masterTrieurEnfant IN (3107) 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 => 4
NB BOUTIQUE => 4
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":["3107"],"price_asked":null,"id_masterBoutikB":null,"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},"autorisation":true}
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Ajouter aux favoris
Affichage :
4 sur 4
modèles