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 잡혀있습니다.
근데 이쿼리가 넘 보기싫으네요..--;
|