k4st

 SELECT t. * , GROUP_CONCAT( ts.tag_nameSEPARATOR ',' ) AS tags, u.name AS user_name, uu.name AS edit_user_nameFROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uuWHERE t.deleted =0AND t.thread_id = tt.thread_idAND ts.tag_id = tt.tag_idAND t.user_id = u.user_idAND t.edit_user_id = uu.user_idGROUP BY t.thread_idHAVING ts.tag_nameIN ('test', 'moo')LIMIT 0 , 30