-- 2013-12-02 7 event_contacts SELECT event_contacts.id, event_contacts.contact_id AS student_id, event_contacts.event_id AS class_id, contacts.id AS student_id FROM event_contacts LEFT JOIN contacts ON event_contacts.contact_id=contacts.id WHERE event_contacts.deleted=0 AND contacts.id IS NULL ; -- 59 / 774,141 SELECT event_contacts.id, event_contacts.contact_id AS student_id, event_contacts.event_id AS class_id, smsevent.id AS class_id FROM event_contacts LEFT JOIN smsevent ON event_contacts.event_id=smsevent.id WHERE event_contacts.deleted=0 AND smsevent.id IS NULL -- 0 / 774,141 SELECT event_contacts.id, event_contacts.contact_id AS student_id, event_contacts.event_id AS class_id, contacts.id AS student_id, smsevent.id AS class_id FROM event_contacts LEFT JOIN contacts ON event_contacts.contact_id=contacts.id LEFT JOIN smsevent ON event_contacts.event_id=smsevent.id WHERE event_contacts.deleted=0 AND contacts.id IS NULL AND smsevent.id IS NULL -- 0 UPDATE event_contacts LEFT JOIN contacts ON event_contacts.contact_id=contacts.id SET event_contacts.deleted=1 WHERE event_contacts.deleted=0 AND contacts.id IS NULL 8 smsevent SELECT smsevent.id course_id, smsevent.name, curriculum_id, curriculum.id FROM smsevent LEFT JOIN curriculum ON smsevent.curriculum_id=curriculum.id AND curriculum.deleted=0 WHERE category='course' AND smsevent.deleted=0 AND curriculum.id IS NULL -- 6,542 SELECT curriculum_code, count(id) FROM curriculum WHERE deleted=0 GROUP BY curriculum_code HAVING count(id) > 1 SELECT class_code, count(id) FROM smsevent WHERE deleted=0 GROUP BY class_code HAVING count(id) > 1 12 sms_event_instance SELECT sms_event_instance.parent_id as class_id, from_datetime, to_datetime, smsevent.name AS class_name, kamoku, curriculum_id FROM sms_event_instance LEFT JOIN smsevent ON smsevent.id=sms_event_instance.parent_id WHERE smsevent.id IS NULL -- 80 / 444,214 SELECT sms_event_instance . * FROM sms_event_instance LEFT JOIN smsevent ON smsevent.id = sms_event_instance.parent_id WHERE smsevent.id IS NULL SELECT sms_event_instance_sub . * FROM sms_event_instance_sub LEFT JOIN sms_event_instance ON sms_event_instance.id = sms_event_instance_sub.instance_id WHERE sms_event_instance.id IS NULL 14 smsevent & sms_recurrence SELECT smsevent.id AS class_id, name AS class_name, kamoku, curriculum_id, actual_event_start, actual_event_end, actual_number_of_occurrences FROM smsevent LEFT JOIN sms_recurrence ON smsevent.id=sms_recurrence.id WHERE smsevent.deleted=0 AND sms_recurrence.id IS NULL -- 93,128 / 133,771 SELECT smsevent.id AS class_id FROM sms_recurrence LEFT JOIN smsevent ON smsevent.id=sms_recurrence.id WHERE smsevent.deleted=0 AND smsevent.id IS NULL -- 0 / 40,643 16 smsevent_instances SELECT smsevent_instances.event_id as class_id, target_id AS student_id, from_datetime, to_datetime, smsevent.name AS class_name, kamoku, curriculum_id FROM smsevent_instances LEFT JOIN smsevent ON smsevent.id=smsevent_instances.event_id WHERE smsevent.id IS NULL -- 7,308 / 3,755,095 SELECT smsevent_instances.event_id as class_id, target_id AS student_id, from_datetime, to_datetime, contacts.last_name AS student_name FROM smsevent_instances LEFT JOIN contacts ON contacts.id=smsevent_instances.target_id WHERE contacts.id IS NULL -- 0 / 3,755,095 17 sms_fee SELECT sms_fee.id, sms_fee.contact_id AS student_id, contacts.id AS student_id FROM sms_fee LEFT JOIN contacts ON sms_fee.contact_id=contacts.id WHERE sms_fee.deleted=0 AND contacts.id IS NULL ; -- 833 18 sms_fee SELECT sms_fee.id, sms_fee.contact_id AS student_id, contacts.id AS student_id FROM sms_fee LEFT JOIN contacts ON sms_fee.contact_id=contacts.id WHERE sms_fee.deleted=0 AND contacts.id IS NULL ; -- 833 19 sms_transaction SELECT sms_transaction.id, sms_transaction.contact_id AS student_id, contacts.id AS student_id FROM sms_transaction LEFT JOIN contacts ON sms_transaction.contact_id=contacts.id WHERE sms_transaction.deleted=0 AND contacts.id IS NULL ; -- 833 SELECT sms_fee.id, basic_fee, sell_date, sms_fee.contact_id AS student_id, contacts.id AS student_id FROM sms_fee LEFT JOIN contacts ON sms_fee.contact_id=contacts.id WHERE sms_fee.deleted=0 AND contacts.id IS NULL SELECT sms_salesgroup.id, sms_salesgroup.contact_id AS student_id, contacts.id AS student_id FROM sms_salesgroup LEFT JOIN contacts ON sms_salesgroup.contact_id=contacts.id WHERE sms_salesgroup.deleted=0 AND contacts.id IS NULL UPDATE sms_fee SET deleted=1 WHERE `basic_fee` IS NULL ; UPDATE sms_transaction SET deleted=1 WHERE `in_amount` IS NULL ; UPDATE sms_salesgroup SET deleted=1 WHERE `sell_date` IS NULL ; UPDATE sms_transaction LEFT JOIN contacts ON sms_transaction.contact_id=contacts.id SET sms_transaction.deleted=1 WHERE sms_transaction.deleted=0 AND contacts.id IS NULL ; UPDATE sms_fee LEFT JOIN contacts ON sms_fee.contact_id=contacts.id SET sms_fee.deleted=1 WHERE sms_fee.deleted=0 AND contacts.id IS NULL ; UPDATE sms_salesgroup LEFT JOIN contacts ON sms_salesgroup.contact_id=contacts.id SET sms_salesgroup.deleted=1 WHERE sms_salesgroup.deleted=0 AND contacts.id IS NULL ; SELECT sms_salesgroup.school_code, sms_transaction.school_id FROM sms_salesgroup, sms_transaction WHERE sms_salesgroup.salesno=sms_transaction.salesno AND sms_salesgroup.school_code!=sms_transaction.school_id UPDATE sms_salesgroup, sms_transaction SET sms_salesgroup.school_code=sms_transaction.school_id WHERE sms_salesgroup.salesno=sms_transaction.salesno AND sms_salesgroup.school_code!=sms_transaction.school_id 39 buppin SELECT buppin_code, count(*), FROM buppin GROUP BY buppin_code HAVING count(*)>1 select count(t_table.buppin_name), t_table.buppin_name, '$$$' from (SELECT buppin_name, buppin_code FROM `buppin` group by buppin_name, buppin_code ) t_table group by t_table.buppin_name having count(t_table.buppin_name) = 1 select count(t_table.buppin_name), t_table.buppin_name, id, t_table.buppin_code, '$$$' from (SELECT buppin_name, buppin_code, id FROM `buppin` group by buppin_name, buppin_code ) t_table group by t_table.buppin_name having count(t_table.buppin_name) = 1 AND t_table.buppin_code = '' select id, t_table.buppin_code from (SELECT buppin_name, buppin_code, id FROM `buppin` group by buppin_name, buppin_code ) t_table group by t_table.buppin_name having count(t_table.buppin_name) = 1 AND t_table.buppin_code = '' CREATE TABLE IF NOT EXISTS `buppin_lookup` ( `id` char(36) NOT NULL, `buppin_code` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `buppin_code` (`buppin_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SELECT * FROM buppin, buppin_lookup WHERE buppin.id=buppin_lookup.id SELECT * FROM `buppin` WHERE `buppin_code`='' UPDATE buppin SET deleted=1 WHERE `buppin_code`='' SELECT sms_transaction.id, sell_date FROM sms_transaction, buppin WHERE sms_transaction.buppin_id=buppin.id AND buppin.deleted=1 SELECT sms_transaction.id, sell_date, t_date FROM sms_transaction, buppin WHERE sms_transaction.buppin_id=buppin.id AND buppin.deleted=1 AND sell_date IS NOT NULL ORDER BY sell_date asc select '###', t_table.buppin_name, '$$$' from (SELECT buppin_name, buppin_code FROM `buppin` group by buppin_name, buppin_code ) t_table group by t_table.buppin_name having count(t_table.buppin_name) > 1 SELECT sms_transaction.id, sell_date, t_date FROM sms_transaction, buppin WHERE sms_transaction.buppin_id=buppin.id AND buppin.deleted=1 AND sms_transaction.deleted=0 AND sell_date>='2010-10-01' ORDER BY sell_date DESC SELECT sms_transaction.* FROM sms_transaction, buppin WHERE sms_transaction.buppin_id=buppin.id AND buppin.deleted=1 AND sms_transaction.deleted=0 AND sell_date>='2010-10-01' ORDER BY sell_date DESC SELECT distinct buppin_id FROM sms_transaction, buppin WHERE sms_transaction.buppin_id=buppin.id AND buppin.deleted=1 AND sms_transaction.deleted=0 AND sell_date>='2010-10-01' ORDER BY sell_date DESC SELECT buppin.* FROM buppin, buppin_lookup WHERE buppin.id=buppin_lookup.id SELECT distinct contact_id FROM sms_transaction, buppin WHERE sms_transaction.buppin_id=buppin.id AND buppin.deleted=1 AND sms_transaction.deleted=0 AND sell_date>='2010-10-01' ORDER BY contact_id ASC 40 hasso_contacts SELECT hasso_contacts.id, hassocode_contacts_id, hassocode_contacts.id as hassocode_contacts_id FROM hasso_contacts LEFT JOIN hassocode_contacts ON hasso_contacts.hassocode_contacts_id=hassocode_contacts.id WHERE hasso_contacts.deleted=0 AND hassocode_contacts.id IS NULL ; SELECT hasso_contacts.id, buppin_id, buppin.id AS bupin_id FROM hasso_contacts LEFT JOIN buppin ON hasso_contacts.buppin_id=buppin.id WHERE hasso_contacts.deleted=0 AND buppin.id IS NULL ; --SELECT hassocode_contacts_id, buppin_id, count(*) FROM hasso_contacts GROUP BY hassocode_contacts_id, buppin_id Having count(*)>1; 41-1 buppin_curriculum SELECT buppin_curriculum.id, buppin_id, buppin.id as buppin_id FROM buppin_curriculum LEFT JOIN buppin ON buppin_curriculum.buppin_id=buppin.id WHERE buppin_curriculum.deleted=0 AND buppin.id IS NULL ; 111KG21B1 111KG21B2 111KG21B3 131KG21B1 131KG21B3 S07SR320-11 SELECT buppin_curriculum.id, curriculum_id, curriculum.id as curriculum_id FROM buppin_curriculum LEFT JOIN curriculum ON buppin_curriculum.curriculum_id=curriculum.id WHERE buppin_curriculum.deleted=0 AND curriculum.id IS NULL ; --- 2,358 distinct curriculum, 19,471 records / Total: 25,409 SELECT buppin_id, curriculum_id, count(*) FROM buppin_curriculum GROUP BY buppin_id, curriculum_id Having count(*)>1; -- 0 41-2 buppin_class SELECT buppin_class.id, buppin_id, buppin.id as buppin_id FROM buppin_class LEFT JOIN buppin ON buppin_class.buppin_id=buppin.id WHERE buppin_class.deleted=0 AND buppin.id IS NULL ; SELECT buppin_class.id, event_id, smsevent.id as smsevent_id FROM buppin_class LEFT JOIN smsevent ON buppin_class.event_id=smsevent.id WHERE buppin_class.deleted=0 AND smsevent.id IS NULL ; 72,049 records, 12,187 unique class, TOTAL: 118,749 SELECT buppin_id, event_id, count(*) FROM buppin_class GROUP BY buppin_id, event_id Having count(*)>1; 42 curriculum_hassocode SELECT curriculum_hassocode.id, hassocode_id, curriculum_id, curriculum.id as curriculum_id FROM curriculum_hassocode LEFT JOIN curriculum ON curriculum_hassocode.curriculum_id=curriculum.id WHERE curriculum_hassocode.deleted=0 AND curriculum.id IS NULL ; -- 10,419 SELECT curriculum_hassocode.id, curriculum_id, hassocode_id, hassocode.id as hassocode_id FROM curriculum_hassocode LEFT JOIN hassocode ON curriculum_hassocode.hassocode_id=hassocode.id WHERE curriculum_hassocode.deleted=0 AND hassocode.id IS NULL ; SELECT hassocode_id, curriculum_id, count(*) FROM curriculum_hassocode GROUP BY hassocode_id, curriculum_id Having count(*)>1; 45 hassocode_buppin SELECT hassocode_buppin.id, buppin_id, hassocode_id, hassocode.id as hassocode_id FROM hassocode_buppin LEFT JOIN hassocode ON hassocode_buppin.hassocode_id=hassocode.id WHERE hassocode_buppin.deleted=0 AND hassocode.id IS NULL ; SELECT hassocode_buppin.id, hassocode_id, buppin_id, buppin.id as buppin_id FROM hassocode_buppin LEFT JOIN buppin ON hassocode_buppin.buppin_id=buppin.id WHERE hassocode_buppin.deleted=0 AND buppin.id IS NULL ; SELECT hassocode_id, buppin_id, count(*) FROM hassocode_buppin GROUP BY hassocode_id, buppin_id Having count(*)>1; 46 hassocode_hassobi SELECT hassocode_hassobi.id, hassobi_id, hassocode_id, hassocode.id AS hassocode_id FROM hassocode_hassobi LEFT JOIN hassocode ON hassocode_hassobi.hassocode_id=hassocode.id WHERE hassocode_hassobi.deleted=0 AND hassocode.id IS NULL ; 416 -- / 103,509 SELECT hassocode_hassobi.id, hassocode_id, hassobi_id, hassobi.id AS hassobi_id FROM hassocode_hassobi LEFT JOIN hassobi ON hassocode_hassobi.hassobi_id=hassobi.id WHERE hassocode_hassobi.deleted=0 AND hassobi.id IS NULL ; 2,633 -- / 103,509 SELECT count(*) , hassocode_id, hassobi_id FROM `hassocode_hassobi` WHERE 1 GROUP BY hassocode_id, hassobi_id 47 hassocode_contacts SELECT hassocode_contacts.id, contact_id, contacts.id as contact_id FROM hassocode_contacts LEFT JOIN contacts ON hassocode_contacts.contact_id=contacts.id WHERE hassocode_contacts.deleted=0 AND contacts.id IS NULL ; SELECT hassocode_contacts.id, hassocode_id, hassocode.id as hassocode_id FROM hassocode_contacts LEFT JOIN hassocode ON hassocode_contacts.hassocode_id=hassocode.id WHERE hassocode_contacts.hasso_type='1' AND hassocode_contacts.deleted=0 AND hassocode.id IS NULL ; SELECT hassocode_contacts.id, hassocode_id, shukka_kobetsu.id as hassocode_id FROM hassocode_contacts LEFT JOIN shukka_kobetsu ON hassocode_contacts.hassocode_id=shukka_kobetsu.id WHERE hassocode_contacts.hasso_type='2' AND hassocode_contacts.deleted=0 AND shukka_kobetsu.id IS NULL ; -- 1,210,819 SELECT hassocode_contacts.id, event_id, smsevent.id as event_id FROM hassocode_contacts LEFT JOIN smsevent ON hassocode_contacts.event_id=smsevent.id WHERE hassocode_contacts.hasso_type='1' AND hassocode_contacts.deleted=0 AND smsevent.id IS NULL ; -- 191,979 SELECT contact_id, hassocode_id, event_id, count(*) FROM hassocode_contacts GROUP BY contact_id, hassocode_id, event_id Having count(*)>1; 48 hassobi SELECT hassobi.id, event_id, smsevent.id AS event_id FROM hassobi LEFT JOIN smsevent ON hassobi.event_id=smsevent.id WHERE event_id!='' AND smsevent.id IS NULL -- 54 event_koza SELECT event_koza.id, event_id, koza_id, koza.id AS koza_id FROM event_koza LEFT JOIN koza ON event_koza.koza_id=koza.id WHERE event_koza.deleted=0 AND koza.id IS NULL ; -- 373 / 210,095 UPDATE event_koza LEFT JOIN koza ON event_koza.koza_id=koza.id SET event_koza.deleted=1 WHERE event_koza.deleted=0 AND koza.id IS NULL ; SELECT event_koza.id, koza_id, event_id, smsevent.id AS event_id FROM event_koza LEFT JOIN smsevent ON event_koza.event_id=smsevent.id WHERE event_koza.deleted=0 AND smsevent.id IS NULL ; -- 0 / 210,095 55 koza_contacts SELECT koza_contacts.id, koza_contacts.contact_id AS student_id, koza_contacts.koza_id AS koza_id, contacts.id AS student_id FROM koza_contacts LEFT JOIN contacts ON koza_contacts.contact_id=contacts.id WHERE koza_contacts.deleted=0 AND contacts.id IS NULL ; 150 -- 99,902 SELECT koza_contacts.id, koza_contacts.contact_id AS student_id, koza_contacts.koza_id AS koza_id, koza.id AS koza_id FROM koza_contacts LEFT JOIN koza ON koza_contacts.koza_id=koza.id WHERE koza_contacts.deleted=0 AND koza.id IS NULL; 886 -- SELECT koza_contacts.id, koza_contacts.contact_id AS student_id, koza_contacts.koza_id AS koza_id, contacts.id AS student_id, koza.id AS koza_id FROM koza_contacts LEFT JOIN contacts ON koza_contacts.contact_id=contacts.id LEFT JOIN koza ON koza_contacts.koza_id=koza.id WHERE koza_contacts.deleted=0 AND contacts.id IS NULL AND koza.id IS NULL; 2 -- 57 kyoikukunren_koza SELECT kyoikukunren_koza.id, kunrenkoza_id, koza_id, koza.id AS koza_id FROM kyoikukunren_koza LEFT JOIN koza ON kyoikukunren_koza.koza_id=koza.id WHERE kyoikukunren_koza.deleted=0 AND koza.id IS NULL ; -- 3/ 5,158 58 kyoikukunren_contacs SELECT kyoikukunren_contacs.id, kunrenkoza_id, contact_id, contacts.id FROM kyoikukunren_contacs LEFT JOIN contacts ON kyoikukunren_contacs.contact_id=contacts.id WHERE kyoikukunren_contacs.deleted=0 AND contacts.id IS NULL ; -- 4 / 5,158 59 shiryo_fb_event_contacts SELECT shiryo_fb_event_contacts.id, contact_id, shiryo_fb_event_id, shiryo_fb_event.id AS shiryo_fb_event_id FROM shiryo_fb_event_contacts LEFT JOIN shiryo_fb_event ON shiryo_fb_event_contacts.shiryo_fb_event_id=shiryo_fb_event.id WHERE shiryo_fb_event_contacts.deleted=0 AND shiryo_fb_event.id IS NULL -- 8,326 SELECT shiryo_fb_event_contacts.id, shiryo_fb_event_id, contact_id, contacts.id AS contact_id FROM shiryo_fb_event_contacts LEFT JOIN contacts ON shiryo_fb_event_contacts.contact_id=contacts.id WHERE shiryo_fb_event_contacts.deleted=0 AND contacts.id IS NULL -- 1,325 SELECT shiryo_fb_event_contacts.id, shiryo_fb_event_id, shiryo_fb_event_category, shiryo_fb_event.id AS shiryo_fb_event_id, contact_id, contacts.id AS contact_id FROM shiryo_fb_event_contacts LEFT JOIN shiryo_fb_event ON shiryo_fb_event_contacts.shiryo_fb_event_id=shiryo_fb_event.id LEFT JOIN contacts ON shiryo_fb_event_contacts.contact_id=contacts.id WHERE shiryo_fb_event_contacts.deleted=0 AND contacts.id IS NULL AND shiryo_fb_event_category='event' SELECT shiryo_fb_event_contacts.id, shiryo_fb_event_id, shiryo_fb_event.id AS shiryo_fb_event_id, contact_id, contacts.id AS contact_id FROM shiryo_fb_event_contacts LEFT JOIN shiryo_fb_event ON shiryo_fb_event_contacts.shiryo_fb_event_id=shiryo_fb_event.id LEFT JOIN contacts ON shiryo_fb_event_contacts.contact_id=contacts.id WHERE shiryo_fb_event_contacts.deleted=0 AND contacts.id IS NULL AND shiryo_fb_event.id IS NULL -- 7,929 50 shukka_kobetsu_buppin SELECT shukka_kobetsu_buppin.id, shukka_kobetsu_id, buppin_id FROM shukka_kobetsu_buppin LEFT JOIN shukka_kobetsu ON shukka_kobetsu_buppin.shukka_kobetsu_id=shukka_kobetsu.id WHERE shukka_kobetsu.id IS NULL -- 0 SELECT shukka_kobetsu_buppin.id, shukka_kobetsu_id, buppin_id, buppin.id AS buppin_id FROM shukka_kobetsu_buppin LEFT JOIN buppin ON shukka_kobetsu_buppin.buppin_id=buppin.id WHERE buppin.id IS NULL -- shiryo_fb_event fix SELECT hakkounengetsu, SUBSTRING(hakkounengetsu, 1, 4), CONCAT(SUBSTRING(hakkounengetsu, 1, 4), SUBSTRING(hakkounengetsu, 6, 2)), SUBSTRING(hakkounengetsu, 6, 2), SUBSTRING(hakkounengetsu, 5, 1) FROM shiryo_fb_event WHERE SUBSTRING(hakkounengetsu, 5, 1)='-' UPDATE shiryo_fb_event SET hakkounengetsu = CONCAT(SUBSTRING(hakkounengetsu, 1, 4), SUBSTRING(hakkounengetsu, 6, 2)) WHERE SUBSTRING(hakkounengetsu, 5, 1)='-' SELECT * FROM shiryo_fb_event WHERE id IN ('9900135687', '9900135688', '9900135689', '9900135704', '9900135792', '9900135796', '9900135797', '9900135810', '9900135866') UPDATE shiryo_fb_event SET deleted=1 WHERE id IN ('9900135687', '9900135688', '9900135689', '9900135704', '9900135792', '9900135796', '9900135797', '9900135810', '9900135866') UPDATE `itojuku_importz1`.`shiryo_fb_event` SET `deleted` = '1' WHERE CONVERT( `shiryo_fb_event`.`id` USING utf8 ) = '---' LIMIT 1 ; UPDATE `itojuku_importz1`.`shiryo_fb_event` SET `deleted` = '1' WHERE CONVERT( `shiryo_fb_event`.`id` USING utf8 ) = '/' LIMIT 1 ; UPDATE `itojuku_importz1`.`shiryo_fb_event` SET `deleted` = '1' WHERE CONVERT( `shiryo_fb_event`.`id` USING utf8 ) = '0' LIMIT 1 ; UPDATE `itojuku_importz1`.`shiryo_fb_event` SET `deleted` = '1' WHERE CONVERT( `shiryo_fb_event`.`id` USING utf8 ) = '0000' LIMIT 1 ; UPDATE `itojuku_importz1`.`shiryo_fb_event` SET `deleted` = '1' WHERE CONVERT( `shiryo_fb_event`.`id` USING utf8 ) = '0185' LIMIT 1 ; SELECT shiryo_fb_event_contacts.id FROM shiryo_fb_event_contacts INNER JOIN shiryo_fb_event ON shiryo_fb_event.id=shiryo_fb_event_contacts.shiryo_fb_event_id AND shiryo_fb_event.deleted=1 -- 0 SELECT shiryo_fb_event_group_id FROM `shiryo_fb_event` WHERE `shiryo_fb_event_category` LIKE 'event' UPDATE shiryo_fb_event SET shiryo_fb_event_group_id=2 WHERE `shiryo_fb_event_category` LIKE 'event' 47 hassocode_contacts SELECT hassocode_contacts.id, contact_id, contacts.id as contact_id FROM hassocode_contacts LEFT JOIN contacts ON hassocode_contacts.contact_id=contacts.id WHERE hassocode_contacts.deleted=0 AND contacts.id IS NULL ; SELECT hassocode_contacts.id, hassocode_id, hassocode.id as hassocode_id FROM hassocode_contacts LEFT JOIN hassocode ON hassocode_contacts.hassocode_id=hassocode.id WHERE hassocode_contacts.hasso_type='1' AND hassocode_contacts.deleted=0 AND hassocode.id IS NULL ; SELECT hassocode_contacts.id, hassocode_id, shukka_kobetsu.id as hassocode_id FROM hassocode_contacts LEFT JOIN shukka_kobetsu ON hassocode_contacts.hassocode_id=shukka_kobetsu.id WHERE hassocode_contacts.hasso_type='2' AND hassocode_contacts.deleted=0 AND shukka_kobetsu.id IS NULL ; SELECT hassocode_contacts.id, event_id, smsevent.id as event_id FROM hassocode_contacts LEFT JOIN smsevent ON hassocode_contacts.event_id=smsevent.id WHERE hassocode_contacts.hasso_type='1' AND hassocode_contacts.deleted=0 AND smsevent.id IS NULL ; SELECT contact_id, hassocode_id, event_id, count(*) FROM hassocode_contacts GROUP BY contact_id, hassocode_id, event_id Having count(*)>1; 50-1 shukka_kobetsu SELECT shukka_kobetsu.id, contact_id, contacts.id as contact_id FROM shukka_kobetsu LEFT JOIN contacts ON shukka_kobetsu.contact_id=contacts.id WHERE shukka_kobetsu.deleted=0 AND contacts.id IS NULL ; -- 147 SELECT contact_id, hassocode, count(*) FROM shukka_kobetsu GROUP BY contact_id, hassocode Having count(*)>1; UPDATE shukka_kobetsu LEFT JOIN contacts ON shukka_kobetsu.contact_id=contacts.id SET shukka_kobetsu.deleted=1 WHERE shukka_kobetsu.deleted=0 AND contacts.id IS NULL 50-2 shukka_kobetsu_buppin SELECT shukka_kobetsu_buppin.id, shukka_kobetsu_id, shukka_kobetsu.id as shukka_kobetsu_id FROM shukka_kobetsu_buppin LEFT JOIN shukka_kobetsu ON shukka_kobetsu_buppin.shukka_kobetsu_id=shukka_kobetsu.id WHERE shukka_kobetsu_buppin.deleted=0 AND shukka_kobetsu.id IS NULL ; -- 0 SELECT shukka_kobetsu_buppin.id, buppin_id, buppin.id as buppin_id FROM shukka_kobetsu_buppin LEFT JOIN buppin ON shukka_kobetsu_buppin.buppin_id=buppin.id WHERE shukka_kobetsu_buppin.deleted=0 AND buppin.id IS NULL ; SELECT shukka_kobetsu_id, buppin_id, count(*) FROM shukka_kobetsu_buppin GROUP BY shukka_kobetsu_id, buppin_id Having count(*)>1; UPDATE shukka_kobetsu_buppin LEFT JOIN buppin ON shukka_kobetsu_buppin.buppin_id=buppin.id SET shukka_kobetsu_buppin.deleted=1 WHERE shukka_kobetsu_buppin.deleted=0 AND buppin.id IS NULL 53 koza SELECT id, koza_code, jukoukeitai_code, jukoukeitai_name, jukoukeitai, shikenshu FROM koza WHERE shikenshu IS NULL OR shikenshu='' student idnumber SELECT max( idnumber ) FROM `contacts` WHERE `smsgroup` LIKE 'student' AND SUBSTRING(idnumber, 1, 1)!= '9' AND idnumber NOT IN ('C') SELECT max( idnumber ) FROM `contacts` WHERE `smsgroup` LIKE 'student' AND SUBSTRING(idnumber, 1, 3)= '200' AND idnumber NOT IN ('C') buppin SELECT id, buppin_code, substring(buppin_code, 2, 1), shikenshu FROM `buppin` WHERE substring(buppin_code, 2, 1) IN ('A', 'B', 'C', 'D', 'E', 'F', 'Z') AND LENGTH(buppin_code)=11 UPDATE buppin SET shikenshu = substring(buppin_code, 2, 1) WHERE substring(buppin_code, 2, 1) IN ('A', 'B', 'C', 'D', 'E', 'F', 'Z') AND LENGTH(buppin_code)=11 SELECT id, buppin_code, kaikonen, substring(buppin_code, 3, 2), shikenshu FROM `buppin` WHERE substring(buppin_code, 2, 1) IN ('A', 'B', 'C', 'D', 'E', 'F', 'Z') AND LENGTH(buppin_code)=11 AND substring(buppin_code, 3, 2)!='TH' UPDATE buppin SET kaikonen=substring(buppin_code, 3, 2) WHERE substring(buppin_code, 2, 1) IN ('A', 'B', 'C', 'D', 'E', 'F', 'Z') AND LENGTH(buppin_code)=11 AND substring(buppin_code, 3, 2)!='TH' SELECT id, buppin_category, buppin_category+700000 FROM buppin WHERE 1 UPDATE buppin SET buppin_category=buppin_category+700000 WHERE 1 SELECT id, buppin_category, buppin_category+630000 FROM buppin WHERE buppin_category<70009 UPDATE buppin SET buppin_category=buppin_category+630000 WHERE buppin_category<70009 sms_transaction SELECT id, buppin_category FROM `sms_transaction` WHERE buppin_category!='' UPDATE sms_transaction SET buppin_category=buppin_category+700000 WHERE buppin_category!='' SELECT id, buppin_category FROM sms_fee WHERE buppin_category != '' UPDATE sms_fee SET buppin_category=buppin_category+700000 WHERE buppin_category != '' SELECT DISTINCT buppin_category FROM `sms_fee` WHERE buppin_category IS NOT NULL AND buppin_category!='700003' UPDATE sms_fee SET buppin_category=buppin_category+700000 WHERE buppin_category IS NOT NULL AND buppin_category!='700003' SELECT id, buppin_id, buppin_category FROM `sms_fee` WHERE buppin_id IS NOT NULL AND buppin_category IS NULL -- 2,170 SELECT id, buppin_category FROM `buppin` WHERE 1 UPDATE buppin SET buppin_category=buppin_category+700000 WHERE 1 koza SELECT id, jukoukeitai_code, jukoukeitai_name, jukoukeitai FROM koza WHERE jukoukeitai_name='2311' SELECT id, jukoukeitai_code, jukoukeitai_name, jukoukeitai FROM koza WHERE jukoukeitai_name='2312' UPDATE koza SET jukoukeitai='I', jukoukeitai_name='ライブ&インターネット' WHERE jukoukeitai_name='2311' UPDATE koza SET jukoukeitai='O', jukoukeitai_name='解説はネット受講' WHERE jukoukeitai_name='2312' SELECT id, `hanbaikahi` FROM `koza` WHERE 1 UPDATE koza SET hanbaikahi='01' WHERE 1 smsevent SELECT id, shikenshu FROM smsevent WHERE shikenshu='司法試験' SELECT id, shikenshu FROM smsevent WHERE shikenshu='司法書士' SELECT id, shikenshu FROM smsevent WHERE shikenshu='公務員' SELECT id, shikenshu FROM smsevent WHERE shikenshu='行政書士' SELECT id, shikenshu FROM smsevent WHERE shikenshu='LLM' UPDATE smsevent SET shikenshu='A' WHERE shikenshu='司法試験' ; UPDATE smsevent SET shikenshu='C' WHERE shikenshu='司法書士' ; UPDATE smsevent SET shikenshu='B' WHERE shikenshu='公務員' ; UPDATE smsevent SET shikenshu='D' WHERE shikenshu='行政書士' ; UPDATE smsevent SET shikenshu='E' WHERE shikenshu='LLM' ; SELECT id, last_name, jikanshitei FROM `contacts` WHERE `smsgroup` LIKE 'student' SELECT DISTINCT jikanshitei FROM `contacts` WHERE `smsgroup` LIKE 'student' SELECT id, last_name, jikanshitei FROM `contacts` WHERE `smsgroup` LIKE 'student' WHERE jikanshitei='021' SELECT DISTINCT uriagekubun FROM `sms_fee` WHERE 1 SELECT * FROM `sms_fee` WHERE uriagekubun='' ; -- 78,994 SELECT distinct payment_type FROM `sms_transaction` WHERE 1 SELECT * FROM `sms_transaction` WHERE payment_type='' SELECT * FROM `sms_transaction` WHERE nyuukinsaki_kouza='' SELECT sms_transaction.id, fee_id, sms_fee.id AS fee_id FROM sms_transaction LEFT JOIN sms_fee ON sms_fee.id=sms_transaction.fee_id SELECT sms_transaction.id, fee_id, sms_fee.id AS fee_id, sms_transaction.date_entered FROM sms_transaction LEFT JOIN sms_fee ON sms_fee.id = sms_transaction.fee_id SELECT sms_transaction.id, fee_id, sms_fee.id AS fee_id, sms_fee.salesno, sms_transaction.salesno, sms_transaction.date_entered FROM sms_transaction LEFT JOIN sms_fee ON sms_fee.id = sms_transaction.fee_id WHERE sms_fee.salesno=sms_transaction.salesno SELECT nyuukinsaki_shori_number FROM `sms_transaction` WHERE nyuukinsaki_shori_number IS NOT NULL AND nyuukinsaki_shori_number!='' -- 482,334 SELECT DISTINCT sms_fee.buppin_id FROM sms_fee LEFT JOIN buppin ON buppin.id = sms_fee.buppin_id WHERE sms_fee.buppin_id IS NOT NULL AND buppin.id IS NULL SELECT * FROM `sms_transaction` WHERE `nyuukinsaki_shori_number` IS NOT NULL AND nyuukinsaki_shori_number!='' SELECT sms_fee.salesno, sms_transaction.salesno FROM sms_fee, SELECT distinct `shukka_shubetsu` FROM `shukka_kobetsu` WHERE 1 SELECT * FROM `shukka_kobetsu` WHERE shukka_shubetsu='' SELECT distinct kaiyaku FROM `koza_contacts` WHERE 1 SELECT distinct nyuukinsaki_card_credit FROM `kyoikukunren_contacs` WHERE 1 SELECT id, payment_type FROM sms_transaction WHERE payment_type='03' SELECT id, payment_type FROM sms_transaction WHERE payment_type='04' UPDATE sms_transaction SET payment_type='xx' WHERE payment_type='03' UPDATE sms_transaction SET payment_type='03' WHERE payment_type='04' UPDATE sms_transaction SET payment_type='04' WHERE payment_type='xx' SELECT smsevent_instances.event_id as class_id, target_id AS student_id, from_datetime, to_datetime, smsevent.name AS class_name, kamoku, curriculum_id FROM smsevent_instances LEFT JOIN smsevent ON smsevent.id=smsevent_instances.event_id WHERE smsevent.id IS NULL SELECT instance_id, target_id, count(*) FROM smsevent_instances GROUP BY instance_id, target_id HAVING COUNT(*) > 1 SELECT event_id, target_id, from_datetime, count(*) FROM smsevent_instances GROUP BY event_id, target_id, from_datetime HAVING COUNT(*) > 1 SELECT * FROM `smsevent_instances` WHERE `event_id` LIKE 'CL0302067' AND `target_id` LIKE '0162683' ORDER BY `smsevent_instances`.`attendance_status` ASC SELECT * FROM `sms_transaction` WHERE `nyuukinsaki_shori_number` IS NOT NULL AND nyuukinsaki_shori_number!='' AND nyuukinsaki_card_credit = '08' SELECT * FROM `sms_transaction` WHERE `nyuukinsaki_card_credit` IS NOT NULL AND nyuukinsaki_card_credit!='' SELECT sms_transaction.salesno, sms_fee.salesno FROM sms_fee, sms_transaction WHERE sms_fee.id=sms_transaction.fee_id AND sms_fee.salesno!=sms_transaction.salesno UPDATE sms_fee, sms_transactionSET sms_transaction.salesno=sms_fee.salesno WHERE sms_fee.id=sms_transaction.fee_id AND sms_fee.salesno!=sms_transaction.salesno CREATE TABLE IF NOT EXISTS `kozah` ( `idh` char(36) NOT NULL, `kaikonenh` varchar(5) DEFAULT NULL, `common_codeh` varchar(100) DEFAULT NULL, `kih` varchar(36) DEFAULT NULL, `jukoukeitai_codeh` varchar(100) DEFAULT NULL, KEY (`idh`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SELECT id, kaikonen, ki, kaikonenh, kih FROM koza INNER JOIN kozah ON koza.id=kozah.idh WHERE koza.deleted=0 UPDATE koza INNER JOIN kozah ON koza.id=kozah.idh SET kaikonen=kaikonenh, ki=kih WHERE koza.deleted=0 SELECT id, common_code, LENGTH(common_code), common_codeh FROM koza INNER JOIN kozah ON koza.id=kozah.idh WHERE substring( common_code, 1, 3 ) NOT IN ('959', '969', '979', '989', '999', 'A99', 'C18', 'C99') AND LENGTH(common_code)!=11 AND substring( common_code, 1, 2)!=common_codeh -- zero hits SELECT id, common_code, SUBSTRING(common_code, 3, 20), common_codeh FROM koza INNER JOIN kozah ON koza.id=kozah.idh WHERE substring( common_code, 1, 3 ) IN ('959', '969', '979', '989', '999') AND LENGTH(common_code)=12 UPDATE koza INNER JOIN kozah ON koza.id=kozah.idh SET common_code=CONCAT(common_codeh, SUBSTRING(common_code, 3, 20)) WHERE substring( common_code, 1, 3 ) IN ('959', '969', '979', '989', '999') AND LENGTH(common_code)=12 SELECT id, common_code, SUBSTRING(common_code, 3, 20), common_codeh FROM koza INNER JOIN kozah ON koza.id=kozah.idh WHERE substring( common_code, 1, 3 ) IN ('959', '969', '979', '989', '999') AND LENGTH(common_code)=9 UPDATE koza INNER JOIN kozah ON koza.id=kozah.idh SET common_code=CONCAT(common_codeh, common_code) WHERE substring( common_code, 1, 3 ) IN ('959', '969', '979', '989', '999') AND LENGTH(common_code)=9 SELECT id, common_code, substring(common_code, 1, 3), SUBSTRING(common_code, 3, 20), common_codeh FROM koza INNER JOIN kozah ON koza.id=kozah.idh WHERE substring( common_code, 1, 3 ) IN ('A99', 'C18', 'C99') UPDATE koza INNER JOIN kozah ON koza.id=kozah.idh SET common_code=CONCAT(common_codeh, common_code) WHERE substring( common_code, 1, 3 ) IN ('A99', 'C18', 'C99') SELECT id, common_code, ki, kaikonen, jukoukeitai, jukoukeitai_code, jukoukeitai_name, shikenshu FROM koza WHERE LENGTH( jukoukeitai_code )=5 SELECT id, common_code, jukoukeitai_code, jukoukeitai_codeh, SUBSTRING(jukoukeitai_code, 3, 20) FROM koza INNER JOIN kozah ON koza.id=kozah.idh UPDATE koza INNER JOIN kozah ON koza.id=kozah.idh SET jukoukeitai_code=CONCAT(jukoukeitai_codeh, SUBSTRING(jukoukeitai_code, 3, 20) ) SELECT id, common_code, ki, kaikonen, jukoukeitai, jukoukeitai_code, CONCAT(SUBSTRING(jukoukeitai_code, 1,2) , 'D', SUBSTRING(jukoukeitai_code,4, 20)), SUBSTRING(jukoukeitai_code,3,1), jukoukeitai_name, shikenshu FROM koza WHERE school_id ='1c51e9f5-af67-8530-3f46-514a925d35b5' AND LENGTH(jukoukeitai_code)=6 UPDATE koza SET jukoukeitai_code=CONCAT(SUBSTRING(jukoukeitai_code, 1,2) , 'D', SUBSTRING(jukoukeitai_code,4, 20)) WHERE school_id ='1c51e9f5-af67-8530-3f46-514a925d35b5' AND LENGTH(jukoukeitai_code)=6 SELECT id, common_code, ki, kaikonen, jukoukeitai, jukoukeitai_code, CONCAT(SUBSTRING(jukoukeitai_code, 1,2) , 'S', SUBSTRING(jukoukeitai_code,4, 20)), SUBSTRING(jukoukeitai_code,3,1), jukoukeitai_name, shikenshu FROM koza WHERE school_id ='1a54c64f-e83b-3c54-bcb4-5111d72bcf7c' AND LENGTH(jukoukeitai_code)=6 UPDATE koza SET jukoukeitai_code=CONCAT(SUBSTRING(jukoukeitai_code, 1,2) , 'S', SUBSTRING(jukoukeitai_code,4, 20)) WHERE school_id ='1a54c64f-e83b-3c54-bcb4-5111d72bcf7c' AND LENGTH(jukoukeitai_code)=6 UPDATE `itojuku_importz1`.`koza` SET `common_code` = '14D190020001' WHERE CONVERT( `koza`.`id` USING utf8 ) = '0500000921683' LIMIT 1 ; SELECT id, jukoukeitai_code, jukoukeitai_codeo FROM koza INNER JOIN kozao WHERE koza.id=kozao.ido UPDATE koza INNER JOIN kozao SET jukoukeitai_code= jukoukeitai_codeo WHERE koza.id=kozao.ido CREATE TABLE IF NOT EXISTS `kozao` ( `ido` char(36) NOT NULL, `jukoukeitai_codeo` varchar(100) DEFAULT NULL, KEY (`ido`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; preparing training site TRUNCATE `curriculum`; TRUNCATE `event_contacts`; TRUNCATE `event_koza`; TRUNCATE `koza`; TRUNCATE `koza_contacts`; TRUNCATE `smsevent`; TRUNCATE `smsevent_instances`; TRUNCATE `sms_event_instance`; TRUNCATE `sms_event_instance_sub`; TRUNCATE `sms_recurrence`; SELECT hassocode.hassocode, hassocode.id as old_hassocode, hassocode.edaban, hassocode_contacts.id as hassocode_contact_id, hassobi.hassobi, hassocode_contacts.hassocode_contacts_hassobi as real_hassobi, concat(hassocode.hassocode, hassocode.edaban) as uniqu_id, hassocode_contacts.hasso_type, hassocode_contacts.teiki_nichiji, event_contacts.contact_id, hassocode.id as hassocode_id, smsevent.id as event_id, '1' as hasso_type, hassobi.extract_flg, event_contacts.end_date FROM event_contacts INNER JOIN smsevent ON event_contacts.event_id=smsevent.id AND smsevent.deleted=0 INNER JOIN hassobi ON smsevent.id=hassobi.event_id AND hassobi.deleted=0 INNER JOIN hassocode_hassobi ON hassocode_hassobi.hassobi_id=hassobi.id AND hassocode_hassobi.deleted=0 INNER JOIN hassocode ON hassocode_hassobi.hassocode_id=hassocode.id AND hassocode.deleted=0 LEFT JOIN hassocode_contacts ON hassocode.id=hassocode_contacts.hassocode_id AND event_contacts.contact_id=hassocode_contacts.contact_id AND hassocode_contacts.deleted=0 WHERE event_contacts.deleted=0 AND hassocode_contacts.id IS NOT NULL AND hassobi.hassobi < hassocode_contacts.hassocode_contacts_hassobi UPDATE event_contacts INNER JOIN smsevent ON event_contacts.event_id=smsevent.id AND smsevent.deleted=0 INNER JOIN hassobi ON smsevent.id=hassobi.event_id AND hassobi.deleted=0 INNER JOIN hassocode_hassobi ON hassocode_hassobi.hassobi_id=hassobi.id AND hassocode_hassobi.deleted=0 INNER JOIN hassocode ON hassocode_hassobi.hassocode_id=hassocode.id AND hassocode.deleted=0 LEFT JOIN hassocode_contacts ON hassocode.id=hassocode_contacts.hassocode_id AND event_contacts.contact_id=hassocode_contacts.contact_id AND hassocode_contacts.deleted=0 SET hassocode_contacts.teiki_nichiji=2 WHERE event_contacts.deleted=0 AND hassocode_contacts.id IS NOT NULL AND hassobi.hassobi < hassocode_contacts.hassocode_contacts_hassobi SELECT * FROM `hassocode_contacts` WHERE `hassocode_contacts_hassobi` > '2013-12-08' UPDATE hassocode_contacts SET deleted=1 WHERE `hassocode_contacts_hassobi` > '2013-12-08' SELECT hasso_contacts.* FROM hasso_contacts LEFT JOIN hassocode_contacts ON hassocode_contacts.id=hasso_contacts.hassocode_contacts_id WHERE hassocode_contacts.deleted=1 UPDATE hasso_contacts LEFT JOIN hassocode_contacts ON hassocode_contacts.id=hasso_contacts.hassocode_contacts_id SET hasso_contacts.deleted=1 WHERE hassocode_contacts.deleted=1 REPLACE INTO `aaa` (`id`, `contact_id`, `event_id`, `deleted`, `start_date`) VALUES ('10cb259c-73d0-8250-72f7-5278ac34e8cd', 'bb414e3f-7c34-b86f-7335-5278a58b6177', '9e396d88-6cce-14e3-ab9b-5278a2f9ffcc', 1, NULL), ('11xxx5-5289e2757014', 'xf0f26c6-98f0-4044-cc67-528045b90719', 'x206d36c-841f-08ad-0e37-5289ad8beb07', 0, NULL); UPDATE koza_code_master SET deleted=1 WHERE id IN ( '1a000001276', '1a000001277', '1a000001278', '1a000001279', '1a000001280', '1a000001281', '1a000001282', '1a000001283', '1a000001284', '1a000001285', '1a000001286', '1a000001287', '1a000001288', '1a000001289', '1a000001290', '1a000001291', '1a000001292', '1a000001293', '1a000001294', '1a000001295', '1a000001296', '1a000001297', '1a000001298', '1a000001299', '1a000001300', '1a000001301', '1a000001302', '1a000001303', '1a000001304', '1a000001305', '1a000001306', '1a000001307', '1a000001308', '1a000001309', '1a000001310', '1a000001311', '1a000001312', '1a000001313', '1a000001314', '1a000001315', '1a000001316', '1a000001317', '1a000001318', '1a000001319', '1a000001320', '1a000001321', '1a000001322', '1a000001323', '1a000001324', '1a000001325', '1a000001326', '1a000001327', '1a000001328', '1a000001329', '1a000001330', '1a000001331', '1a000001332', '1a000001333', '1a000001334', '1a000001335', '1a000001336', '1a000001337', '1a000001338', '1a000001339', '1a000001340', '1a000001341', '1a000001342', '1a000001343', '1a000001344', '1a000001345', '1a000001346', '1a000001347', '1a000001348', '1a000001349', '1a000001350', '1a000001351', '1a000001352', '1a000001353', '1a000001354', '1a000001355', '1a000001356', '1a000001357', '1a000001358', '1a000001359', '1a000001360', '1a000001361', '1a000001362', '1a000001363', '1a000001364', '1a000001365', '1a000001366', '1a000001367', '1a000001368', '1a000001369', '1a000001370', '1a000001371', '1a000001372', '1a000001373', '1a000001374', '1a000001375', '1a000001376', '1a000001377', '1a000001378', '1a000001379', '1a000001380', '1a000001381', '1a000001382', '1a000001383', '1a000001384', '1a000001385', '1a000001386', '1a000001387', '1a000001388', '1a000001389', '1a000001390', '1a000001391', '1a000001392', '1a000001393', '1a000001394', '1a000001395', '1a000001396', '1a000001397', '1a000001398', '1a000001399', '1a000001400', '1a000001401', '1a000001402', '1a000001403', '1a000001404', '1a000001405', '1a000001406', '1a000001407', '1a000001408', '1a000001409', '1a000001410', '1a000001411', '1a000001412', '1a000001413', '1a000001414', '1a000001415', '1a000001416', '1a000001417', '1a000001418', '1a000001419', '1a000001420', '1a000001421', '1a000001422', '1a000001423', '1a000001424', '1a000001425', '1a000001426', '1a000001427', '1a000001428', '1a000001429', '1a000001430', '1a000001431', '1a000001432', '1a000001433', '1a000001434', '1a000001435', '1a000001436', '1a000001437', '1a000001438', '1a000001439', '1a000001440', '1a000001441', '1a000001442', '1a000001443', '1a000001444', '1a000001445', '1a000001446', '1a000001447', '1a000001448', '1a000001449', '1a000001450', '1a000001451', '1a000001452', '1a000001453', '1a000001454', '1a000001455', '1a000001456', '1a000001457', '1a000001458', '1a000001459', '1a000001460', '1a000001461', '1a000001462', '1a000001463', '1a000001464', '1a000001465', '1a000001466', '1a000001467', '1a000001468', '1a000001469', '1a000001470', '1a000001471', '1a000001472', '1a000001473', '1a000001474', '1a000001475', '1a000001476', '1a000001477', '1a000001478', '1a000001479', '1a000001480', '1a000001481', '1a000001482', '1a000001483', '1a000001484', '1a000001485', '1a000001486', '1a000001487', '1a000001488', '1a000001489', '1a000001490', '1a000001491', '1a000001492', '1a000001493', '1a000001494', '1a000001495', '1a000001496', '1a000001497', '1a000001498', '1a000001499', '1a000001500', '1a000001501', '1a000001502', '1a000001503', '1a000001504', '1a000001505', '1a000001506', '1a000001507', '1a000001508', '1a000001509', '1a000001510', '1a000001511', '1a000001512', '1a000001513', '1a000001514', '1a000001515', '1a000001516', '1a000001517', '1a000001518', '1a000001519', '1a000001520', '1a000001521', '1a000001522', '1a000001523', '1a000001524', '1a000001525', '1a000001526', '1a000001527', '1a000001528', '1a000001529', '1a000001530', '1a000001531', '1a000001532', '1a000001533', '1a000001534', '1a000001535', '1a000001536', '1a000001537', '1a000001538', '1a000001539', '1a000001540', '1a000001541', '1a000001542', '1a000001543', '1a000001544', '1a000001545', '1a000001546', '1a000001547', '1a000001548', '1a000001549', '1a000001550', '1a000001551', '1a000001552', '1a000001553', '1a000001554', '1a000001555', '1a000001556', '1a000001557', '1a000001558', '1a000001559', '1a000001560', '1a000001561', '1a000001562', '1a000001563', '1a000001564', '1a000001565', '1a000001566', '1a000001567', '1a000001568', '1a000001569', '1a000001570', '1a000001571', '1a000001572', '1a000001573', '1a000001574', '1a000001575', '1a000001576', '1a000001577', '1a000001578', '1a000001579', '1a000001580', '1a000001581', '1a000001582', '1a000001583', '1a000001584', '1a000001585', '1a000001586', '1a000001587', '1a000001588', '1a000001589', '1a000001590', '1a000001591', '1a000001592', '1a000001593', '1a000001594', '1a000001595', '1a000001596', '1a000001597', '1a000001598', '1a000001599', '1a000001600', '1a000001601', '1a000001602', '1a000001603', '1a000001604', '1a000001605', '1a000001606', '1a000001607', '1a000001608', '1a000001609', '1a000001610', '1a000001611', '1a000001612', '1a000001613', '1a000001614', '1a000001615', '1a000001616', '1a000001617', '1a000001618', '1a000001619', '1a000001620', '1a000001621', '1a000001622', '1a000001623', '1a000001624', '1a000001625', '1a000001626', '1a000001627', '1a000001628', '1a000001629', '1a000001630', '1a000001631', '1a000001632', '1a000001633', '1a000001634', '1a000001635', '1a000001636', '1a000001637', '1a000001638', '1a000001639', '1a000001640', '1a000001641', '1a000001642', '1a000001643', '1a000001644', '1a000001645', '1a000001646', '1a000001647', '1a000001648', '1a000001649', '1a000001650', '1a000001651', '1a000001652', '1a000001653', '1a000001654', '1a000001655', '1a000001656', '1a000001657', '1a000001658', '1a000001659', '1a000001660', '1a000001661', '1a000001662', '1a000001663', '1a000001664', '1a000001665', '1a000001666', '1a000001667', '1a000001668', '1a000001669', '1a000001670', '1a000001671', '1a000001672', '1a000001673', '1a000001674', '1a000001675', '1a000001676', '1a000001677', '1a000001678', '1a000001679', '1a000001680', '1a000001681', '1a000001682', '1a000001683', '1a000001684', '1a000001685', '1a000001686', '1a000001687', '1a000001688', '1a000001689', '1a000001690', '1a000001691', '1a000001692', '1a000001693', '1a000001694', '1a000001695', '1a000001696', '1a000001697', '1a000001698', '1a000001699', '1a000001700', '1a000001701', '1a000001702', '1a000001703', '1a000001704', '1a000001705', '1a000001706', '1a000001707', '1a000001708', '1a000001709', '1a000001710', '1a000001711', '1a000001712', '1a000001713', '1a000001714', '1a000001715', '1a000001716', '1a000001717', '1a000001718', '1a000001719', '1a000001720', '1a000001721', '1a000001722', '1a000001723', '1a000001724', '1a000001725', '1a000001726', '1a000001727', '1a000001728', '1a000001729', '1a000001730', '1a000001731', '1a000001732', '1a000001733', '1a000001734', '1a000001735', '1a000001736', '1a000001737', '1a000001738', '1a000001739', '1a000001740', '1a000001741', '1a000001742', '1a000001743', '1a000001744', '1a000001745', '1a000001746', '1a000001747', '1a000001748', '1a000001749', '1a000001750', '1a000001751', '1a000001752', '1a000001753', '1a000001754', '1a000001755', '1a000001756', '1a000001757', '1a000001758', '1a000001759', '1a000001760', '1a000001761', '1a000001762', '1a000001763', '1a000001764', '1a000001765', '1a000001766', '1a000001767', '1a000001768', '1a000001769', '1a000001770', '1a000001771', '1a000001772', '1a000001773', '1a000001774', '1a000001775', '1a000001776', '1a000001777', '1a000001778', '1a000001779', '1a000001780', '1a000001781', '1a000001782', '1a000001783', '1a000001784', '1a000001785', '1a000001786', '1a000001787', '1a000001788', '1a000001789', '1a000001790', '1a000001791', '1a000001792', '1a000001793', '1a000001794', '1a000001795', '1a000001796', '1a000001797', '1a000001798', '1a000001799', '1a000001800', '1a000001801', '1a000001802', '1a000001803', '1a000001804', '1a000001805', '1a000001806', '1a000001807', '1a000001808', '1a000001809', '1a000001810', '1a000001811', '1a000001812', '1a000001813', '1a000001814', '1a000001815', '1a000001816', '1a000001817', '1a000001818', '1a000001819', '1a000001820', '1a000001821', '1a000001822', '1a000001823', '1a000001824', '1a000001825', '1a000001826', '1a000001827', '1a000001828', '1a000001829', '1a000001830', '1a000001831', '1a000001832', '1a000001833', '1a000001834', '1a000001835', '1a000001836', '1a000001837', '1a000001838', '1a000001839', '1a000001840', '1a000001841', '1a000001842', '1a000001843', '1a000001844', '1a000001845', '1a000001846', '1a000001847', '1a000001848', '1a000001849', '1a000001850', '1a000001851', '1a000001852', '1a000001853', '1a000001854', '1a000001855', '1a000001856', '1a000001857', '1a000001858', '1a000001859', '1a000001860', '1a000001861', '1a000001862', '1a000001863', '1a000001864', '1a000001865', '1a000001866', '1a000001867', '1a000001868', '1a000001869', '1a000001870', '1a000001871', '1a000001872', '1a000001873', '1a000001874', '1a000001875', '1a000001876', '1a000001877', '1a000001878', '1a000001879', '1a000001880', '1a000001881', '1a000001882', '1a000001883', '1a000001884', '1a000001885', '1a000001886', '1a000001887', '1a000001888', '1a000001889', '1a000001890', '1a000001891', '1a000001892', '1a000001893', '1a000001894', '1a000001895', '1a000001896', '1a000001897', '1a000001898', '1a000001899', '1a000001900', '1a000001901', '1a000001902', '1a000001903', '1a000001904', '1a000001905', '1a000001906', '1a000001907', '1a000001908', '1a000001909', '1a000001910', '1a000001911', '1a000001912', '1a000001913', '1a000001914', '1a000001915', '1a000001916', '1a000001917', '1a000001918', '1a000001919', '1a000001920', '1a000001921', '1a000001922', '1a000001923', '1a000001924', '1a000001925', '1a000001926', '1a000001927', '1a000001928', '1a000001929', '1a000001930', '1a000001931', '1a000001932', '1a000001933', '1a000001934', '1a000001935', '1a000001936', '1a000001937', '1a000001938', '1a000001939', '1a000001940', '1a000001941', '1a000001942', '1a000001943', '1a000001944', '1a000001945', '1a000001946', '1a000001947', '1a000001948', '1a000001949', '1a000001950', '1a000001951', '1a000001952', '1a000001953', '1a000001954', '1a000001955', '1a000001956', '1a000001957', '1a000001958', '1a000001959', '1a000001960', '1a000001961', '1a000001962', '1a000001963', '1a000001964', '1a000001965', '1a000001966', '1a000001967', '1a000001968', '1a000001969', '1a000001970', '1a000001971', '1a000001972', '1a000001973', '1a000001974', '1a000001975', '1a000001976', '1a000001977', '1a000001978', '1a000001979', '1a000001980', '1a000001981', '1a000001982', '1a000001983', '1a000001984', '1a000001985', '1a000001986', '1a000001987', '1a000001988', '1a000001989', '1a000001990', '1a000001991', '1a000001992', '1a000001993', '1a000001994', '1a000001995', '1a000001996', '1a000001997', '1a000001998', '1a000001999', '1a000002000', '1a000002001', '1a000002002', '1a000002003', '1a000002004', '1a000002005', '1a000002006', '1a000002007', '1a000002008', '1a000002009', '1a000002010', '1a000002011', '1a000002012', '1a000002013', '1a000002014', '1a000002015', '1a000002016', '1a000002017', '1a000002018', '1a000002019', '1a000002020', '1a000002021', '1a000002022', '1a000002023', '1a000002024', '1a000002025', '1a000002026', '1a000002027', '1a000002028', '1a000002029', '1a000002030', '1a000002031', '1a000002032', '1a000002033', '1a000002034', '1a000002035', '1a000002036', '1a000002037', '1a000002038', '1a000002039', '1a000002040', '1a000002041', '1a000002042', '1a000002043', '1a000002044', '1a000002045', '1a000002046', '1a000002047', '1a000002048', '1a000002049', '1a000002050', '1a000002051', '1a000002052', '1a000002053', '1a000002054', '1a000002055', '1a000002056', '1a000002057', '1a000002058', '1a000002059', '1a000002060', '1a000002061', '1a000002062', '1a000002063', '1a000002064', '1a000002065', '1a000002066', '1a000002067', '1a000002068', '1a000002069', '1a000002070', '1a000002071', '1a000002072', '1a000002073', '1a000002074', '1a000002075', '1a000002076', '1a000002077', '1a000002078', '1a000002079', '1a000002080', '1a000002081', '1a000002082', '1a000002083', '1a000002084', '1a000002085', '1a000002086', '1a000002087', '1a000002088', '1a000002089', '1a000002090', '1a000002091', '1a000002092', '1a000002093', '1a000002094', '1a000002095', '1a000002096', '1a000002097', '1a000002098', '1a000002099', '1a000002100', '1a000002101', '1a000002102', '1a000002103', '1a000002104', '1a000002105', '1a000002106', '1a000002107', '1a000002108', '1a000002109', '1a000002110', '1a000002111', '1a000002112', '1a000002113', '1a000002114', '1a000002115', '1a000002116', '1a000002117', '1a000002118', '1a000002119', '1a000002120', '1a000002121', '1a000002122', '1a000002123', '1a000002124', '1a000002125', '1a000002126', '1a000002127', '1a000002128', '1a000002129', '1a000002130', '1a000002131', '1a000002132', '1a000002133', '1a000002134', '1a000002135', '1a000002136', '1a000002137', '1a000002138', '1a000002139', '1a000002140', '1a000002141', '1a000002142', '1a000002143', '1a000002144', '1a000002145', '1a000002146', '1a000002147', '1a000002148', '1a000002149', '1a000002150', '1a000002151', '1a000002152', '1a000002153', '1a000002154', '1a000002155', '1a000002156', '1a000002157', '1a000002158', '1a000002159', '1a000002160', '1a000002161', '1a000002162', '1a000002163', '1a000002164', '1a000002165', '1a000002166', '1a000002167', '1a000002168', '1a000002169', '1a000002170', '1a000002171', '1a000002172', '1a000002173', '1a000002174', '1a000002175', '1a000002176', '1a000002177', '1a000002178', '1a000002179', '1a000002180', '1a000002181', '1a000002182', '1a000002183', '1a000002184', '1a000002185', '1a000002186', '1a000002187', '1a000002188', '1a000002189', '1a000002190', '1a000002191', '1a000002192', '1a000002193', '1a000002194', '1a000002195', '1a000002196', '1a000002197', '1a000002198', '1a000002199', '1a000002200', '1a000002201', '1a000002202', '1a000002203', '1a000002204', '1a000002205', '1a000002206', '1a000002207', '1a000002208', '1a000002209', '1a000002210', '1a000002211', '1a000002212', '1a000002213', '1a000002214', '1a000002215', '1a000002216', '1a000002217', '1a000002218', '1a000002219', '1a000002220', '1a000002221', '1a000002222', '1a000002223', '1a000002224', '1a000002225', '1a000002226', '1a000002227', '1a000002228', '1a000002229', '1a000002230', '1a000002231', '1a000002232', '1a000002233', '1a000002234', '1a000002235', '1a000002236', '1a000002237', '1a000002238', '1a000002239', '1a000002240', '1a000002241', '1a000002242', '1a000002243', '1a000002244', '1a000002245', '1a000002246', '1a000002247', '1a000002248', '1a000002249', '1a000002250', '1a000002251', '1a000002252', '1a000002253', '1a000002254', '1a000002255', '1a000002256', '1a000002257', '1a000002258', '1a000002259', '1a000002260', '1a000002261', '1a000002262', '1a000002263', '1a000002264', '1a000002265', '1a000002266', '1a000002267', '1a000002268', '1a000002269', '1a000002270', '1a000002271', '1a000002272', '1a000002273', '1a000002274', '1a000002275', '1a000002276', '1a000002277', '1a000002278', '1a000002279', '1a000002280', '1a000002281', '1a000002282', '1a000002283', '1a000002284', '1a000002285', '1a000002286', '1a000002287', '1a000002288', '1a000002289', '1a000002290', '1a000002291', '1a000002292', '1a000002293', '1a000002294', '1a000002295', '1a000002296', '1a000002297', '1a000002298', '1a000002299', '1a000002300', '1a000002301', '1a000002302', '1a000002303', '1a000002304', '1a000002305', '1a000002306', '1a000002307', '1a000002308', '1a000002309', '1a000002310', '1a000002311', '1a000002312', '1a000002313', '1a000002314', '1a000002315', '1a000002316', '1a000002317', '1a000002318', '1a000002319', '1a000002320', '1a000002321', '1a000002322', '1a000002323', '1a000002324', '1a000002325', '1a000002326', '1a000002327', '1a000002328', '1a000002329', '1a000002330', '1a000002331', '1a000002332', '1a000002333', '1a000002334', '1a000002335', '1a000002336', '1a000002337', '1a000002338', '1a000002339', '1a000002340', '1a000002341', '1a000002342', '1a000002343', '1a000002344', '1a000002345', '1a000002346', '1a000002347', '1a000002348', '1a000002349', '1a000002350', '1a000002351', '1a000002352', '1a000002353', '1a000002354', '1a000002355', '1a000002356', '1a000002357', '1a000002358', '1a000002359', '1a000002360', '1a000002361', '1a000002362', '1a000002363', '1a000002364', '1a000002365', '1a000002366', '1a000002367', '1a000002368', '1a000002369', '1a000002370', '1a000002371', '1a000002372', '1a000002373', '1a000002374', '1a000002375', '1a000002376', '1a000002377', '1a000002378', '1a000002379', '1a000002380', '1a000002381', '1a000002382', '1a000002383', '1a000002384', '1a000002385', '1a000002386', '1a000002387', '1a000002388', '1a000002389', '1a000002390', '1a000002391', '1a000002392', '1a000002393', '1a000002394', '1a000002395', '1a000002396', '1a000002397', '1a000002398', '1a000002399', '1a000002400', '1a000002401', '1a000002402', '1a000002403', '1a000002404', '1a000002405', '1a000002406', '1a000002407', '1a000002408', '1a000002409', '1a000002410', '1a000002411', '1a000002412', '1a000002413', '1a000002414', '1a000002415', '1a000002416', '1a000002417', '1a000002418', '1a000002419', '1a000002420', '1a000002421', '1a000002422', '1a000002423', '1a000002424', '1a000002425', '1a000002426', '1a000002427', '1a000002428', '1a000002429', '1a000002430', '1a000002431', '1a000002432', '1a000002433', '1a000002434', '1a000002435', '1a000002436', '1a000002437', '1a000002438', '1a000002439', '1a000002440', '1a000002441', '1a000002442', '1a000002443', '1a000002444', '1a000002445', '1a000002446', '1a000002447', '1a000002448', '1a000002449', '1a000002450', '1a000002451', '1a000002452', '1a000002453', '1a000002454', '1a000002455', '1a000002456', '1a000002457', '1a000002458', '1a000002459', '1a000002460', '1a000002461', '1a000002462', '1a000002463', '1a000002464', '1a000002465', '1a000002466', '1a000002467', '1a000002468', '1a000002469', '1a000002470', '1a000002471', '1a000002472', '1a000002473', '1a000002474', '1a000002475', '1a000002476', '1a000002477', '1a000002478', '1a000002479', '1a000002480', '1a000002481', '1a000002482', '1a000002483', '1a000002484', '1a000002485', '1a000002486', '1a000002487', '1a000002488', '1a000002489', '1a000002490', '1a000002491', '1a000002492', '1a000002493', '1a000002494', '1a000002495', '1a000002496', '1a000002497', '1a000002498', '1a000002499', '1a000002500', '1a000002501', '1a000002502', '1a000002503', '1a000002504', '1a000002505', '1a000002506', '1a000002507', '1a000002508', '1a000002509', '1a000002510', '1a000002511', '1a000002512', '1a000002513', '1a000002514', '1a000002515', '1a000002516', '1a000002517', '1a000002518', '1a000002519', '1a000002520', '1a000002521', '1a000002522', '1a000002523', '1a000002524', '1a000002525', '1a000002526', '1a000002527', '1a000002528', '1a000002529', '1a000002530', '1a000002531', '1a000002532', '1a000002533', '1a000002534', '1a000002535', '1a000002536', '1a000002537', '1a000002538', '1a000002539', '1a000002540', '1a000002541', '1a000002542', '1a000002543', '1a000002544', '1a000002545', '1a000002546', '1a000002547', '1a000002548', '1a000002549', '1a000002550', '1a000002551', '1a000002552', '1a000002553', '1a000002554', '1a000002555', '1a000002556', '1a000002557', '1a000002558', '1a000002559', '1a000002560', '1a000002561', '1a000002562', '1a000002563', '1a000002564', '1a000002565', '1a000002566', '1a000002567', '1a000002568', '1a000002569', '1a000002570', '1a000002571', '1a000002572', '1a000002573', '1a000002574', '1a000002575', '1a000002576', '1a000002577', '1a000002578', '1a000002579', '1a000002580', '1a000002581', '1a000002582', '1a000002583', '1a000002584', '1a000002585', '1a000002586', '1a000002587', '1a000002588', '1a000002589', '1a000002590', '1a000002591', '1a000002592', '1a000002593', '1a000002594', '1a000002595', '1a000002596', '1a000002597', '1a000002598', '1a000002599', '1a000002600', '1a000002601', '1a000002602', '1a000002603', '1a000002604', '1a000002605', '1a000002606', '1a000002607', '1a000002608', '1a000002609', '1a000002610', '1a000002611', '1a000002612', '1a000002613', '1a000002614', '1a000002615', '1a000002616', '1a000002617', '1a000002618', '1a000002619', '1a000002620', '1a000002621', '1a000002622', '1a000002623', '1a000002624', '1a000002625', '1a000002626', '1a000002627', '1a000002628', '1a000002629', '1a000002630', '1a000002631', '1a000002632', '1a000002633', '1a000002634', '1a000002635', '1a000002636', '1a000002637', '1a000002638', '1a000002639', '1a000002640', '1a000002641', '1a000002642', '1a000002643', '1a000002644', '1a000002645', '1a000002646', '1a000002647', '1a000002648', '1a000002649', '1a000002650', '1a000002651', '1a000002652', '1a000002653', '1a000002654', '1a000002655', '1a000002656', '1a000002657', '1a000002658', '1a000002659', '1a000002660', '1a000002661', '1a000002662', '1a000002663', '1a000002664', '1a000002665', '1a000002666', '1a000002667', '1a000002668', '1a000002669', '1a000002670', '1a000002671', '1a000002672', '1a000002673', '1a000002674', '1a000002675', '1a000002676', '1a000002677', '1a000002678', '1a000002679', '1a000002680', '1a000002681', '1a000002682', '1a000002683', '1a000002684', '1a000002685', '1a000002686', '1a000002687', '1a000002688', '1a000002689', '1a000002690', '1a000002691', '1a000002692', '1a000002693', '1a000002694', '1a000002695', '1a000002696', '1a000002697', '1a000002698', '1a000002699', '1a000002700', '1a000002701', '1a000002702', '1a000002703', '1a000002704', '1a000002705', '1a000002706', '1a000002707', '1a000002708', '1a000002709', '1a000002710', '1a000002711', '1a000002712', '1a000002713', '1a000002714', '1a000002715', '1a000002716', '1a000002717', '1a000002718', '1a000002719', '1a000002720', '1a000002721', '1a000002722', '1a000002723', '1a000002724', '1a000002725', '1a000002726', '1a000002727', '1a000002728', '1a000002729', '1a000002730', '1a000002731', '1a000002732', '1a000002733', '1a000002734', '1a000002735', '1a000002736', '1a000002737', '1a000002738', '1a000002739', '1a000002740', '1a000002741', '1a000002742', '1a000002743', '1a000002744', '1a000002745', '1a000002746', '1a000002747', '1a000002748', '1a000002749', '1a000002750', '1a000002751', '1a000002752', '1a000002753', '1a000002754', '1a000002755', '1a000002756', '1a000002757', '1a000002758', '1a000002759', '1a000002760', '1a000002761', '1a000002762', '1a000002763', '1a000002764', '1a000002765', '1a000002766', '1a000002767', '1a000002768', '1a000002769', '1a000002770', '1a000002771', '1a000002772', '1a000002773', '1a000002774', '1a000002775', '1a000002776', '1a000002777', '1a000002778', '1a000002779', '1a000002780', '1a000002781', '1a000002782', '1a000002783', '1a000002784', '1a000002785', '1a000002786', '1a000002787', '1a000002788', '1a000002789', '1a000002790', '1a000002791', '1a000002792', '1a000002793', '1a000002794', '1a000002795', '1a000002796', '1a000002797', '1a000002798', '1a000002799', '1a000002800', '1a000002801', '1a000002802', '1a000002803', '1a000002804', '1a000002805', '1a000002806', '1a000002807', '1a000002808', '1a000002809', '1a000002810', '1a000002811', '1a000002812', '1a000002813', '1a000002814', '1a000002815', '1a000002816', '1a000002817', '1a000002818', '1a000002819', '1a000002820', '1a000002821', '1a000002822', '1a000002823', '1a000002824', '1a000002825', '1a000002826', '1a000002827', '1a000002828', '1a000002829', '1a000002830', '1a000002831', '1a000002832', '1a000002833', '1a000002834', '1a000002835', '1a000002836', '1a000002837', '1a000002838', '1a000002839', '1a000002840', '1a000002841', '1a000002842', '1a000002843', '1a000002844', '1a000002845', '1a000002846', '1a000002847', '1a000002848', '1a000002849', '1a000002850', '1a000002851', '1a000002852', '1a000002853', '1a000002854', '1a000002855', '1a000002856', '1a000002857', '1a000002858', '1a000002859', '1a000002860', '1a000002861', '1a000002862', '1a000002863', '1a000002864', '1a000002865', '1a000002866', '1a000002867', '1a000002868', '1a000002869', '1a000002870', '1a000002871', '1a000002872', '1a000002873', '1a000002874', '1a000002875', '1a000002876', '1a000002877', '1a000002878', '1a000002879', '1a000002880', '1a000002881', '1a000002882', '1a000002883', '1a000002884', '1a000002885', '1a000002886', '1a000002887', '1a000002888', '1a000002889', '1a000002890', '1a000002891', '1a000002892', '1a000002893', '1a000002894', '1a000002895', '1a000002896', '1a000002897', '1a000002898', '1a000002899', '1a000002900', '1a000002901', '1a000002902', '1a000002903', '1a000002904', '1a000002905', '1a000002906', '1a000002907', '1a000002908', '1a000002909', '1a000002910', '1a000002911', '1a000002912', '1a000002913', '1a000002914', '1a000002915', '1a000002916', '1a000002917', '1a000002918', '1a000002919', '1a000002920', '1a000002921', '1a000002922', '1a000002923', '1a000002924', '1a000002925', '1a000002926', '1a000002927', '1a000002928', '1a000002929', '1a000002930', '1a000002931', '1a000002932', '1a000002933', '1a000002934', '1a000002935', '1a000002936', '1a000002937', '1a000002938', '1a000002939', '1a000002940', '1a000002941', '1a000002942', '1a000002943', '1a000002944', '1a000002945', '1a000002946', '1a000002947', '1a000002948', '1a000002949', '1a000002950', '1a000002951', '1a000002952', '1a000002953', '1a000002954', '1a000002955', '1a000002956', '1a000002957', '1a000002958', '1a000002959', '1a000002960', '1a000002961', '1a000002962', '1a000002963', '1a000002964', '1a000002965', '1a000002966', '1a000002967', '1a000002968', '1a000002969', '1a000002970', '1a000002971', '1a000002972', '1a000002973', '1a000002974', '1a000002975', '1a000002976', '1a000002977', '1a000002978', '1a000002979', '1a000002980', '1a000002981', '1a000002982', '1a000002983', '1a000002984', '1a000002985', '1a000002986', '1a000002987', '1a000002988', '1a000002989', '1a000002990', '1a000002991', '1a000002992', '1a000002993', '1a000002994', '1a000002995', '1a000002996', '1a000002997', '1a000002998', '1a000002999', '1a000003000', '1a000003001', '1a000003002', '1a000003003', '1a000003004', '1a000003005', '1a000003006', '1a000003007', '1a000003008', '1a000003009', '1a000003010', '1a000003011', '1a000003012', '1a000003013', '1a000003014', '1a000003015', '1a000003016', '1a000003017', '1a000003018', '1a000003019', '1a000003020', '1a000003021', '1a000003022', '1a000003023', '1a000003024', '1a000003025', '1a000003026', '1a000003027', '1a000003028', '1a000003029', '1a000003030', '1a000003031', '1a000003032', '1a000003033', '1a000003034', '1a000003035', '1a000003036', '1a000003037', '1a000003038', '1a000003039', '1a000003040', '1a000003041', '1a000003042', '1a000003043', '1a000003044', '1a000003045', '1a000003046', '1a000003047', '1a000003048', '1a000003049', '1a000003050', '1a000003051', '1a000003052', '1a000003053', '1a000003054', '1a000003055', '1a000003056', '1a000003057', '1a000003058', '1a000003059', '1a000003060', '1a000003061', '1a000003062', '1a000003063', '1a000003064', '1a000003065', '1a000003066', '1a000003067', '1a000003068', '1a000003069', '1a000003070', '1a000003071', '1a000003072', '1a000003073', '1a000003074', '1a000003075', '1a000003076', '1a000003077', '1a000003078', '1a000003079', '1a000003080', '1a000003081', '1a000003082', '1a000003083', '1a000003084', '1a000003085', '1a000003086', '1a000003087', '1a000003088', '1a000003089', '1a000003090', '1a000003091', '1a000003092', '1a000003093', '1a000003094', '1a000003095', '1a000003096', '1a000003097', '1a000003098', '1a000003099', '1a000003100', '1a000003101', '1a000003102', '1a000003103', '1a000003104', '1a000003105', '1a000003106', '1a000003107', '1a000003108', '1a000003109', '1a000003110', '1a000003111', '1a000003112', '1a000003113', '1a000003114', '1a000003115', '1a000003116', '1a000003117', '1a000003118', '1a000003119', '1a000003120', '1a000003121', '1a000003122', '1a000003123', '1a000003124', '1a000003125', '1a000003126', '1a000003127', '1a000003128', '1a000003129', '1a000003130', '1a000003131', '1a000003132', '1a000003133', '1a000003134', '1a000003135', '1a000003136', '1a000003137', '1a000003138', '1a000003139', '1a000003140', '1a000003141', '1a000003142', '1a000003143', '1a000003144', '1a000003145', '1a000003146', '1a000003147', '1a000003148', '1a000003149', '1a000003150', '1a000003151', '1a000003152', '1a000003153', '1a000003154', '1a000003155', '1a000003156', '1a000003157', '1a000003158', '1a000003159', '1a000003160', '1a000003161', '1a000003162', '1a000003163', '1a000003164', '1a000003165', '1a000003166', '1a000003167', '1a000003168', '1a000003169', '1a000003170', '1a000003171', '1a000003172', '1a000003173', '1a000003174', '1a000003175', '1a000003176', '1a000003177', '1a000003178', '1a000003179', '1a000003180', '1a000003181', '1a000003182', '1a000003183', '1a000003184', '1a000003185', '1a000003186', '1a000003187', '1a000003188', '1a000003189', '1a000003190', '1a000003191', '1a000003192', '1a000003193', '1a000003194', '1a000003195', '1a000003196', '1a000003197', '1a000003198', '1a000003199', '1a000003200', '1a000003201', '1a000003202', '1a000003203', '1a000003204', '1a000003205', '1a000003206', '1a000003207', '1a000003208', '1a000003209', '1a000003210', '1a000003211', '1a000003212', '1a000003213', '1a000003214', '1a000003215', '1a000003216', '1a000003217', '1a000003218', '1a000003219', '1a000003220', '1a000003221', '1a000003222', '1a000003223', '1a000003224', '1a000003225', '1a000003226', '1a000003227', '1a000003228', '1a000003229', '1a000003230', '1a000003231', '1a000003232', '1a000003233', '1a000003234', '1a000003235', '1a000003236', '1a000003237', '1a000003238', '1a000003239', '1a000003240', '1a000003241', '1a000003242', '1a000003243', '1a000003244', '1a000003245', '1a000003246', '1a000003247', '1a000003248', '1a000003249', '1a000003250', '1a000003251', '1a000003252', '1a000003253', '1a000003254', '1a000003255', '1a000003256', '1a000003257', '1a000003258', '1a000003259', '1a000003260', '1a000003261', '1a000003262', '1a000003263', '1a000003264', '1a000003265', '1a000003266', '1a000003267', '1a000003268', '1a000003269', '1a000003270', '1a000003271', '1a000003272', '1a000003273', '1a000003274', '1a000003275', '1a000003276', '1a000003277', '1a000003278', '1a000003279', '1a000003280', '1a000003281', '1a000003282', '1a000003283', '1a000003284', '1a000003285', '1a000003286', '1a000003287', '1a000003288', '1a000003289', '1a000003290', '1a000003291', '1a000003292', '1a000003293', '1a000003294', '1a000003295', '1a000003296', '1a000003297', '1a000003298', '1a000003299', '1a000003300', '1a000003301', '1a000003302', '1a000003303', '1a000003304', '1a000003305', '1a000003306', '1a000003307', '1a000003308', '1a000003309', '1a000003310', '1a000003311', '1a000003312', '1a000003313', '1a000003314', '1a000003315', '1a000003316', '1a000003317', '1a000003318', '1a000003319', '1a000003320', '1a000003321', '1a000003322', '1a000003323', '1a000003324', '1a000003325', '1a000003326', '1a000003327', '1a000003328', '1a000003329', '1a000003330', '1a000003331', '1a000003332', '1a000003333', '1a000003334', '1a000003335', '1a000003336', '1a000003337', '1a000003338', '1a000003339', '1a000003340', '1a000003341', '1a000003342', '1a000003343', '1a000003344', '1a000003345', '1a000003346', '1a000003347', '1a000003348', '1a000003349', '1a000003350', '1a000003351', '1a000003352', '1a000003353', '1a000003354', '1a000003355', '1a000003356', '1a000003357', '1a000003358', '1a000003359', '1a000003360', '1a000003361', '1a000003362', '1a000003363', '1a000003364', '1a000003365', '1a000003366', '1a000003367', '1a000003368', '1a000003369', '1a000003370', '1a000003371', '1a000003372', '1a000003373', '1a000003374', '1a000003375', '1a000003376', '1a000003377', '1a000003378', '1a000003379', '1a000003380', '1a000003381', '1a000003382', '1a000003383', '1a000003384', '1a000003385', '1a000003386', '1a000003387', '1a000003388', '1a000003389', '1a000003390', '1a000003391', '1a000003392', '1a000003393', '1a000003394', '1a000003395', '1a000003396', '1a000003397', '1a000003398', '1a000003399', '1a000003400', '1a000003401', '1a000003402', '1a000003403', '1a000003404', '1a000003405', '1a000003406', '1a000003407', '1a000003408', '1a000003409', '1a000003410', '1a000003411', '1a000003412', '1a000003413', '1a000003414', '1a000003415', '1a000003416', '1a000003417', '1a000003418', '1a000003419', '1a000003420', '1a000003421', '1a000003422', '1a000003423', '1a000003424', '1a000003425', '1a000003426', '1a000003427', '1a000003428', '1a000003429', '1a000003430', '1a000003431', '1a000003432', '1a000003433', '1a000003434', '1a000003435', '1a000003436', '1a000003437', '1a000003438', '1a000003439', '1a000003440', '1a000003441', '1a000003442', '1a000003443', '1a000003444', '1a000003445', '1a000003446', '1a000003447', '1a000003448', '1a000003449', '1a000003450', '1a000003451', '1a000003452', '1a000003453', '1a000003454', '1a000003455', '1a000003456', '1a000003457', '1a000003458', '1a000003459', '1a000003460', '1a000003461', '1a000003462', '1a000003463', '1a000003464', '1a000003465', '1a000003466', '1a000003467', '1a000003468', '1a000003469', '1a000003470', '1a000003471', '1a000003472', '1a000003473', '1a000003474', '1a000003475', '1a000003476', '1a000003477', '1a000003478', '1a000003479', '1a000003480', '1a000003481', '1a000003482', '1a000003483', '1a000003484', '1a000003485', '1a000003486', '1a000003487', '1a000003488', '1a000003489', '1a000003490', '1a000003491', '1a000003492', '1a000003493', '1a000003494', '1a000003495', '1a000003496', '1a000003497', '1a000003498', '1a000003499', '1a000003500', '1a000003501', '1a000003502', '1a000003503', '1a000003504', '1a000003505', '1a000003506', '1a000003507', '1a000003508', '1a000003509', '1a000003510', '1a000003511', '1a000003512', '1a000003513', '1a000003514', '1a000003515', '1a000003516', '1a000003517', '1a000003518', '1a000003519', '1a000003520', '1a000003521', '1a000003522', '1a000003523', '1a000003524', '1a000003525', '1a000003526', '1a000003527', '1a000003528', '1a000003529', '1a000003530', '1a000003531', '1a000003532', '1a000003533', '1a000003534', '1a000003535', '1a000003536', '1a000003537', '1a000003538', '1a000003539', '1a000003540', '1a000003541', '1a000003542', '1a000003543', '1a000003544', '1a000003545', '1a000003546', '1a000003547', '1a000003548', '1a000003549', '1a000003550', '1a000003551', '1a000003552', '1a000003553', '1a000003554', '1a000003555', '1a000003556', '1a000003557', '1a000003558', '1a000003559', '1a000003560', '1a000003561', '1a000003562', '1a000003563', '1a000003564', '1a000003565', '1a000003566', '1a000003567', '1a000003568', '1a000003569', '1a000003570', '1a000003571', '1a000003572', '1a000003573', '1a000003574', '1a000003575', '1a000003576', '1a000003577', '1a000003578', '1a000003579', '1a000003580', '1a000003581', '1a000003582', '1a000003583', '1a000003584', '1a000003585', '1a000003586', '1a000003587', '1a000003588', '1a000003589', '1a000003590', '1a000003591', '1a000003592', '1a000003593', '1a000003594', '1a000003595', '1a000003596', '1a000003597', '1a000003598', '1a000003599', '1a000003600', '1a000003601', '1a000003602', '1a000003603', '1a000003604', '1a000003605', '1a000003606', '1a000003607', '1a000003608', '1a000003609', '1a000003610', '1a000003611', '1a000003612', '1a000003613', '1a000003614', '1a000003615', '1a000003616', '1a000003617', '1a000003618', '1a000003619', '1a000003620', '1a000003621', '1a000003622', '1a000003623', '1a000003624', '1a000003625', '1a000003626', '1a000003627', '1a000003628', '1a000003629', '1a000003630', '1a000003631', '1a000003632', '1a000003633', '1a000003634', '1a000003635', '1a000003636', '1a000003637', '1a000003638', '1a000003639', '1a000003640', '1a000003641', '1a000003642', '1a000003643', '1a000003644', '1a000003645', '1a000003646', '1a000003647', '1a000003648', '1a000003649', '1a000003650', '1a000003651', '1a000003652', '1a000003653', '1a000003654', '1a000003655', '1a000003656', '1a000003657', '1a000003658', '1a000003659', '1a000003660', '1a000003661', '1a000003662', '1a000003663', '1a000003664', '1a000003665', '1a000003666', '1a000003667', '1a000003668', '1a000003669', '1a000003670', '1a000003671', '1a000003672', '1a000003673', '1a000003674', '1a000003675', '1a000003676', '1a000003677', '1a000003678', '1a000003679', '1a000003680', '1a000003681', '1a000003682', '1a000003683', '1a000003684', '1a000003685', '1a000003686', '1a000003687', '1a000003688', '1a000003689', '1a000003690', '1a000003691', '1a000003692', '1a000003693', '1a000003694', '1a000003695', '1a000003696', '1a000003697', '1a000003698', '1a000003699', '1a000003700', '1a000003701', '1a000003702', '1a000003703', '1a000003704', '1a000003705', '1a000003706', '1a000003707', '1a000003708', '1a000003709', '1a000003710', '1a000003711', '1a000003712', '1a000003713', '1a000003714', '1a000003715', '1a000003716', '1a000003717', '1a000003718', '1a000003719', '1a000003720', '1a000003721', '1a000003722', '1a000003723', '1a000003724', '1a000003725', '1a000003726', '1a000003727', '1a000003728', '1a000003729', '1a000003730', '1a000003731', '1a000003732', '1a000003733', '1a000003734', '1a000003735', '1a000003736', '1a000003737', '1a000003738', '1a000003739', '1a000003740', '1a000003741', '1a000003742', '1a000003743', '1a000003744', '1a000003745', '1a000003746', '1a000003747', '1a000003748', '1a000003749', '1a000003750', '1a000003751', '1a000003752', '1a000003753', '1a000003754', '1a000003755', '1a000003756', '1a000003757', '1a000003758', '1a000003759', '1a000003760', '1a000003761', '1a000003762', '1a000003763', '1a000003764', '1a000003765', '1a000003766', '1a000003767', '1a000003768', '1a000003769', '1a000003770', '1a000003771', '1a000003772', '1a000003773', '1a000003774', '1a000003775', '1a000003776', '1a000003777', '1a000003778', '1a000003779', '1a000003780', '1a000003781', '1a000003782', '1a000003783', '1a000003784', '1a000003785', '1a000003786', '1a000003787', '1a000003788', '1a000003789', '1a000003790', '1a000003791', '1a000003792', '1a000003793', '1a000003794', '1a000003795', '1a000003796', '1a000003797', '1a000003798', '1a000003799', '1a000003800', '1a000003801', '1a000003802', '1a000003803', '1a000003804', '1a000003805', '1a000003806', '1a000003807', '1a000003808', '1a000003809', '1a000003810', '1a000003811', '1a000003812', '1a000003813', '1a000003814', '1a000003815', '1a000003816', '1a000003817', '1a000003818', '1a000003819', '1a000003820', '1a000003821', '1a000003822', '1a000003823', '1a000003824', '1a000003825', '1a000003826', '1a000003827', '1a000003828', '1a000003829', '1a000003830', '1a000003831', '1a000003832', '1a000003833', '1a000003834', '1a000003835', '1a000003836', '1a000003837', '1a000003838', '1a000003839', '1a000003840', '1a000003841', '1a000003842', '1a000003843', '1a000003844', '1a000003845', '1a000003846', '1a000003847', '1a000003848', '1a000003849', '1a000003850', '1a000003851', '1a000003852', '1a000003853', '1a000003854', '1a000003855', '1a000003856', '1a000003857', '1a000003858', '1a000003859', '1a000003860', '1a000003861', '1a000003862', '1a000003863', '1a000003864', '1a000003865', '1a000003866', '1a000003867', '1a000003868', '1a000003869', '1a000003870', '1a000003871', '1a000003872', '1a000003873', '1a000003874', '1a000003875', '1a000003876', '1a000003877', '1a000003878', '1a000003879', '1a000003880', '1a000003881', '1a000003882', '1a000003883', '1a000003884', '1a000003885', '1a000003886', '1a000003887', '1a000003888', '1a000003889', '1a000003890', '1a000003891', '1a000003892', '1a000003893', '1a000003894', '1a000003895', '1a000003896', '1a000003897', '1a000003898', '1a000003899', '1a000003900', '1a000003901', '1a000003902', '1a000003903', '1a000003904', '1a000003905', '1a000003906', '1a000003907', '1a000003908', '1a000003909', '1a000003910', '1a000003911', '1a000003912', '1a000003913', '1a000003914', '1a000003915', '1a000003916', '1a000003917', '1a000003918', '1a000003919', '1a000003920', '1a000003921', '1a000003922', '1a000003923', '1a000003924', '1a000003925', '1a000003926', '1a000003927', '1a000003928', '1a000003929', '1a000003930', '1a000003931', '1a000003932', '1a000003933', '1a000003934', '1a000003935', '1a000003936', '1a000003937', '1a000003938', '1a000003939', '1a000003940', '1a000003941', '1a000003942', '1a000003943', '1a000003944', '1a000003945', '1a000003946', '1a000003947', '1a000003948', '1a000003949', '1a000003950', '1a000003951', '1a000003952', '1a000003953', '1a000003954', '1a000003955', '1a000003956', '1a000003957', '1a000003958', '1a000003959', '1a000003960', '1a000003961', '1a000003962', '1a000003963', '1a000003964', '1a000003965', '1a000003966', '1a000003967', '1a000003968', '1a000003969', '1a000003970', '1a000003971', '1a000003972', '1a000003973', '1a000003974', '1a000003975', '1a000003976', '1a000003977', '1a000003978', '1a000003979', '1a000003980', '1a000003981', '1a000003982', '1a000003983', '1a000003984', '1a000003985', '1a000003986', '1a000003987', '1a000003988', '1a000003989', '1a000003990', '1a000003991', '1a000003992', '1a000003993', '1a000003994', '1a000003995', '1a000003996', '1a000003997', '1a000003998', '1a000003999', '1a000004000', '1a000004001', '1a000004002', '1a000004003', '1a000004004', '1a000004005', '1a000004006', '1a000004007', '1a000004008', '1a000004009', '1a000004010', '1a000004011', '1a000004012', '1a000004013', '1a000004014', '1a000004015', '1a000004016', '1a000004017', '1a000004018', '1a000004019', '1a000004020', '1a000004021', '1a000004022', '1a000004023', '1a000004024', '1a000004025', '1a000004026', '1a000004027', '1a000004028', '1a000004029', '1a000004030', '1a000004031', '1a000004032', '1a000004033', '1a000004034', '1a000004035', '1a000004036', '1a000004037', '1a000004038', '1a000004039', '1a000004040', '1a000004041', '1a000004042', '1a000004043', '1a000004044', '1a000004045', '1a000004046', '1a000004047', '1a000004048', '1a000004049', '1a000004050', '1a000004051', '1a000004052', '1a000004053', '1a000004054', '1a000004055', '1a000004056', '1a000004057', '1a000004058', '1a000004059', '1a000004060', '1a000004061', '1a000004062', '1a000004063', '1a000004064', '1a000004065', '1a000004066', '1a000004067', '1a000004068', '1a000004069', '1a000004070', '1a000004071', '1a000004072', '1a000004073', '1a000004074', '1a000004075', '1a000004076', '1a000004077', '1a000004078', '1a000004079', '1a000004080', '1a000004081', '1a000004082', '1a000004083', '1a000004084', '1a000004085', '1a000004086', '1a000004087', '1a000004088', '1a000004089', '1a000004090', '1a000004091', '1a000004092', '1a000004093', '1a000004094', '1a000004095', '1a000004096', '1a000004097', '1a000004098', '1a000004099', '1a000004100', '1a000004101', '1a000004102', '1a000004103', '1a000004104', '1a000004105', '1a000004106', '1a000004107', '1a000004108', '1a000004109', '1a000004110', '1a000004111', '1a000004112', '1a000004113', '1a000004114', '1a000004115', '1a000004116', '1a000004117', '1a000004118', '1a000004119', '1a000004120', '1a000004121', '1a000004122', '1a000004123', '1a000004124', '1a000004125', '1a000004126', '1a000004127', '1a000004128', '1a000004129', '1a000004130', '1a000004131', '1a000004132', '1a000004133', '1a000004134', '1a000004135', '1a000004136', '1a000004137', '1a000004138', '1a000004139', '1a000004140', '1a000004141', '1a000004142', '1a000004143', '1a000004144', '1a000004145', '1a000004146', '1a000004147', '1a000004148', '1a000004149', '1a000004150', '1a000004151', '1a000004152', '1a000004153', '1a000004154', '1a000004155', '1a000004156', '1a000004157', '1a000004158', '1a000004159', '1a000004160', '1a000004161', '1a000004162', '1a000004163', '1a000004164', '1a000004165', '1a000004166', '1a000004167', '1a000004168', '1a000004169', '1a000004170', '1a000004171', '1a000004172', '1a000004173', '1a000004174', '1a000004175', '1a000004176', '1a000004177', '1a000004178', '1a000004179', '1a000004180', '1a000004181', '1a000004182', '1a000004183', '1a000004184', '1a000004185', '1a000004186', '1a000004187', '1a000004188', '1a000004189', '1a000004190', '1a000004191', '1a000004192', '1a000004193', '1a000004194', '1a000004195', '1a000004196', '1a000004197', '1a000004198', '1a000004199', '1a000004200', '1a000004201', '1a000004202', '1a000004203', '1a000004204', '1a000004205', '1a000004206', '1a000004207', '1a000004208', '1a000004209', '1a000004210', '1a000004211', '1a000004212', '1a000004213', '1a000004214', '1a000004215', '1a000004216', '1a000004217', '1a000004218', '1a000004219', '1a000004220', '1a000004221', '1a000004222', '1a000004223', '1a000004224', '1a000004225', '1a000004226', '1a000004227', '1a000004228', '1a000004229', '1a000004230', '1a000004231', '1a000004232', '1a000004233', '1a000004234', '1a000004235', '1a000004236', '1a000004237', '1a000004238', '1a000004239', '1a000004240', '1a000004241', '1a000004242', '1a000004243', '1a000004244', '1a000004245', '1a000004246', '1a000004247', '1a000004248', '1a000004249', '1a000004250', '1a000004251', '1a000004252', '1a000004253', '1a000004254', '1a000004255', '1a000004256', '1a000004257', '1a000004258', '1a000004259', '1a000004260', '1a000004261', '1a000004262', '1a000004263', '1a000004264', '1a000004265', '1a000004266', '1a000004267', '1a000004268', '1a000004269', '1a000004270', '1a000004271', '1a000004272', '1a000004273', '1a000004274', '1a000004275', '1a000004276', '1a000004277', '1a000004278', '1a000004279', '1a000004280', '1a000004281', '1a000004282', '1a000004283', '1a000004284', '1a000004285', '1a000004286', '1a000004287', '1a000004288', '1a000004289', '1a000004290', '1a000004291', '1a000004292', '1a000004293', '1a000004294', '1a000004295', '1a000004296', '1a000004297', '1a000004298', '1a000004299', '1a000004300', '1a000004301', '1a000004302', '1a000004303', '1a000004304', '1a000004305', '1a000004306', '1a000004307', '1a000004308', '1a000004309', '1a000004310', '1a000004311', '1a000004312', '1a000004313', '1a000004314', '1a000004315', '1a000004316', '1a000004317', '1a000004318', '1a000004319', '1a000004320', '1a000004321', '1a000004322', '1a000004323', '1a000004324', '1a000004325', '1a000004326', '1a000004327', '1a000004328', '1a000004329', '1a000004330', '1a000004331', '1a000004332', '1a000004333', '1a000004334', '1a000004335', '1a000004336', '1a000004337', '1a000004338', '1a000004339', '1a000004340', '1a000004341', '1a000004342', '1a000004343', '1a000004344', '1a000004345', '1a000004346', '1a000004347', '1a000004348', '1a000004349', '1a000004350', '1a000004351', '1a000004352', '1a000004353', '1a000004354', '1a000004355', '1a000004356', '1a000004357', '1a000004358', '1a000004359', '1a000004360', '1a000004361', '1a000004362', '1a000004363', '1a000004364', '1a000004365', '1a000004366', '1a000004367', '1a000004368', '1a000004369', '1a000004370', '1a000004371', '1a000004372', '1a000004373', '1a000004374', '1a000004375', '1a000004376', '1a000004377', '1a000004378', '1a000004379', '1a000004380', '1a000004381', '1a000004382', '1a000004383', '1a000004384', '1a000004385', '1a000004386', '1a000004387', '1a000004388', '1a000004389', '1a000004390', '1a000004391', '1a000004392', '1a000004393', '1a000004394', '1a000004395', '1a000004396', '1a000004397', '1a000004398', '1a000004399', '1a000004400', '1a000004401', '1a000004402', '1a000004403', '1a000004404', '1a000004405', '1a000004406', '1a000004407', '1a000004408', '1a000004409', '1a000004410', '1a000004411', '1a000004412', '1a000004413', '1a000004414', '1a000004415', '1a000004416', '1a000004417', '1a000004418', '1a000004419', '1a000004420', '1a000004421', '1a000004422', '1a000004423', '1a000004424', '1a000004425', '1a000004426', '1a000004427', '1a000004428', '1a000004429', '1a000004430', '1a000004431', '1a000004432', '1a000004433', '1a000004434', '1a000004435', '1a000004436', '1a000004437', '1a000004438', '1a000004439', '1a000004440', '1a000004441', '1a000004442', '1a000004443', '1a000004444', '1a000004445', '1a000004446', '1a000004447', '1a000004448', '1a000004449', '1a000004450', '1a000004451', '1a000004452', '1a000004453', '1a000004454', '1a000004455', '1a000004456', '1a000004457', '1a000004458', '1a000004459', '1a000004460', '1a000004461', '1a000004462', '1a000004463', '1a000004464', '1a000004465', '1a000004466', '1a000004467', '1a000004468', '1a000004469', '1a000004470', '1a000004471', '1a000004472', '1a000004473', '1a000004474', '1a000004475', '1a000004476', '1a000004477', '1a000004478', '1a000004479', '1a000004480', '1a000004481', '1a000004482', '1a000004483', '1a000004484', '1a000004485', '1a000004486', '1a000004487', '1a000004488', '1a000004489', '1a000004490', '1a000004491', '1a000004492', '1a000004493', '1a000004494', '1a000004495', '1a000004496', '1a000004497', '1a000004498', '1a000004499', '1a000004500', '1a000004501', '1a000004502', '1a000004503', '1a000004504', '1a000004505', '1a000004506', '1a000004507', '1a000004508', '1a000004509', '1a000004510', '1a000004511', '1a000004512', '1a000004513', '1a000004514', '1a000004515', '1a000004516', '1a000004517', '1a000004518', '1a000004519', '1a000004520', '1a000004521', '1a000004522', '1a000004523', '1a000004524', '1a000004525', '1a000004526', '1a000004527', '1a000004528', '1a000004529', '1a000004530', '1a000004531', '1a000004532', '1a000004533', '1a000004534', '1a000004535', '1a000004536', '1a000004537', '1a000004538', '1a000004539', '1a000004540', '1a000004541', '1a000004542', '1a000004543', '1a000004544', '1a000004545', '1a000004546', '1a000004547', '1a000004548', '1a000004549', '1a000004550', '1a000004551', '1a000004552', '1a000004553', '1a000004554', '1a000004555', '1a000004556', '1a000004557', '1a000004558', '1a000004559', '1a000004560', '1a000004561', '1a000004562', '1a000004563', '1a000004564', '1a000004565', '1a000004566', '1a000004567', '1a000004568', '1a000004569', '1a000004570', '1a000004571', '1a000004572', '1a000004573', '1a000004574', '1a000004575', '1a000004576', '1a000004577', '1a000004578', '1a000004579', '1a000004580', '1a000004581', '1a000004582', '1a000004583', '1a000004584', '1a000004585', '1a000004586', '1a000004587', '1a000004588', '1a000004589', '1a000004590', '1a000004591', '1a000004592', '1a000004593', '1a000004594', '1a000004595', '1a000004596', '1a000004597', '1a000004598', '1a000004599', '1a000004600', '1a000004601', '1a000004602', '1a000004603', '1a000004604', '1a000004605', '1a000004606', '1a000004607', '1a000004608', '1a000004609', '1a000004610', '1a000004611', '1a000004612', '1a000004613', '1a000004614', '1a000004615', '1a000004616', '1a000004617', '1a000004618', '1a000004619', '1a000004620', '1a000004621', '1a000004622', '1a000004623', '1a000004624', '1a000004625', '1a000004626', '1a000004627', '1a000004628', '1a000004629', '1a000004630', '1a000004631', '1a000004632', '1a000004633', '1a000004634', '1a000004635', '1a000004636', '1a000004637', '1a000004638', '1a000004639', '1a000004640', '1a000004641', '1a000004642', '1a000004643', '1a000004644', '1a000004645', '1a000004646', '1a000004647', '1a000004648', '1a000004649', '1a000004650', '2a000000196', '2a000000061', '2a000000067', '2a000000062', '2a000000068', '2a000000063', '2a000000069', '2a000000064', '2a000000070', '2a000000065', '2a000000071', '2a000000066', '2a000000072', '2a000000079', '2a000000085', '2a000000080', '2a000000086', '2a000000081', '2a000000087', '2a000000082', '2a000000088', '2a000000083', '2a000000089', '2a000000084', '2a000000090', '2a000000099', '2a000000100', '2a000000101', '2a000000102', '2a000000104', '2a000000105', '2a000000106', '2a000000108', '2a000000117', '2a000000119', '2a000000120', '2a000000121', '2a000000123', '2a000000125', '2a000000127', '2a000000129', '2a000000131', '2a000000133', '2a000000135', '2a000000137', '2a000000139', '2a000000141', '2a000000143', '2a000000145', '2a000000147', '2a000000153', '2a000000155', '2a000000158', '2a000000159', '2a000000160', '2a000000162', '2a000000164', '2a000000166', '2a000000168', '2a000000170', '2a000000172', '2a000000174', '2a000000176', '2a000000177', '2a000000178', '2a000000179', '2a000000181', '2a000000183', '2a000000184', '2a000000185', '2a000000187', '2a000000188', '2a000000190', '2a000000191', '2a000000193', '2a000000197', '2a000000198', '2a000000200', '2a000000201', '2a000000203', '2a000000204', '2a000000206', '2a000000207', '2a000000209', '2a000000210', '2a000000212', '2a000000214', '2a000000216', '2a000000218', '2a000000220', '2a000000221', '2a000000223', '2a000000224', '2a000000226', '2a000000227', '2a000000229', '2a000000230', '2a000000232', '2a000000233', '2a000000234', '2a000000236', '2a000000237', '2a000000238', '2a000000240', '2a000000242', '2a000000248', '2a000000249', '2a000000250', '2a000000252', '2a000000254', '2a000000262', '2a000000264', '2a000000270', '2a000000272', '2a000000274', '2a000000279', '2a000000289', '2a000000291', '2a000000293', '2a000000295', '2a000000297', '2a000000299', '2a000000301', '2a000000303', '2a000000305', '2a000000307', '2a000000309', '2a000000317', '2a000000324', '2a000000325', '2a000000326', '2a000000328', '2a000000330', '2a000000361', '2a000000364', '2a000000379', '2a000000381', '2a000000383', '2a000000386', '2a000000413', '2a000000415', '2a000000417', '2a000000419', '2a000000421', '2a000000423', '2a000000425', '2a000000427', '2a000000429', '2a000000431', '2a000000433', '2a000000435', '2a000000437', '2a000000439', '2a000000441', '2a000000443', '2a000000445', '2a000000447', '2a000000449', '2a000000451', '2a000000452', '2a000000453', '2a000000455', '2a000000457', '2a000000458', '2a000000460', '2a000000462', '2a000000464', '2a000000466', '2a000000467', '2a000000471', '2a000000473', '2a000000475', '2a000000477', '2a000000479', '2a000000481', '2a000000483', '2a000000485', '2a000000487', '2a000000489', '2a000000492', '2a000000494', '2a000000510', '2a000000512', '2a000000513', '2a000000515', '2a000000516', '2a000000518', '2a000000519', '2a000000521', '2a000000522', '2a000000532', '2a000000533', '2a000000534', '4a000000377', '4a000000630', '4a000000883', '4a000000378', '4a000000631', '4a000000884', '4a000000379', '4a000000632', '4a000000885', '4a000000380', '4a000000633', '4a000000886', '4a000000381', '4a000000634', '4a000000887', '4a000000382', '4a000000635', '4a000000888', '4a000000383', '4a000000636', '4a000000889', '4a000000384', '4a000000637', '4a000000890', '4a000000385', '4a000000638', '4a000000891', '4a000000386', '4a000000639', '4a000000892', '4a000000387', '4a000000640', '4a000000893', '4a000000388', '4a000000641', '4a000000894', '4a000000389', '4a000000642', '4a000000895', '4a000000390', '4a000000643', '4a000000896', '4a000000391', '4a000000644', '4a000000897', '4a000000392', '4a000000645', '4a000000898', '4a000000393', '4a000000646', '4a000000899', '4a000000394', '4a000000647', '4a000000900', '4a000000395', '4a000000648', '4a000000901', '4a000000396', '4a000000649', '4a000000902', '4a000000397', '4a000000650', '4a000000903', '4a000000398', '4a000000651', '4a000000904', '4a000000399', '4a000000652', '4a000000905', '4a000000400', '4a000000653', '4a000000906', '4a000000401', '4a000000654', '4a000000907', '4a000000402', '4a000000655', '4a000000908', '4a000000403', '4a000000656', '4a000000909', '4a000000404', '4a000000657', '4a000000910', '4a000000405', '4a000000658', '4a000000911', '4a000000406', '4a000000659', '4a000000912', '4a000000407', '4a000000660', '4a000000913', '4a000000408', '4a000000661', '4a000000914', '4a000000409', '4a000000662', '4a000000915', '4a000000410', '4a000000663', '4a000000916', '4a000000411', '4a000000664', '4a000000917', '4a000001136', '4a000001145', '4a000001154', '4a000001163', '4a000001172', '4a000001173', '4a000001174', '4a000001175', '4a000001176', '4a000001177', '4a000001178', '4a000001179', '4a000001180', '4a000001181', '4a000000412', '4a000000413', '4a000000414', '4a000000415', '4a000000416', '4a000000417', '4a000000418', '4a000000419', '4a000000420', '4a000000421', '4a000000422', '4a000000423', '4a000000424', '4a000000425', '4a000000426', '4a000000427', '4a000000428', '4a000000429', '4a000000430', '4a000000431', '4a000000432', '4a000000433', '4a000000434', '4a000000435', '4a000000436', '4a000000437', '4a000000438', '4a000000439', '4a000000440', '4a000000441', '4a000000442', '4a000000443', '4a000000444', '4a000000445', '4a000000446', '4a000000447', '4a000000448', '4a000000449', '4a000000450', '4a000000451', '4a000000452', '4a000000453', '4a000000454', '4a000000455', '4a000000456', '4a000000457', '4a000000458', '4a000000459', '4a000000460', '4a000000461', '4a000000462', '4a000000463', '4a000000464', '4a000000465', '4a000000665', '4a000000666', '4a000000667', '4a000000668', '4a000000669', '4a000000670', '4a000000671', '4a000000672', '4a000000673', '4a000000674', '4a000000675', '4a000000676', '4a000000677', '4a000000678', '4a000000679', '4a000000680', '4a000000681', '4a000000682', '4a000000683', '4a000000684', '4a000000685', '4a000000686', '4a000000687', '4a000000688', '4a000000689', '4a000000690', '4a000000691', '4a000000692', '4a000000693', '4a000000694', '4a000000695', '4a000000696', '4a000000697', '4a000000698', '4a000000699', '4a000000700', '4a000000701', '4a000000702', '4a000000703', '4a000000704', '4a000000705', '4a000000706', '4a000000707', '4a000000708', '4a000000709', '4a000000710', '4a000000711', '4a000000712', '4a000000713', '4a000000714', '4a000000715', '4a000000716', '4a000000717', '4a000000718', '4a000000918', '4a000000919', '4a000000920', '4a000000921', '4a000000922', '4a000000923', '4a000000924', '4a000000925', '4a000000926', '4a000000927', '4a000000928', '4a000000929', '4a000000930', '4a000000931', '4a000000932', '4a000000933', '4a000000934', '4a000000935', '4a000000936', '4a000000937', '4a000000938', '4a000000939', '4a000000940', '4a000000941', '4a000000942', '4a000000943', '4a000000944', '4a000000945', '4a000000946', '4a000000947', '4a000000948', '4a000000949', '4a000000950', '4a000000951', '4a000000952', '4a000000953', '4a000000954', '4a000000955', '4a000000956', '4a000000957', '4a000000958', '4a000000959', '4a000000960', '4a000000961', '4a000000962', '4a000000963', '4a000000964', '4a000000965', '4a000000966', '4a000000967', '4a000000968', '4a000000969', '4a000000970', '4a000000971', '4a000001137', '4a000001146', '4a000001155', '4a000001164', '4a000000466', '4a000000719', '4a000000972', '4a000001138', '4a000001147', '4a000001156', '4a000001165', '4a000000467', '4a000000720', '4a000000973', '4a000000468', '4a000000721', '4a000000974', '4a000000469', '4a000000722', '4a000000975', '4a000000470', '4a000000723', '4a000000976', '4a000000471', '4a000000724', '4a000000977', '4a000000472', '4a000000725', '4a000000978', '4a000000473', '4a000000726', '4a000000979', '4a000000474', '4a000000727', '4a000000980', '4a000000475', '4a000000728', '4a000000981', '4a000000476', '4a000000729', '4a000000982', '4a000000477', '4a000000730', '4a000000983', '4a000000478', '4a000000731', '4a000000984', '4a000000479', '4a000000732', '4a000000985', '4a000000480', '4a000000733', '4a000000986', '4a000000485', '4a000000738', '4a000000991', '4a000001139', '4a000001148', '4a000001157', '4a000001166', '4a000000513', '4a000000766', '4a000001019', '4a000001140', '4a000001149', '4a000001158', '4a000001167', '4a000000562', '4a000000815', '4a000001068', '4a000001141', '4a000001150', '4a000001159', '4a000001168', '4a000000563', '4a000000816', '4a000001069', '4a000001142', '4a000001151', '4a000001160', '4a000001169', '4a000000564', '4a000000817', '4a000001070', '4a000001143', '4a000001152', '4a000001161', '4a000001170', '4a000000565', '4a000000818', '4a000001071', '4a000001144', '4a000001153', '4a000001162', '4a000001171', '4a000000628', '4a000000881', '4a000001134', '4a000000376', '4a000000629', '4a000000882', '4a000001135', '4a000000481', '4a000000482', '4a000000483', '4a000000484', '4a000000486', '4a000000487', '4a000000488', '4a000000489', '4a000000490', '4a000000491', '4a000000492', '4a000000493', '4a000000494', '4a000000495', '4a000000496', '4a000000497', '4a000000498', '4a000000499', '4a000000500', '4a000000501', '4a000000502', '4a000000503', '4a000000504', '4a000000505', '4a000000506', '4a000000507', '4a000000508', '4a000000509', '4a000000510', '4a000000511', '4a000000512', '4a000000514', '4a000000515', '4a000000516', '4a000000517', '4a000000518', '4a000000519', '4a000000520', '4a000000521', '4a000000522', '4a000000523', '4a000000524', '4a000000525', '4a000000526', '4a000000527', '4a000000528', '4a000000529', '4a000000530', '4a000000531', '4a000000532', '4a000000533', '4a000000534', '4a000000535', '4a000000536', '4a000000537', '4a000000538', '4a000000539', '4a000000540', '4a000000541', '4a000000542', '4a000000543', '4a000000544', '4a000000545', '4a000000546', '4a000000547', '4a000000548', '4a000000549', '4a000000550', '4a000000551', '4a000000552', '4a000000553', '4a000000554', '4a000000555', '4a000000556', '4a000000557', '4a000000558', '4a000000559', '4a000000560', '4a000000561', '4a000000566', '4a000000567', '4a000000568', '4a000000569', '4a000000570', '4a000000571', '4a000000572', '4a000000573', '4a000000574', '4a000000575', '4a000000576', '4a000000577', '4a000000578', '4a000000579', '4a000000580', '4a000000581', '4a000000582', '4a000000583', '4a000000584', '4a000000585', '4a000000586', '4a000000587', '4a000000588', '4a000000589', '4a000000590', '4a000000591', '4a000000592', '4a000000593', '4a000000594', '4a000000595', '4a000000596', '4a000000597', '4a000000598', '4a000000599', '4a000000600', '4a000000601', '4a000000602', '4a000000603', '4a000000604', '4a000000605', '4a000000606', '4a000000607', '4a000000608', '4a000000609', '4a000000610', '4a000000611', '4a000000612', '4a000000613', '4a000000614', '4a000000615', '4a000000616', '4a000000617', '4a000000618', '4a000000619', '4a000000620', '4a000000621', '4a000000622', '4a000000623', '4a000000624', '4a000000625', '4a000000626', '4a000000627', '4a000000734', '4a000000735', '4a000000736', '4a000000737', '4a000000739', '4a000000740', '4a000000741', '4a000000742', '4a000000743', '4a000000744', '4a000000745', '4a000000746', '4a000000747', '4a000000748', '4a000000749', '4a000000750', '4a000000751', '4a000000752', '4a000000753', '4a000000754', '4a000000755', '4a000000756', '4a000000757', '4a000000758', '4a000000759', '4a000000760', '4a000000761', '4a000000762', '4a000000763', '4a000000764', '4a000000765', '4a000000767', '4a000000768', '4a000000769', '4a000000770', '4a000000771', '4a000000772', '4a000000773', '4a000000774', '4a000000775', '4a000000776', '4a000000777', '4a000000778', '4a000000779', '4a000000780', '4a000000781', '4a000000782', '4a000000783', '4a000000784', '4a000000785', '4a000000786', '4a000000787', '4a000000788', '4a000000789', '4a000000790', '4a000000791', '4a000000792', '4a000000793', '4a000000794', '4a000000795', '4a000000796', '4a000000797', '4a000000798', '4a000000799', '4a000000800', '4a000000801', '4a000000802', '4a000000803', '4a000000804', '4a000000805', '4a000000806', '4a000000807', '4a000000808', '4a000000809', '4a000000810', '4a000000811', '4a000000812', '4a000000813', '4a000000814', '4a000000819', '4a000000820', '4a000000821', '4a000000822', '4a000000823', '4a000000824', '4a000000825', '4a000000826', '4a000000827', '4a000000828', '4a000000829', '4a000000830', '4a000000831', '4a000000832', '4a000000833', '4a000000834', '4a000000835', '4a000000836', '4a000000837', '4a000000838', '4a000000839', '4a000000840', '4a000000841', '4a000000842', '4a000000843', '4a000000844', '4a000000845', '4a000000846', '4a000000847', '4a000000848', '4a000000849', '4a000000850', '4a000000851', '4a000000852', '4a000000853', '4a000000854', '4a000000855', '4a000000856', '4a000000857', '4a000000858', '4a000000859', '4a000000860', '4a000000861', '4a000000862', '4a000000863', '4a000000864', '4a000000865', '4a000000866', '4a000000867', '4a000000868', '4a000000869', '4a000000870', '4a000000871', '4a000000872', '4a000000873', '4a000000874', '4a000000875', '4a000000876', '4a000000877', '4a000000878', '4a000000879', '4a000000880', '4a000000987', '4a000000988', '4a000000989', '4a000000990', '4a000000992', '4a000000993', '4a000000994', '4a000000995', '4a000000996', '4a000000997', '4a000000998', '4a000000999', '4a000001000', '4a000001001', '4a000001002', '4a000001003', '4a000001004', '4a000001005', '4a000001006', '4a000001007', '4a000001008', '4a000001009', '4a000001010', '4a000001011', '4a000001012', '4a000001013', '4a000001014', '4a000001015', '4a000001016', '4a000001017', '4a000001018', '4a000001020', '4a000001021', '4a000001022', '4a000001023', '4a000001024', '4a000001025', '4a000001026', '4a000001027', '4a000001028', '4a000001029', '4a000001030', '4a000001031', '4a000001032', '4a000001033', '4a000001034', '4a000001035', '4a000001036', '4a000001037', '4a000001038', '4a000001039', '4a000001040', '4a000001041', '4a000001042', '4a000001043', '4a000001044', '4a000001045', '4a000001046', '4a000001047', '4a000001048', '4a000001049', '4a000001050', '4a000001051', '4a000001052', '4a000001053', '4a000001054', '4a000001055', '4a000001056', '4a000001057', '4a000001058', '4a000001059', '4a000001060', '4a000001061', '4a000001062', '4a000001063', '4a000001064', '4a000001065', '4a000001066', '4a000001067', '4a000001072', '4a000001073', '4a000001074', '4a000001075', '4a000001076', '4a000001077', '4a000001078', '4a000001079', '4a000001080', '4a000001081', '4a000001082', '4a000001083', '4a000001084', '4a000001085', '4a000001086', '4a000001087', '4a000001088', '4a000001089', '4a000001090', '4a000001091', '4a000001092', '4a000001093', '4a000001094', '4a000001095', '4a000001096', '4a000001097', '4a000001098', '4a000001099', '4a000001100', '4a000001101', '4a000001102', '4a000001103', '4a000001104', '4a000001105', '4a000001106', '4a000001107', '4a000001108', '4a000001109', '4a000001110', '4a000001111', '4a000001112', '4a000001113', '4a000001114', '4a000001115', '4a000001116', '4a000001117', '4a000001118', '4a000001119', '4a000001120', '4a000001121', '4a000001122', '4a000001123', '4a000001124', '4a000001125', '4a000001126', '4a000001127', '4a000001128', '4a000001129', '4a000001130', '4a000001131', '4a000001132', '4a000001133', '5a000000012', '5a000000018', '5a000000023', '5a000000025', '5a000000026', '5a000000027')