Comments on: Fun with ANALYZE TABLE https://www.lafferty.ca/2008/09/17/fun-with-analyze-table/ Rich Lafferty's OLD blog Wed, 17 Sep 2008 13:16:10 +0000 hourly 1 https://wordpress.org/?v=5.9.2 By: Drew https://www.lafferty.ca/2008/09/17/fun-with-analyze-table/comment-page-1/#comment-56220 Wed, 17 Sep 2008 13:16:10 +0000 http://www.lafferty.ca/?p=943#comment-56220 I know this isn’t the point of this entry, but I must admit that I hate hate hate that style of writing inner joins. I much prefer them like this:

SELECT …
FROM phpbb_topics t
inner join phpbb_posts p on p.post_id = t.topic_last_post_id
inner join phpbb_posts_text pt on pt.post_id = p.post_id
inner join phpbb_users u on u.user_id = p.poster_id
inner join phpbb_forums f on f.forum_id = t.forum_id
WHERE t.topic_status != 1
ORDER BY t.topic_last_post_id DESC
LIMIT 0, 15;

]]>