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

3 jobs found

5th Jul

Sales Executive

— E-commerce Property Law Firm

Salary: OTE £28k
Location: Northamptonshire
Ref: 668
26th Jun

New Business Development Executive

— Microsoft Cloud Partner

Salary: £120k OTE
Location: M4 Corridor
Ref: 644
26th Jun

Key Account Manager

— IT solutions & networks provider

Salary: £73k OTE
Location: M25 West/M4 Corridor
Ref: 657