Disk full (/tmp/#sql-temptable-32d028-47232d1-10e0cf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") - SELECT SQL_CALC_FOUND_ROWS * , cc.cc_id, tcc.t_title AS cc_title, tcc.t_vignette_alt AS cc_vignette_alt, tcc.t_alias AS cc_alias, tcc.t_clickable AS a_clickable, tcc.t_meta_title AS cc_meta_title, tc.t_title AS c_title, tc.t_alias AS c_alias, tc.t_clickable AS c_clickable, IF(cc_highlighted = 1, IF(cc_highlighted_start > 0 OR cc_highlighted_end > 0, IF(NOW() > cc_highlighted_start AND NOW() < cc_highlighted_end, 1, 0), 1), 0) as is_highlighted, CONCAT(',', GROUP_CONCAT(DISTINCT cce.el_id), ',') AS el_id_concat, GROUP_CONCAT(DISTINCT tcca.t_value) AS tcca_t_value FROM cms_content AS cc INNER JOIN cms_categorie AS c ON c_id=cc_categorie_id INNER JOIN cms_trad_content AS tcc ON (t_content_id=cc.cc_id AND tcc.t_lang='fr' AND t_published = 1) INNER JOIN cms_trad_categorie AS tc ON t_categorie_id=cc_categorie_id AND tc.t_lang='fr' left join cms_caracteristique car on car.ca_categorie_id = c.c_id left join cms_trad_caracteristique tcar on tcar.t_caracteristique_id = car.ca_id and tcar.t_lang = 'fr' left join cms_content_caracteristique cca on cca.cc_id = cc.cc_id left join cms_trad_content_caracteristique tcca on cca.cca_id = tcca.t_content_caracteristique_id and tcca.t_lang = 'fr' left join cms_content_caracteristique_element cce on cce.cca_id = cca.cca_id WHERE tcc.t_title!="" AND cc_categorie_id=38 AND cc_online = 1 AND (NOW() >= cc_start_at AND ((NOW() <= cc_end_at) OR (cc_end_at = "0000-00-00 00:00:00"))) GROUP BY cc.cc_id ORDER BY cc_order ASC LIMIT 0, 100