Unnamed
public sql v1 · immutableSELECT c.`name` as catname, c.`safe_name` catsname, c.`id` as catid, f.`name`, f.`safe_name`, f.`id` as forumid, t.`id`, t.`title`, t.`updated`, u.`name` as last_user, t.`date` FROM `{$T->categories}` c LEFT OUTER JOIN (`{$T->forums}` f LEFT OUTER JOIN (`{$T->topics}` t LEFT OUTER JOIN `{$T->users}` u ON t.`userid` = u.`id`) ON f.`id` = t.`forumid`) ON f.`catid` = c.`id` ORDER BY c.`posid`, f.`posid` ASC