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 job_type in (1) ORDER BY job_of_the_week desc, 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 job_type in (1)*&*&*&

Search results 23 Jobs

REFINE YOUR RESULTS
CLEAR ALL
  • select * from jobs WHERE 1=1 AND visible=1 AND job_type in (1) 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 job_type in (1) 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 job_type in (1) 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 job_type in (1) 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 job_type in (1) 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

Sub Agent

40000 - 45000 / Annual + plus package
Page 1 of 2

Search jobs

Search

Minimum salary or rate?

£K
£/ hr
MORE OPTIONS