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 = 'de' 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 0germany_business_title_search_cat_jobs
Thank you for applying on this job. Your have succesfully registered. You have received an email to confirm your user account. (Please also check your email spam settings.)
Complete your profile
An error occurred.