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('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',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('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',REPLACE(location_fullhierarchy,'~',',')))*&*&*&

Search results 30 Jobs

REFINE YOUR RESULTS
CLEAR ALL
  • select * from jobs WHERE 1=1 AND visible=1 AND ( FIND_IN_SET('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',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('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',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('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',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('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',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('12',REPLACE(location,'~',',')) OR FIND_IN_SET('12',REPLACE(location_fullhierarchy,'~',',')) OR FIND_IN_SET('18',REPLACE(location,'~',',')) OR FIND_IN_SET('18',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~%'))

Get NEW JOBS
like these by email

Page 1 of 2

Search jobs

Search

Minimum salary or rate?

£K
£/ hr
MORE OPTIONS