Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1. Send the following queries to both oagi_dev and oagi_eu databases

Code Block
languagesql
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
languagesql
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
languagesql
SELECT `asccp_id`, `den` FROM `asccp` WHERE `asccp` IN (:asccp_id_list);

...