โค้ด: เลือกทั้งหมด
SELECT t.*, tp.topic_posted, f.forum_name FROM (phpbb_topics t) LEFT JOIN phpbb_topics_posted tp ON (t.topic_id = tp.topic_id AND tp.user_id = 2) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id ) WHERE t.topic_time >= 1465118168 AND t.topic_id IN ('184', '185', '186')
โค้ด: เลือกทั้งหมด
SELECT t.*, tp.topic_posted, f.forum_name FROM (phpbb_topics t) LEFT JOIN phpbb_topics_posted tp ON (t.topic_id = tp.topic_id AND tp.user_id = 2) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id ) WHERE t.topic_time >= 1465118168