Select C.CTNO, C.CTPOSE, C.CTNAME, C.RANK, C.CHILD, C.TYPE From tops_cate C, tops_cate_setup CS where C.CTNO=CS.CTNO and CS.HIDDEN=2 Order by RANK Desc
¼±ÅÃµÈ µ¥ÀÌŸº£À̽º°¡ ¾ø½À´Ï´Ù.