---date---ORDER BY updated_ts DESC, id
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) WHERE 1=1 AND f1.yuid = '' AND (!f1.deleted_ts) GROUP BY f1.id ORDER BY updated_ts DESC, id LIMIT 0, 1
NeighborsModelMyActivity.getDetailedCount ERROR