select count(*) AS count from GLD WHERE L_StatusCatID='Active' AND LM_Char10_22!='' AND L_City!=''