09/03/2011, 17:18
|
| | | Fecha de Ingreso: septiembre-2010
Mensajes: 5
Antigüedad: 13 años, 8 meses Puntos: 0 | |
| Respuesta: Ultimos 4 post de cada foro_id
SELECT *
FROM phpbb_topics
JOIN (SELECT topic_id,forum_id FROM phpbb_topics where forum_id=2 limit 4) AS t1
JOIN (SELECT topic_id,forum_id FROM phpbb_topics where forum_id=3 limit 4) AS t2
JOIN (SELECT topic_id,forum_id FROM phpbb_topics where forum_id=4 limit 4) AS t3
ON (phpbb_topics.topic_id = t3.topic_id or phpbb_topics.topic_id = t2.topic_id or phpbb_topics.topic_id = t1.topic_id)
group by phpbb_topics.topic_id order by phpbb_topics.forum_id
Con este sentencia ya me realiza bien xD |