MENU_ANNOUNCES_NAVIGATOR » FORM_VACANCYS_HEAD » FORM_ALL

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

SELECT SQL_CACHE * FROM job_groups_resp WHERE id='guest' AND token='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