FORM_VIEW_ANNOUNCE_HEAD » FORM_VACANCYS_HEAD » Специалист 1С

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 * FROM job_vacancy WHERE token IN ('active') AND id IN ('11') LIMIT 0, 1

UPDATE job_vacancy SET cnt_views_temp_datetime='',cnt_views_last_ip='89.208.89.2',cnt_views_total=cnt_views_total+1,cnt_views_temp=cnt_views_temp+1 WHERE id IN ('11')

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