SELECT `jobs`.* FROM `jobs` LEFT JOIN business_templates ON business_templates.id = jobs.alternative_logo LEFT JOIN locations on (jobs.location_id = locations.id or find_in_set(locations.id,jobs.add_locations)) WHERE (categories.cType = 'BUSINESS' AND jobs.country = 'ch' AND jobs.status IN ('ACTIVE', 'JOBBER_APPLIED') AND jobs.visibility IN ('1') AND jobs.job_type != 'SEARCH' AND jobs.job_type != 'TEMPLATE' AND jobs.job_type != 'POSITION' ) GROUP BY jobs.id ORDER BY jobs.created_at desc LIMIT 20 OFFSET 0
business_title_search_cat_jobs
