SELECT id, seo_url, date_posted, category, location, job_type, salary_freq, salary_text, salary_from, salary_to, job_of_the_week, job_title, full_job_description, location_fullhierarchy, country, consultant,rate_type 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,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_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,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_fullhierarchy,'~',',')))*&*&*&

Search results 18 Jobs

  • select * from jobs WHERE 1=1 AND visible=1 AND ( FIND_IN_SET('52',REPLACE(location,'~',',')) OR FIND_IN_SET('52',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_fullhierarchy,'~',','))) AND ((expiry_date>=DATE(NOW())) or (expiry_date IS NULL) or (expiry_date ='0000-00-00')) AND (((location = '190') or (CONCAT('~', location, '~') LIKE '%~190~%')) or (CONCAT('~', location, '~') LIKE '%~190~%') OR ((location_fullhierarchy = '190') or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~190~%')) or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~190~%'))select * from jobs WHERE 1=1 AND visible=1 AND ( FIND_IN_SET('52',REPLACE(location,'~',',')) OR FIND_IN_SET('52',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_fullhierarchy,'~',','))) AND ((expiry_date>=DATE(NOW())) or (expiry_date IS NULL) or (expiry_date ='0000-00-00')) AND (((location = '69') or (CONCAT('~', location, '~') LIKE '%~69~%')) or (CONCAT('~', location, '~') LIKE '%~69~%') OR ((location_fullhierarchy = '69') or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~69~%')) or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~69~%'))select * from jobs WHERE 1=1 AND visible=1 AND ( FIND_IN_SET('52',REPLACE(location,'~',',')) OR FIND_IN_SET('52',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_fullhierarchy,'~',','))) AND ((expiry_date>=DATE(NOW())) or (expiry_date IS NULL) or (expiry_date ='0000-00-00')) AND (((location = '114') or (CONCAT('~', location, '~') LIKE '%~114~%')) or (CONCAT('~', location, '~') LIKE '%~114~%') OR ((location_fullhierarchy = '114') or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~114~%')) or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~114~%'))select * from jobs WHERE 1=1 AND visible=1 AND ( FIND_IN_SET('52',REPLACE(location,'~',',')) OR FIND_IN_SET('52',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_fullhierarchy,'~',','))) AND ((expiry_date>=DATE(NOW())) or (expiry_date IS NULL) or (expiry_date ='0000-00-00')) AND (((location = '32') or (CONCAT('~', location, '~') LIKE '%~32~%')) or (CONCAT('~', location, '~') LIKE '%~32~%') OR ((location_fullhierarchy = '32') or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~32~%')) or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~32~%'))select * from jobs WHERE 1=1 AND visible=1 AND ( FIND_IN_SET('52',REPLACE(location,'~',',')) OR FIND_IN_SET('52',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('58',REPLACE(location,'~',',')) OR FIND_IN_SET('58',REPLACE(location_fullhierarchy,'~',','))) AND ((expiry_date>=DATE(NOW())) or (expiry_date IS NULL) or (expiry_date ='0000-00-00')) AND (((location = '1') or (CONCAT('~', location, '~') LIKE '%~1~%')) or (CONCAT('~', location, '~') LIKE '%~1~%') OR ((location_fullhierarchy = '1') or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~1~%')) or (CONCAT('~', location_fullhierarchy, '~') LIKE '%~1~%'))

Setting out Engineer

20 - 22 / Hourly + accommodation (Ltd Co)

Get NEW JOBS
like these by email

Page 1 of 2

Search jobs

Search

Minimum salary or rate?

£K
£/ hr
MORE OPTIONS