157 : <cfquery name="checkcity" datasource="#sitedsn#" cachedwithin="#CreateTimeSpan(0,3,0,0)#" timeout="5">
158 : select county, city, count(county) as totalcounty from mlslistings
159 : WHERE city = "#Trim(ReReplace(url.2, '-', ' ', 'all'))#"
160 : GROUP BY county
161 : ORDER BY totalcounty DESC
|