select p_ID,p_title as p_title,p_class,p_no,p_item as p_item,class_name as class_name from product left join p_class on p_class=class_ID where p_type>0 and (p_class='2' ) order by field( p_class,) ASC, p_level ASC, p_crTime DESC