SELECT * FROM schools_branches WHERE branch_district_id = 9 AND branch_city_id = 1181 AND branch_url LIKE '%ljungby-halkbana%' AND branch_status = 2 LIMIT 1
Eka Bredemad, 341 96 Ljungby