SELECT * FROM schools_branches WHERE branch_district_id = 19 AND branch_city_id = 1008 AND branch_url LIKE '%akademins-trafikcenter%' AND branch_status = 2 LIMIT 1 Akademins Trafikcenter - Göteborg