SELECT ci_vacancies.*,ci_employer.*,ci_city.name as cityName, ci_vacancies_categories.*, ci_categories.name as name_category, ci_categories.parent_id as parent_id
            FROM ci_vacancies
            LEFT JOIN ci_employer ON(ci_vacancies.idEmployer = ci_employer.idEmployer)
            LEFT JOIN ci_city ON(ci_city.id = ci_employer.idCity)
            LEFT JOIN ci_vacancies_categories ON(ci_vacancies.idVacancies = ci_vacancies_categories.idVacancies)
            LEFT JOIN ci_categories ON (ci_vacancies_categories.idCategories = ci_categories.id)
            WHERE ci_vacancies.moderatorDenided != '1'
            AND ci_vacancies.closeStatus != '1'