J'ai parlé trop vite
Il fallait metre ça
(SELECT `newsid`,`newsheadline`,`newsdate`,`surtitle`, `newscat` FROM news WHERE `newsdate` <= '2007-07-24' and `newscat` = 2 ORDER BY `newsdate` DESC LIMIT 4) UNION (SELECT `newsid`,`newsheadline`,`newsdate`,`surtitle`, `newscat` FROM news WHERE `newsdate` <= '2007-07-24' and `newscat` = 5 ORDER BY `newsdate` DESC LIMIT 4) UNION (SELECT `newsid`,`newsheadline`,`newsdate`,`surtitle`, `newscat` FROM news WHERE `newsdate` <= '2007-07-24' and `newscat` = 4 ORDER BY `newsdate` DESC LIMIT 4) UNION (SELECT `newsid`,`newsheadline`,`newsdate`,`surtitle`, `newscat` FROM news WHERE `newsdate` <= '2007-07-24' and `newscat` = 3 ORDER BY `newsdate` DESC LIMIT 4) UNION (SELECT `newsid`,`newsheadline`,`newsdate`,`surtitle`, `newscat` FROM news WHERE `newsdate` <= '2007-07-24' and `newscat` = 7 ORDER BY `newsdate` DESC LIMIT 4) UNION (SELECT `newsid`,`newsheadline`,`newsdate`,`surtitle`, `newscat` FROM news WHERE `newsdate` <= '2007-07-24' and `newscat` = 8 ORDER BY `newsdate` DESC LIMIT 4)
N'empêches, si quelqu'un a une autre solution, je suis preneur.
Partager