Vacancies Search

Debugging information for A1 Locums webmaster:

Total SQL: SELECT v.vacancy_id, v.county, v.job_type, v.job_period, v.job_title, v.start_date, v.end_date, v.open_flag, v.asap_flag, v.date_registered, v.visibility_status, a.n_v_paye, a.n_v_sole_trader, a.n_v_umbrella, a.n_v_limited FROM a1_vacancies v LEFT JOIN a1_attributes a ON v.vacancy_id = a.vacancy_id WHERE visibility_status = 'Website' AND v.date_registered BETWEEN '2015-07-03 00:00:00.000000' AND '2025-07-03 23:59:59.999999' AND vacancy_status = 'Open' ORDER BY vacancy_id DESC

Page SQL: SELECT v.vacancy_id, v.county, v.job_type, v.job_period, v.job_title, v.start_date, v.end_date, v.open_flag, v.asap_flag, v.date_registered, v.visibility_status, a.n_v_paye, a.n_v_sole_trader, a.n_v_umbrella, a.n_v_limited FROM a1_vacancies v LEFT JOIN a1_attributes a ON v.vacancy_id = a.vacancy_id WHERE visibility_status = 'Website' AND v.date_registered BETWEEN '2015-07-03 00:00:00.000000' AND '2025-07-03 23:59:59.999999' AND vacancy_status = 'Open' ORDER BY vacancy_id DESC LIMIT 50,25
Total items: 217
Page Items: 25

Records per page: 25, offset: 50.

Preferences conditions:

Request query string: v_statusfilter=Open&rolefilter=&v_operator=OR&begin_date_registered=2012-11-25&end_date_registered=2022-11-25&searchwords=&sortorder=vacancy_id&sortdir=DESC&town_city=&county=®ion=&v_visibilityfilter=Website&job_title=&v_clinical_director=&v_senior_vet=&v_new_grad=&v_film_shoots=&v_equine=&v_exotic=&v_large=&v_small=&v_ovs=&v_tb_tester=&n_assessor=&n_qualified=&n_referral=&n_unqualified=&n_v_locum=&n_v_permanent=&n_v_accomodation_required=&n_v_vehicle_required=&n_v_emergency_work=&n_v_night_shifts=&n_v_sole_charge=&n_v_consults_only=&n_v_on_call=&n_v_non_clinical=&n_v_paye=&n_v_sole_trader=&n_v_umbrella=&n_v_limited=&viewmode=&numrecs=25&offset=50.

• Please see our full GDPR Policy