SQLize | PHPize | SQLtest

select transactio0_.id, transactio0_.create_at, transactio0_.aaa_url, transactio0_.message_unique_id, -- transactio0_.params, transactio0_.status, transactio0_.transaction_unique_id, transactio0_.type, transactio0_.url, transactio0_.customer_id, transactio0_.error_id, transactio0_.agent, transactio0_.ip, transactio0_.id, transactio0_.create_at, widgetenti1_.update_at, transactio0_.aaa_url, widgetenti1_.color, widgetenti1_.enabled, widgetenti1_.icon, widgetenti1_.producer_type, transactio0_.url, widgetenti1_.widget_type, widgetenti1_.presentabled, widgetenti1_.is_admin, widgetenti1_.process_type, widgetenti1_.is_transactional, widgetenti1_.has_otp, widgetenti1_.is_public, widgetenti1_.active_for_capital, widgetenti1_.has_notification, widgetenti1_.closing_price, widgetenti1_.active_for_no_capital, widgetenti1_.active_for_virtual_branch from TRANSACTIONS transactio0_ left outer join OMNI_CHANNEL.WIDGET widgetenti1_ on transactio0_.URL = widgetenti1_.URL where transactio0_.CREATE_AT >= to_date('2022/06/10', 'YYYY/MM/DD') and transactio0_.CREATE_AT <= to_date('2022/07/12', 'YYYY/MM/DD') and transactio0_.TYPE = 'REQUEST' and transactio0_.STATUS = 'Completed' and widgetenti1_.IS_ADMIN = 0 order by transactio0_.CREATE_AT desc; select transactio0_.id, transactio0_.TRANSACTION_UNIQUE_ID from OMNI_CHANNEL.TRANSACTIONS transactio0_ left outer join OMNI_CHANNEL.WIDGET widgetenti1_ on transactio0_.URL = widgetenti1_.URL where transactio0_.id >= 10441204 and transactio0_.id <= 10571376 and transactio0_.TYPE = 'REQUEST' and transactio0_.STATUS = 'Completed' and widgetenti1_.IS_ADMIN = 0 order by transactio0_.CREATE_AT desc;