Mine

SELECT COUNT(true) AS count,client_aggregate.*, property_aggregate.* FROM client_aggregateLEFT JOIN property_aggregate ON client_aggregate.client_property_id = property_aggregate.property_idWHEREproperty_aggregate.%s = :qid AND ((client_aggregate.user_account_first_name ILIKE :client_first_name ANDclient_aggregate.user_account_last_name ILIKE :client_last_name) ORclient_aggregate.address_line1 ILIKE :client_address_line1 ORclient_aggregate.user_account_primary_phone = :client_primary_phoneAND client_aggregate.client_is_primary = 1)ORDER BY user_account_register_timestamp ASC, property_aggregate.property_session_scheduled_time ASC LIMIT :limitOFFSET :offset