SELECT * FROM job_zpinfo i LEFT JOIN job_zp z ON i.zid=z.id WHERE 1 and issh=1 ORDER BY i.dateline DESC, i.id DESC