SELECT COUNT(*)AS ctn FROM gns_residentialsell P WHERE status=1 AND cityid = '989' AND locationid in (816) ORDER BY featured DESC,sno DESCUser 'uniyaagz_harry' has exceeded the 'max_questions' resource (current value: 1)