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