selectcount(*) as aggregate from `bid_listings` where `is_approved` =1and `expired_at` >='2025-04-30 18:05:44'andexists (select*from `cities` where `bid_listings`.`city_id` = `cities`.`id` and `name` ='UTTARA KANNADA'and `cities`.`deleted_at` isnullorderby `name` asc) and `bid_listings`.`deleted_at` isnull