Select * from (select code as bcode, name as bname from red_bbs) A, red_bbs_data B where A.bcode = B.code and code in ('faq1', 'faq2') and notice < 1 order by ref desc, re_step ASC LIMIT 0;�, 15