SELECT * FROM schools_branches WHERE branch_district_id = 8 AND branch_city_id = 1141 AND branch_url LIKE '%g-c-korkortsintensiven%' AND branch_status = 2 LIMIT 1 G-C Körkortsintensiven - Oskarshamn