Anonymous

SELECT * 
  FROM invusers AS t1
  JOIN invads AS t2 ON t1.invid = t2.invid 
  JOIN invareas AS t3 ON t1.invid = t3.invid
  LEFT JOIN (SELECT invusers.invid, 
              COUNT( invareas.invid ) cnt
               FROM invusers
               LEFT JOIN invareas ON invusers.invid = invareas.invid
              GROUP BY invusers.invid
             ) AS t4 ON t1.invid=t4.invid
 WHERE t1.perm >0
   AND t2.expires > curdate( ) 
   AND t2.approved =1
   AND t3.city = 'garland'
   AND t3.state = 'TX'
 ORDER BY t4.cnt ASC ;