SELECT COUNT(*)AS ctn FROM gns_residentialrent P WHERE status=1 AND cityid = '1763' AND catid in (3,28,29,30) AND locationid in (14890,14859,14860,14917,14918,14969,15080) ORDER BY featured DESC,sno DESCUser 'uniyaagz_harry' has exceeded the 'max_questions' resource (current value: 1)