http://www.ed-reference.us/00110/technical/industrial-production-technologies,-technicians/colleges - Message: SELECT c.id, c.name, c.address1, c.address2, c.city, c.state, c.zip, c.google_map_url, c.url, c.featured, c.online, sl.name state_long FROM college c LEFT JOIN state_lookup sl ON c.state=sl.id LEFT JOIN degree d ON c.id=d.college_id WHERE d.category='technical' AND d.name='industrial production technologies, technicians' AND c.online=0 GROUP BY c.id ORDER BY c.state, c.city LIMIT 0,