1 2 3 4 5 6 7 8 9
| SELECT * FROM (
(SELECT bougie.id_avis as idn, bougie.date_ajout as dte, avis.id_avis, avis.nom, avis.genre, avis.prenom, avis.localite, avis.private FROM bougie, avis WHERE bougie.valid=1 AND avis.id_avis=bougie.id_avis GROUP BY bougie.id_avis ORDER BY bougie.date_ajout DESC LIMIT 10)
UNION ALL
(SELECT message.id_avis as idn, message.date_ajout as dte, avis.id_avis, avis.nom, avis.genre, avis.prenom, avis.localite, avis.private FROM message, avis WHERE message.valid=1 AND avis.id_avis=message.id_avis GROUP BY message.id_avis ORDER BY message.date_ajout DESC LIMIT 10)
UNION ALL
(SELECT photo.id_avis as idn, photo.date_ajout as dte, avis.id_avis, avis.nom, avis.genre, avis.prenom, avis.localite, avis.private FROM photo, avis WHERE photo.valid=1 AND avis.id_avis=photo.id_avis GROUP BY photo.id_avis ORDER BY photo.date_ajout DESC LIMIT 10)) AS tmp
GROUP BY idn
ORDER BY dte DESC
LIMIT 10 |
Partager