SELECT industry, i.name iname, i.slug islug ,s.name sname,g.name cname, g.slug slug, s.slug sslug, g.slug cslug, count(city) ccnt
FROM members m, profiles p, industry i,geo_cities g, geo_states s
WHERE m.mem_id = p.mem_id
AND p.industry = i.id
AND p.city = g.cty_id
AND s.sta_id = state
AND acctype = 2
AND m.country = "225"
AND industry > 0
GROUP by industry,city,state
HAVING ccnt >0
ORDER BY iname,s.name ASC:Disk full (/tmp/#sql_1894c_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")