SELECT * FROM jobs WHERE 1=1 AND jobs.visible=1 AND ( ( jobs.expiry_date>=DATE(NOW()) ) or ( jobs.expiry_date IS NULL ) or ( jobs.expiry_date ='0000-00-00' ) ) AND ( FIND_IN_SET('1',REPLACE(location,'~',',')) OR FIND_IN_SET('1',REPLACE(location_fullhierarchy,'~',',')) ) ORDER BY date_created DESCSELECT count(*) as cnt FROM jobs WHERE 1=1 AND jobs.visible=1 AND ( ( jobs.expiry_date>=DATE(NOW()) ) or ( jobs.expiry_date IS NULL ) or ( jobs.expiry_date ='0000-00-00' ) ) AND ( FIND_IN_SET('1',REPLACE(location,'~',',')) OR FIND_IN_SET('1',REPLACE(location_fullhierarchy,'~',',')) )*&*&*&

Get NEW JOBS
like these by email

Sub Agent

27 - 30 / Hourly + OT for nights and weekends

Section Engineer

23 - 26 / Hourly + OT for weekends or nights
Page 1 of 13

Search jobs

Search

Minimum salary or rate?

£K
£/ hr
MORE OPTIONS