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

3 jobs found

5th Oct

Mortgage Advisor

— Mortgage, protection & insurance

Salary: OTE £45,000
Location: North Bristol
Ref: 385
25th Sep

General Insurance Advisor

— Multi award winning mortgage and protection business

Salary: OTE £45k
Location: Bath
Ref: 444
12th Sep

Sales Executive

— High net value property investment

Salary: OTE £90k
Location: Bristol
Ref: 427