SELECT f1.id as id, f1.profile as profile, f1.yuid as yuid, f1.category_id as category_id, f1.geo_address as geo_address, f1.geo_city as geo_city, f1.geo_state as geo_state, f1.geo_zip as geo_zip, f1.topic as topic, f1.description as description, f1.description_html as description_html, f1.digs as digs, f1.negative_digs as negative_digs, f1.digs/(f1.digs + f1.negative_digs) * ((f1.digs+f1.negative_digs)>=5) as score, date_format(f1.created_ts, '%Y%m%d %H:%i:%s') as created_ts, date_format(f1.updated_ts, '%Y%m%d %H:%i:%s') as ts, date_format(f1.closed_ts, '%Y%m%d %H:%i:%s') as closed_ts, COUNT(com.fid) as numcomments FROM Suggestions f1 LEFT JOIN Comments com ON f1.id = com.fid AND (!com.deleted_ts) AND (com.moderate = 0) WHERE 1=1 AND (!f1.deleted_ts) AND (f1.moderate = 0) AND f1.geo_lat >= 45.412536099855 AND f1.geo_lat <= 45.557253900145 AND f1.geo_lon >= -122.89049262264 AND f1.geo_lon <= -122.70181337736 GROUP BY f1.id ORDER BY updated_ts DESC, id LIMIT 0, 10
All Topics in Beaverton, OR | Yahoo! Neighbors