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 v.job_type = 'vet' AND visibility_status = 'Website' AND v.date_registered BETWEEN '2015-07-01 00:00:00.000000' AND '2025-07-01 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 v.job_type = 'vet' AND visibility_status = 'Website' AND v.date_registered BETWEEN '2015-07-01 00:00:00.000000' AND '2025-07-01 23:59:59.999999' AND vacancy_status = 'Open' ORDER BY vacancy_id DESC LIMIT 0,1000
Total items: 156
Page Items: 156

Records per page: 1000, offset: 0.

Preferences conditions:

Request query string: v_statusfilter=Open&rolefilter=vet&v_operator=OR&begin_date_registered=2015-03-14&end_date_registered=2025-03-14&searchwords=&sortorder=vacancy_id&sortdir=DESC&town_city=&county=®ion=&v_visibilityfilter=Website&job_title=&v_clinical_director=&v_senior_vet=&v_referral=&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_fixed_term=&n_v_full_time=&n_v_part_time=&n_v_twilight=&n_v_accomodation_required=&n_v_accomodation_not_available=&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_cert_holder=&n_v_spare_1=&n_v_spare_2=&n_v_spare_3=&n_v_paye=&n_v_sole_trader=&n_v_umbrella=&n_v_limited=&viewmode=&numrecs=1000&offset=0.

• Please see our full GDPR Policy