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='' AND l.mycareer_active = 'true' AND a.active=1 AND l.advertiser_id NOT IN (2066437) AND l.listing_id NOT IN (7323777, 7412127)

Got error 28 from storage engine

Job Search

1. Search for a role, such as "tax accountant"

2. Choose your State

3. Click Search

Advertise

Place a job ad with our job listing partner MyCareer.com.au. Your ad will appear not only on the MyCareer website, but also in their mobile apps and across our network. Click below to find out more and see our products and pricing.

Advertise

Place a job ad with our job listing partner MyCareer.com.au. Your ad will appear not only on the MyCareer website, but also in their mobile apps and across our network. Click below to find out more and see our products and pricing.