SELECT vacancy.*,
position.title_en AS position_en, position.title_ru AS position_ru,
industry.title_en AS industry_title_en, industry.title_ru AS industry_title_ru,
category.name_en AS category_title_en, category.name_ru AS category_title_ru
FROM (vacancy)
LEFT JOIN category ON (vacancy.category_id = category.id)
LEFT JOIN industry ON (vacancy.industry_id = industry.id)
LEFT JOIN position ON (position.id=vacancy.position)
WHERE experied_time >= 1337384432 AND (vacancy.industry_id = 39)
ORDER BY category_title_kz, position_kz
1054: Unknown column 'category_title_kz' in 'order clause'