"
SELECT
topic_title as titolo,
post_text as testo,
phpbb_topics.topic_id as id,
username as nomePoster,
topic_replies as risposte, /*Devi togliere la selezione delle risposte*/
topic_views as visite,
topic_time as data
FROM phpbb_topics
INNER JOIN phpbb_users ON phpbb_topics.topic_poster = phpbb_users.user_id
INNER JOIN phpbb_posts ON phpbb_topics.topic_id = phpbb_posts.topic_id
INNER JOIN phpbb_posts_text ON phpbb_posts.post_id = phpbb_posts_text.post_id
WHERE phpbb_topics.forum_id = 87
ORDER BY data DESC
LIMIT 0,2
";