select distinct tallyinsta0_.bucket_billing_account_id as bucket_b1_15_, tallyinsta0_.bucket_billing_provider as bucket_b2_15_, tallyinsta0_.instance_id as instance3_15_, tallyinsta0_.measurement_type as measurem4_15_, tallyinsta0_.product_id as product_5_15_, tallyinsta0_.sla as sla6_15_, tallyinsta0_.uom as uom7_15_, tallyinsta0_.usage as usage8_15_, tallyinsta0_.cores as cores9_15_, tallyinsta0_.display_name as display10_15_, tallyinsta0_.host_billing_account_id as host_bi11_15_, tallyinsta0_.host_billing_provider as host_bi12_15_, tallyinsta0_.id as id13_15_, tallyinsta0_.last_seen as last_se14_15_, tallyinsta0_.num_of_guests as num_of_15_15_, tallyinsta0_.org_id as org_id16_15_, tallyinsta0_.sockets as sockets17_15_, tallyinsta0_.subscription_manager_id as subscri18_15_, tallyinsta0_.value as value19_15_ from tally_instance_view tallyinsta0_ where tallyinsta0_.cores>=? and tallyinsta0_.sockets>=? and tallyinsta0_.org_id=? and tallyinsta0_.product_id=? and tallyinsta0_.sla=? and tallyinsta0_.usage=? and tallyinsta0_.bucket_billing_provider=? and tallyinsta0_.bucket_billing_account_id=? and (lower(tallyinsta0_.display_name) like ?) and tallyinsta0_.uom=? order by tallyinsta0_.last_seen desc, tallyinsta0_.id asc limit ?