Creating teams. Shaping futures.
SELECT id, ref, job_title, date_posted, category, location, job_type, salary_text, salary_from, salary_to, job_of_the_week, email_alert_posted_date, sub_title, display_location 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 ( FIND_IN_SET('30',REPLACE(category,'~',',')) OR FIND_IN_SET('30',REPLACE(category_fullhierarchy,'~',',')) ) AND visible = 1 ORDER BY job_of_the_week DESC, email_alert_posted_date DESC LIMIT 10 OFFSET 0

3 jobs found

22nd Sep

2 x Media Managers (1 x digital and off line, 1 x TV)

— High Profile Brands

Salary: c.£30k + Great Benefits
Location: Bristol
Type: Permanent
Ref: 7841
16th Aug

Planner

— Award winning agency

Salary: Up to £40k
Location: Bristol
Type: Permanent
Ref: 7703
15th Aug

Account Director

— Award winning agency - TV Media

Salary: Up to £50k
Location: Bristol
Type: Permanent
Ref: 7702