SELECT categories id AS categories id categories parent AS categories

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
SELECT categories.id AS `categories.id`,
categories.parent AS `categories.parent`,
categories.module AS `categories.module`,
categories.title AS `categories.title`,
categories.description AS `categories.description`,
users.id AS `users.id`,
users.login AS `users.login`,
users.email AS `users.email`,
users.password AS `users.password`,
users.[group] AS `users.group`,
users.date AS `users.date`,
users.about AS `users.about`,
users.icq AS `users.icq`,
users.status AS `users.status`,
users.avatar AS `users.avatar`,
users.active AS `users.active`,
groups.id AS `groups.id`,
groups.title AS `groups.title`,
groups.description AS `groups.description`, * FROM content
LEFT JOIN `categories` ON
(content.category = categories.id)
LEFT JOIN `users` ON (content.author = users.id)
LEFT JOIN `groups` ON (content.[group] = groups.id)
WHERE content.[group] IN ('-1') ORDER BY sort DESC LIMIT 0,20