...
1. Send the following queries to both oagi_dev
and oagi_eu
databases
Code Block |
---|
|
SELECT `acc_id`, `den` FROM `acc` WHERE `object_class_term` = 'Extension'; |
2. Collect acc_id_list
from results and send the following query to both databases with collected results.
Code Block |
---|
|
SELECT `to_asccp_id` FROM `ascc` WHERE `from_acc_id` IN (:acc_id_list); |
3. Collect asccp_id_list
from results and send the following query to both databases with collected results.
Code Block |
---|
|
SELECT `asccp_id`, `den` FROM `asccp` WHERE `asccp` IN (:asccp_id_list); |
...