select work.*,work.id as workid,work_tp.id,work_tp.tp_name,cm.id,cm.cm_logo from work,work_tp,cm where work.dstate=0 and work.cpy_psn =13 and work.cpy_psn=work_tp.id and work.cpy_id=cm.id and work.cpy_pay>150 and work.cpy_pay<200 and work.cpy_time>0 order by work.cpy_hit desc