SELECT * FROM (
(SELECT '0' as comment_type, f.hidden, (SELECT author FROM answers WHERE getid = t.id ORDER BY date DESC LIMIT 1) as author, t.id, t.author as threadcreator, f.id as headid, (SELECT id FROM answers WHERE getid = t.id ORDER BY date DESC LIMIT 1) as answerid, f.name as headname, t.topic, i.src, COUNT(a.id) as answers, (SELECT date FROM answers WHERE getid = t.id ORDER BY date DESC LIMIT 1) as date
FROM answers as a
LEFT JOIN threads as t ON t.id = a.getid
LEFT JOIN forum_sub as f ON f.id = t.head
LEFT JOIN images as i ON f.icon = i.id
WHERE NOT t.topic = '' AND t.head IN (SELECT id FROM forum_sub WHERE id = t.head) AND (f.hidden = 0 OR (f.hidden = 1 AND (f.id = '' OR f.id = '') ))
GROUP BY t.id
ORDER BY (SELECT date FROM answers WHERE getid = t.id ORDER BY date DESC LIMIT 1) DESC
)
UNION
(SELECT '0' as comment_type, f.hidden, t.author, t.id, t.author as threadcreator, t.head as headid, '0' as answerid, f.name as headname, t.topic, i.src, '0' as answers, t.date
FROM threads as t
LEFT JOIN forum_sub as f ON f.id = t.head
LEFT JOIN images as i ON f.icon = i.id
WHERE NOT t.topic = '' AND t.head IN (SELECT id FROM forum_sub WHERE id = t.head) AND (f.hidden = 0 OR (f.hidden = 1 AND (f.id = '' OR f.id = '') ))
GROUP BY t.id
ORDER BY t.date DESC
)
UNION
(SELECT '1' as comment_type, '0' as hidden, c.author, CONCAT('news',c.getid) AS id, '0' as threadcreator, c.getid as headid, (SELECT id FROM comments WHERE getid = c.getid ORDER BY date DESC LIMIT 1) as answerid, '' as headname, (SELECT headline FROM news WHERE id = c.getid) as topic, '' as src, '0' as answers,
(SELECT date FROM comments WHERE getid = c.getid ORDER BY date DESC LIMIT 1) as date
FROM comments as c
WHERE c.censor != '1' AND c.type = 1
GROUP BY CONCAT('news',c.getid)
ORDER BY c.id DESC
LIMIT 12
)
) AS subtable
WHERE NOT topic = ''
GROUP BY id
ORDER BY date DESC
LIMIT 12
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DaDa
