SELECT SQL_CALC_FOUND_ROWS mycareer_listing_id, group_concat(bc.mapped_path) as paths, job_title, search_headline, concat(search_summary,'...') as search_summary, search_bullet_points, location_locality, location_state, listed_by, salary_visible, salary_currency, salary_period, salary_min_amount, salary_max_amount, salary_modifier, salary_options FROM _boomerang_mycareer.listings_view l INNER JOIN _boomerang_mycareer.listing_category lc on l.mycareer_listing_id=lc.listing_id INNER JOIN _boomerang_mycareer.categories bc on lc.category_id=bc.category_id INNER JOIN _boomerang_mycareer.advertisers_view a on l.advertiser_id=a.mycareer_advertiser_id WHERE bc.mapped_path='community-sport-leisure-jobs' AND l.location_state='WA' AND l.mycareer_active = 'true' AND a.active=1 AND l.advertiser_id NOT IN (2066437) AND l.listing_id NOT IN (7323777, 7412127)
