'SELECT f.fid, f.fup, f.type, f.lastpost, p.author, p.dateline, p.pid, log.username, log.date ' . 'FROM ' . X_PREFIX . 'forums AS f ' . 'LEFT JOIN ( ' . ' SELECT pid, p3.fid, author, dateline FROM ' . X_PREFIX . 'posts AS p3 ' . ' INNER JOIN ( ' . ' SELECT p2.fid, MAX(pid) AS lastpid ' . ' FROM ' . X_PREFIX . 'posts AS p2 ' . ' INNER JOIN ( ' . ' SELECT fid, MAX(dateline) AS lastdate ' . ' FROM ' . X_PREFIX . 'posts ' . ' GROUP BY fid ' . ' ) AS query3 ON p2.fid=query3.fid AND p2.dateline=query3.lastdate ' . ' GROUP BY p2.fid ' . ' ) AS query2 ON p3.pid=query2.lastpid ' . ') AS p ON f.fid=p.fid ' . 'LEFT JOIN ( /* Self-join order is critical with no unique key available */ ' . ' SELECT log2.fid, log2.date, log2.username ' . ' FROM ' . X_PREFIX . 'logs AS log2 ' . ' INNER JOIN ( ' . ' SELECT fid, MAX(`date`) AS lastdate ' . ' FROM ' . X_PREFIX . 'logs ' . ' WHERE `action` = "bump" ' . ' GROUP BY fid ' . ' ) AS query4 ON log2.fid=query4.fid AND log2.date=query4.lastdate ' . ') AS log ON f.fid=log.fid ' . 'WHERE f.type="forum" OR f.type="sub"'

Issues