select a.* from (select * from qz_quiz where quz_tg_use=1 and quz_tg_quiz = 1 and quz_sq_category = 1 order by quz_sq_quiz desc limit 3) a

union all

select b.* from (select * from qz_quiz where quz_tg_use=1 and quz_tg_quiz = 1 and quz_sq_category = 2 order by quz_sq_quiz desc limit 3) b

union all

select c.* from (select * from qz_quiz where quz_tg_use=1 and quz_tg_quiz = 1 and quz_sq_category = 3 order by quz_sq_quiz desc limit 3) c

union all

select d.* from (select * from qz_quiz where quz_tg_use=1 and quz_tg_quiz = 1 and quz_sq_category = 4 order by quz_sq_quiz desc limit 3) d

union all

select e.* from (select * from qz_quiz where quz_tg_use=1 and quz_tg_quiz = 1 and quz_sq_category = 5 order by quz_sq_quiz desc limit 3) e

quz_tg_use, quz_tg_quiz 얘들은 index 잡혀있습니다.

근데 이쿼리가 넘 보기싫으네요..--;