Просмотр объявлений » Вакансии » Все

SELECT SQL_CACHE * FROM job_section WHERE token IN ('active') ORDER BY sort ASC,id ASC,name ASC

SELECT SQL_CACHE section.id,COUNT(DISTINCT vacancy.id) AS cnt_vacancy FROM job_section AS section LEFT JOIN job_vacancy AS vacancy ON vacancy.id_section IN (section.id) WHERE section.token IN ('active') AND vacancy.token IN('active') GROUP BY section.id ORDER BY section.sort ASC,section.id ASC,section.name ASC

SELECT SQL_CACHE section.id,COUNT(DISTINCT resume_v.id) AS cnt_resume_v FROM job_section AS section LEFT JOIN job_resume AS resume_v ON resume_v.id_section IN (section.id) WHERE section.token IN ('active') AND resume_v.token IN ('active') AND resume_v.visibility IN ('visible','visiblehc') GROUP BY section.id ORDER BY section.sort ASC,section.id ASC,section.name ASC

SELECT SQL_CACHE section.id,COUNT(DISTINCT resume_m.id) AS cnt_resume_m FROM job_section AS section LEFT JOIN job_resume AS resume_m ON resume_m.id_section IN (section.id) WHERE section.token IN ('active') AND resume_m.token IN ('active') AND resume_m.visibility IN ('visible','visiblehc','members','membershc') GROUP BY section.id ORDER BY section.sort ASC,section.id ASC,section.name ASC

SELECT SQL_CACHE * FROM main_region WHERE token IN ('active') ORDER BY sort ASC,name ASC,id ASC

SELECT SQL_CACHE region.id,COUNT(DISTINCT vacancy.id) AS cnt_vacancy FROM main_region AS region LEFT JOIN job_vacancy AS vacancy ON vacancy.id_region IN (region.id) WHERE region.token IN ('active') AND vacancy.token IN('active') GROUP BY region.id ORDER BY region.sort ASC,region.name ASC,region.id ASC

SELECT SQL_CACHE region.id,COUNT(DISTINCT resume_v.id) AS cnt_resume_v FROM main_region AS region LEFT JOIN job_resume AS resume_v ON resume_v.id_region IN (region.id) WHERE region.token IN ('active') AND resume_v.token IN ('active') AND resume_v.visibility IN ('visible','visiblehc') GROUP BY region.id ORDER BY region.sort ASC,region.name ASC,region.id ASC

SELECT SQL_CACHE region.id,COUNT(DISTINCT resume_m.id) AS cnt_resume_m FROM main_region AS region LEFT JOIN job_resume AS resume_m ON resume_m.id_region IN (region.id) WHERE region.token IN ('active') AND resume_m.token IN ('active') AND resume_m.visibility IN ('visible','visiblehc','members','membershc') GROUP BY region.id ORDER BY region.sort ASC,region.name ASC,region.id ASC

SELECT id,title FROM job_pages WHERE token IN ('active') ORDER BY sort ASC

SELECT SQL_CACHE * FROM job_groups WHERE id IN ('guest') AND token IN ('active') LIMIT 0, 1

SELECT SQL_CACHE * FROM job_groups_resp WHERE id IN ('guest') AND token IN ('active') LIMIT 0, 1

SELECT SQL_CACHE SQL_CALC_FOUND_ROWS * FROM job_vacancy WHERE token IN ('active') ORDER BY vip DESC,hot DESC,rate DESC,act_datetime DESC,cnt_views_temp DESC,cnt_views_total DESC LIMIT 0, 6

SELECT FOUND_ROWS()

SELECT SQL_CALC_FOUND_ROWS * FROM job_vacancy WHERE hot AND token IN ('active') ORDER BY rate DESC,hot_unset_datetime DESC,RAND() LIMIT 0, 5

SELECT FOUND_ROWS()

SELECT id,title,small_text,datetime FROM job_news WHERE token IN ('active') AND datetime<=NOW() ORDER BY datetime DESC LIMIT 0, 3

SELECT SQL_CACHE COUNT(id) as num_rows FROM job_conf_users WHERE token IN ('active')

SELECT SQL_CACHE COUNT(id) as num_rows FROM job_vacancy WHERE token IN ('active')

SELECT SQL_CACHE COUNT(id) as num_rows FROM job_resume WHERE token IN ('active') AND visibility IN ('visible','visiblehc')

SELECT SQL_CACHE COUNT(id) as num_rows FROM job_resume WHERE token IN ('active') AND visibility IN ('visible','visiblehc','members','membershc')