BEGIN FOR
SELECT 1
select U.id,U.customer_id,U.user_role,U.hashed_password,U.display_name,U.description,U.email_address,U.business_hours_start,U.business_hours_end,U.timezone,U.weekend_days,U.enabled,U.data_source,U.password_data_source,U.pin,U.last_imported_serial,U.is_deleted,U.deleted_serial,U.external_key,U.external_key_digits,U.ivr_label,U.password_reset,U.preferred_voice,U.password_expiry_date,U.invalid_password_count,U.authcode,U.authcode_expiry_date,U.authenticate_with_unicorn, E.address
from ( ( select
U.id,U.customer_id,U.user_role,U.hashed_password,U.display_name,U.description,U.email_address,U.business_hours_start,U.business_hours_end,U.timezone,U.weekend_days,U.enabled,U.data_source,U.password_data_source,U.pin,U.last_imported_serial,U.is_deleted,U.deleted_serial,U.external_key,U.external_key_digits,U.ivr_label,U.password_reset,U.preferred_voice,U.password_expiry_date,U.invalid_password_count,U.authcode,U.authcode_expiry_date,U.authenticate_with_unicorn
from dat_user U
 where U.customer_id = 1000 and  U.id in ( select user_id from dat_notification_user where message_id = 10753 )  order by U.display_name , U.id limit 100 ) U left join dat_user_email_addrs E on U.id=E.user_id )  order by U.display_name , U.id, E.addr_index
HAS NEXT
NEXT
Begin Rec query
End Rec query
Begin printNotificationBasics query
SELECT 1
select count(*) from scheduled_tasks SE  where SE.task_executor not in ('com.m1.cmc.mgmt.tasks.CancelNotificationTask','com.m1.cmc.mgmt.tasks.EmailNotificationResultsTask') and SE.class_2='10753' and claimed_by is NULL
End printNotificationBasics query
Begin pair queries
SELECT 1
select s.user_id, s.device_id, s.status_id, s.message, s.device_name, s.device_type, s.device_address, s.status_timestamp, s.message_id from dat_notification_status s  where s.message_id = 10753 and s.user_id in (9432) order by s.status_timestamp
SELECT 1
select cp.id, cp.provider_id, cp.session_id, cp.customer_id, cp.message_id, cp.device_id, cp.device_address, cp.start_date, cp.end_date, cp.application_token, cp.voice,cp.call_type,cp.call_retry_count,cp.voice_start_date,cp.voice_end_date from dat_call_progress cp  where cp.message_id = 10753 and cp.device_id in (2147486178,2531) order by cp.customer_id
End pair queries
Begin responses query
SELECT 1
select  distinct(ur.message_id), ur.user_id, ur.response, ur.response_time, ur.response_data, ur.response_data_type, us.device_name, us.device_address from dat_notification_user ur, dat_notification_status us where ur.message_id = 10753 and ur.user_id in (9432) and ur.message_id = us.message_id  and ur.user_id = us.user_id and us.device_type > 0  order by ur.message_id
End responses query
END step
END FOR