http://www.ed-reference.us/00110/health+care/phlebotomy,-phlebotomist/colleges/i50/p2/ - 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='health care' AND d.name='phlebotomy, phlebotomist' AND c.online=0 GROUP BY c.id ORDER BY c.state, c.city LIMIT -50, 50