select p_ID,p_title_eng as p_title,p_class,p_no,p_item_eng as p_item,class_name_eng 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