SELECT t. * , GROUP_CONCAT( ts.tag_name
SEPARATOR ',' ) AS tags, u.name AS user_name, uu.name AS edit_user_name
FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu
WHERE t.deleted =0
AND t.thread_id = tt.thread_id
AND ts.tag_id = tt.tag_id
AND t.user_id = u.user_id
AND t.edit_user_id = uu.user_id
GROUP BY t.thread_id
HAVING ts.tag_name
IN (
'test', 'moo'
)
LIMIT 0 , 30