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

Project Manager

40 - 45 / Hourly + OT for nights and weekends

Building Foreman

20 - 22 / Hourly + OT for night and weekends

Search jobs

Search

Minimum salary or rate?

£K
£/ hr
MORE OPTIONS