insert into valid_lists (name) values ("campaign_preview_test");

insert into addys (user,domain,full_addy) values ("one","f00bar.com","one@f00bar.com");
insert into addys (user,domain,full_addy) values ("two","f00bar.com","two@f00bar.com");
insert into addys (user,domain,full_addy) values ("three","f00bar.com","three@f00bar.com");
insert into addys (user,domain,full_addy) values ("four","f00bar.com","four@f00bar.com");
insert into addys (user,domain,full_addy) values ("five","f00bar.com","five@f00bar.com");
insert into addys (user,domain,full_addy) values ("six","f00bar.com","six@f00bar.com");
insert into addys (user,domain,full_addy) values ("seven","f00bar.com","seven@f00bar.com");
insert into addys (user,domain,full_addy) values ("eight","f00bar.com","eight@f00bar.com");
insert into addys (user,domain,full_addy) values ("nine","f00bar.com","nine@f00bar.com");
insert into addys (user,domain,full_addy) values ("ten","f00bar.com","ten@f00bar.com");
insert into addys (user,domain,full_addy) values ("eleven","f00bar.com","eleven@f00bar.com");
insert into addys (user,domain,full_addy) values ("twelve","f00bar.com","twelve@f00bar.com");
insert into addys (user,domain,full_addy) values ("thirteen","f00bar.com","thirteen@f00bar.com");
insert into addys (user,domain,full_addy) values ("fourteen","f00bar.com","fourteen@f00bar.com");

insert into addys (user,domain,full_addy) values ("newslettersf","military-inc.com","newslettersf@military-inc.com");
insert into addys (user,domain,full_addy) values ("military","cp.assurance.returnpath.net","military@cp.assurance.returnpath.net");







+--------------------------------------+-----------+
| full_addy                            | mailid    |
+--------------------------------------+-----------+
| newslettersf@military-inc.com        | 000004588 |
| three@f00bar.com                     | 000004576 |
| five@f00bar.com                      | 000004578 |
| seven@f00bar.com                     | 000004580 |
| nine@f00bar.com                      | 000004582 |
| eleven@f00bar.com                    | 000004584 |
| thirteen@f00bar.com                  | 000004586 |
| two@f00bar.com                       | 000004575 |
| four@f00bar.com                      | 000004577 |
| six@f00bar.com                       | 000004579 |
| eight@f00bar.com                     | 000004581 |
| ten@f00bar.com                       | 000004583 |
| twelve@f00bar.com                    | 000004585 |
| fourteen@f00bar.com                  | 000004587 |
| one@f00bar.com                       | 000004574 |
| military@cp.assurance.returnpath.net | 000004589 |
+--------------------------------------+-----------+