SQLize | PHPize | SQLtest

create table TRANSACTIONS ( ID NUMBER(20) default "OMNI_CHANNEL"."ISEQ$$_144436".nextval generated as identity primary key, CREATE_AT DATE, AAA_URL NVARCHAR2(400) default '', MESSAGE_UNIQUE_ID NVARCHAR2(100) not null, PARAMS NCLOB not null, STATUS NVARCHAR2(50) default 'Created' not null, TRANSACTION_UNIQUE_ID VARCHAR2(100) not null, TYPE NVARCHAR2(10) not null, URL NVARCHAR2(400) not null constraint FKLRVNMYCBBCQAENIRC8PEAH6A references WIDGET (URL), CUSTOMER_ID NUMBER(20) constraint FKCKSVAU97VD0YK8E8B9J2O6EUW references CUSTOMER, ERROR_ID NUMBER(20) constraint FK1MTLISLCPASQL8TEE5PI7WWRV references ERROR, AGENT NVARCHAR2(400), IP NVARCHAR2(400) ); create index TRANSACTIONS_CUSTOMER_ID_INDEX on TRANSACTIONS (CUSTOMER_ID); create index TRANSACTIONS_TRANSACTION_UNIQUE_ID_INDEX on TRANSACTIONS (TRANSACTION_UNIQUE_ID); create index TRANSACTIONS_MESSAGE_UNIQUE_ID_INDEX on TRANSACTIONS (MESSAGE_UNIQUE_ID); create index TRANSACTIONS_CREATE_AT_INDEX on TRANSACTIONS (CREATE_AT desc); create index TRANSACTIONS_URL_INDEX on TRANSACTIONS (URL); create index TRANSACTIONS_ERROR_ID_INDEX on TRANSACTIONS (ERROR_ID); create index TRANSACTIONS_TYPE_INDEX on TRANSACTIONS (TYPE); create index TRANSACTIONS_STATUS_INDEX on TRANSACTIONS (STATUS); 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;