get_all

SELECT a.*, b.`theme` as theme, c.`theme` as theme2, d.`theme` as theme3, DATE_FORMAT(a.`date_debut`,'%d/%m/%Y %H:%i') as date_debut_fr, DATE_FORMAT(a.`date_debut`,'%Y-%m-%d') as date_debut_Ymd, DATE_FORMAT(a.`date_debut`,'%a, %b. %D, %Y %H:%i') as date_debut_en, DATE_FORMAT(a.`date_debut`,'%H:%i') as date_debut_Hi, UNIX_TIMESTAMP(a.`date_debut`) as dts_debut, DATE_FORMAT(a.`expiration`,'%d/%m/%Y %H:%i') as date_fin_fr, DATE_FORMAT(a.`expiration`,'%Y-%m-%d') as date_fin_Ymd, DATE_FORMAT(a.`expiration`,'%a, %b. %D, %Y %H:%i') as date_fin_en, DATE_FORMAT(a.`expiration`,'%H:%i') as date_fin_Hi, UNIX_TIMESTAMP(a.`expiration`) as dts_expir, DATE_FORMAT(a.`pub_date`,'%d/%m/%Y') as date_emission, UNIX_TIMESTAMP(a.`pub_date`) as dts, UNIX_TIMESTAMP(NOW()) as ndts FROM tbl_news a JOIN tbl_news_description b ON a.`id_theme` = b.`id_theme` JOIN tbl_news_description c ON a.`id_theme2` = c.`id_theme` JOIN tbl_news_description d ON a.`id_theme3` = d.`id_theme` WHERE a.news=1 AND a.publiable LIKE 'oui' AND a.moderateur<>'' AND serveur LIKE '%1%' AND a.`expiration` < NOW() AND (a.`id_theme`=4 OR a.`id_theme2`=4 OR a.`id_theme3`=4) AND DATE_FORMAT(a.`pub_date`,"%Y")=2007 ORDER By a.`pub_date` desc,`id_news` desc

SQLSTATE[HY000]: General error: 1021 Disk full (/var/tmp/#sql_520_0); waiting for someone to free some space...