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

2 jobs found

22nd Jul

Sales Executive

— Close-knit Construction Software Team

Salary: OTE £30k
Location: Bath
Type: Telesales
Ref: 793
15th Jul

Area Sales Manager

— Growing App developer

Salary: £28000 - £32000
Location: South West England
Ref: 605M