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 ( ((language_code = '2') or (CONCAT('~', language_code, '~') LIKE '%~2~%')) or (CONCAT('~', language_code_fullhierarchy, '~') LIKE '%~2~%') ) AND visible = 1 ORDER BY job_of_the_week DESC, email_alert_posted_date DESC LIMIT 10 OFFSET 0

3 jobs found

6th Jul

Business Development Manager

Salary: £25000 - £30000
Location: Stroud
Ref: 822
20th Jun

Sales Manager

Salary: £30000 - £50000
Location: Bristol
Ref: 820
16th Jun

Sales Director

Salary: £80000 - £110000
Location: Stratford Upon Avon
Ref: 819