SELECT k.id, k.title FROM tblKladr k LEFT JOIN tblKladr k1 ON k1.parent=k.id LEFT JOIN tblKladr k2 ON k2.parent=k1.id LEFT JOIN vacancy_kladr vk ON k2.id=vk.kladr_id LEFT JOIN smcontents_b_vacancy sbv ON vk.vacancy_id=sbv.id WHERE sbv.visible=1 and sbv.display=1 UNION SELECT k.id, k.title FROM tblKladr k LEFT JOIN tblKladr k1 ON k1.parent=k.id LEFT JOIN vacancy_kladr vk ON k1.id=vk.kladr_id LEFT JOIN smcontents_b_vacancy sbv ON vk.vacancy_id=sbv.id WHERE sbv.visible=1 and sbv.display=1 AND k1.level=2 UNION SELECT k.id, k.title FROM tblKladr k LEFT JOIN vacancy_kladr vk ON k.id=vk.kladr_id LEFT JOIN smcontents_b_vacancy sbv ON vk.vacancy_id=sbv.id WHERE sbv.visible=1 and sbv.display=1 AND k.level=1 GROUP BY k.id,k.title ORDER BY title
Table 'smcontents_b_vacancy' is marked as crashed and should be repaired