SELECT a.id AS id, a.title AS title FROM smcontents_b_branch a left JOIN smcontents_b_vacancy b ON a.id = b.branch and b.branch <> 0 AND b.visible = 1 AND b.display = 1 GROUP BY a.id order by a.sort<br>Table 'smcontents_b_vacancy' is marked as crashed and should be repaired