---

Echec : 1021 Disk full (/var/mysql/tmp/#sql_68d0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

---

SELECT tp.* , llp.*, lps.date_deb_pub_promo_pdt as date_deb_pub_promo_pdt_site, lps.date_fin_pub_promo_pdt as date_fin_pub_promo_pdt_site, lps.id_type_remise as id_type_remise_site, lps.remise_pdt as remise_pdt_site, tmillesime.libelle_millesime, llmillesime.nom_lang_millesime , tclassement.libelle_classement, llclassement.nom_lang_classement , tappellation.libelle_appellation, llappellation.nom_lang_appellation , tdomaine.libelle_domaine, lldomaine.nom_lang_domaine , tcepage.libelle_cepage, llcepage.nom_lang_cepage , tcontenance.libelle_contenance, llcontenance.nom_lang_contenance , tcouleur.libelle_couleur, llcouleur.nom_lang_couleur , tclimat.libelle_climat, llclimat.nom_lang_climat , tt.taux_tva FROM table_produit tp JOIN lien_langue_produit llp ON tp.id_pdt = llp.id_pdt JOIN lien_produit_site lps ON ( tp.id_pdt = lps.id_pdt AND lps.id_site = '8' AND lps.actif_pdt = '1' ) LEFT JOIN table_millesime tmillesime ON tp.id_millesime = tmillesime.id_millesime LEFT JOIN lien_langue_millesime llmillesime ON tp.id_millesime = llmillesime.id_millesime AND llmillesime.id_lang = '1' LEFT JOIN table_classement tclassement ON tp.id_classement = tclassement.id_classement LEFT JOIN lien_langue_classement llclassement ON tp.id_classement = llclassement.id_classement AND llclassement.id_lang = '1' LEFT JOIN table_appellation tappellation ON tp.id_appellation = tappellation.id_appellation LEFT JOIN lien_langue_appellation llappellation ON tp.id_appellation = llappellation.id_appellation AND llappellation.id_lang = '1' LEFT JOIN table_domaine tdomaine ON tp.id_domaine = tdomaine.id_domaine LEFT JOIN lien_langue_domaine lldomaine ON tp.id_domaine = lldomaine.id_domaine AND lldomaine.id_lang = '1' LEFT JOIN table_cepage tcepage ON tp.id_cepage = tcepage.id_cepage LEFT JOIN lien_langue_cepage llcepage ON tp.id_cepage = llcepage.id_cepage AND llcepage.id_lang = '1' LEFT JOIN table_contenance tcontenance ON tp.id_contenance = tcontenance.id_contenance LEFT JOIN lien_langue_contenance llcontenance ON tp.id_contenance = llcontenance.id_contenance AND llcontenance.id_lang = '1' LEFT JOIN table_couleur tcouleur ON tp.id_couleur = tcouleur.id_couleur LEFT JOIN lien_langue_couleur llcouleur ON tp.id_couleur = llcouleur.id_couleur AND llcouleur.id_lang = '1' LEFT JOIN table_climat tclimat ON tp.id_climat = tclimat.id_climat LEFT JOIN lien_langue_climat llclimat ON tp.id_climat = llclimat.id_climat AND llclimat.id_lang = '1' JOIN table_tva tt ON tp.id_tva = tt.id_tva JOIN lien_produit_famille lpf ON (tp.id_pdt = lpf.id_pdt AND lpf.id_fam IN ('2') ) JOIN lien_famille_site lfs ON ( lpf.id_fam = lfs.id_fam AND lfs.id_site = '8' AND lfs.actif_fam_site = '1' ) WHERE llp.id_lang = 1 AND tp.nb_stock > 0 AND tp.id_appellation IN ('78') AND tp.id_contenance IN ('1') GROUP BY tp.id_pdt ORDER BY llp.nom_lang_pdt DESC LIMIT 0, 15

---