All pastes #631501 Raw Edit

Unnamed

public sql v1 · immutable
#631501 ·published 2007-07-24 00:55 UTC
rendered paste body
SELECT 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