Failed to query of [ select subtable.* from ( select row_number() over(order by p_date desc) as rownum , p.p_no , p.p_date , p.p_title , p.p_text , mpc.pc_name , mpc.pc_ename from posts p inner join posts_categoly pc on p.p_no = pc.pc_pno inner join m_postscat mpc on mpc.pc_no = pc.pc_catno where pc.pc_catno = '34' and p.p_publish = 1 and p.p_no = ) as subtable order by subtable.p_date desc ]