0jTkGRe3

1select top 1124 * from
2Master_Subscribers_Score_GTE_5
3where [E-mail Address] like '%YAHOO.COM%'
4
5union all
6
7select top 402 * from
8Master_Subscribers_Score_GTE_5
9where ([E-mail Address] like '%HOTMAIL.COM%' or [E-mail Address] like '%LIVE.COM%')
10
11union all
12
13select top 45 * from
14Master_Subscribers_Score_GTE_5
15where [E-mail Address] like '%AOL.COM%'
16
17union all
18
19select top 2353 * from
20Master_Subscribers_Score_GTE_5
21where [E-mail Address] like '%GMAIL.COM%'
22
23union all
24
25select top 164 * from
26Master_Subscribers_Score_GTE_5
27where ([E-mail Address] like '%ATT.COM%' or [E-mail Address] like '%SBCGLOBAL.NET%')
28
29union all
30
31select top 8 * from
32Master_Subscribers_Score_GTE_5
33where [E-mail Address] like '%COX.NET%'
34
35union all
36
37select top 3 * from
38Master_Subscribers_Score_GTE_5
39where [E-mail Address] like '%VERIZON.NET%'
40
41union all
42
43select top 70 * from
44Master_Subscribers_Score_GTE_5
45where [E-mail Address] like '%RR.COM%'
46
47union all
48
49select top 712 * from
50Master_Subscribers_Score_GTE_5
51where [E-mail Address] not like '%YAHOO.COM%' and
52[E-mail Address] not like '%HOTMAIL.COM%' and
53[E-mail Address] not like '%LIVE.COM%' and
54[E-mail Address] not like '%AOL.COM%' and
55[E-mail Address] not like '%GMAIL.COM%' and
56[E-mail Address] not like '%ATT.COM%' and
57[E-mail Address] not like '%SBCGLOBAL.NET%' and
58[E-mail Address] not like '%COX.NET%' and
59[E-mail Address] not like '%VERIZON.NET%' and
60[E-mail Address] not like '%RR.COM%'