Posted to tcl by Vadtec at Wed May 09 04:23:22 GMT 2007view pretty
sqlite> select id, domain, ip, longip from domain order by id;
id domain ip longip
---------- ---------------------- ------------ ----------
1 you.cant.be.vadtec.net 72.20.27.122 1209277306
2 you.cant.be.vadtec.net 72.20.27.122 1209277306
3 you.cant.be.vadtec.net 72.20.27.122 1209277306
4 you.cant.be.vadtec.net 72.20.27.122 1209277306
5 you.cant.be.vadtec.net 72.20.27.122 1209277306
6 you.cant.be.vadtec.net 72.20.27.122 1209277306
7 i.am.so.s3xy.de 72.20.33.222 1209278942
8 host130-121.pool80182.
9 217-20-120-56.internet 66.254.109.1 1123970445
10 stone7.plus.com 84.92.244.13 1415378051
11 jo0.got.pwnd.in.jo0r.n 72.20.55.193 1209284545
12 encrypted.de 204.8.223.18 -871833674
13 4x4jeep.net 72.20.17.3 1209274627
14 ddos.jp 72.20.16.29 1209274397
15 cesur.net 72.20.46.25 1209282073
16 voodoohosting-71D7CEA6
17 so-1-0-0.oc192.manches 72.20.42.253 1209281277
18 136F2BCC.E4BFB21C.E829
19 need.some.more-weed.ne 72.20.35.144 1209279376
20 need.some.more-weed.ne 72.20.35.144 1209279376
21 voodoohosting-E76D926B
22 voodoohosting-71D7CEA6
23 this-server.has-no-ip. 72.20.41.203 1209280971
24 207.255.135.122 207.255.135. -805337222
25 bnshells.net 72.20.5.18 1209271570
26 OverLord.NormalPeopleH 72.20.40.124 1209280636
27 always.here.with-me.or 72.20.32.76 1209278540
28 85-210-180-208.dsl.pip 85.210.180.2 1439872208
29 72.37.175.2 72.37.175.2 1210429186
30 c-75-67-212-35.hsd1.ma 75.67.212.35 1262736419
31 34.33.88.65.cust.cfl.r 34.33.88.65. 572610625
32 pc-1007.ds5.tuniv.szcz
33 cpe-238-108-31-26.nyc.
34 207.255.135.122 207.255.135. -805337222
35 170-201.82-139.bia.tkb
36 cpe-67-9-85-210.hot.re 67.9.85.210 1124685266
37 kablenet.hu
38 netadmin.voodoohosting
39 voodoohosting-842A210F
40 4270D75.3DB7DEFD.8B266
41 voodoohosting-97AC4147
42 sofakingwetodded.info 72.20.42.222 1209281246
43 voodoohosting-C2C6BE02
44 gawd.biz 69.31.73.217 1159678425
45 voodoohosting-EFD26719
46 clj6-170.dial-up.arnez
47 cq253.internetdsl.tpgn
48 voodoohosting-FAF59B8E
49 200.66.1.135 200.66.1.135 -935198329
50 flameboy.org 72.20.34.185 1209279161
51 200.77.126.82 200.77.126.8 -934445486
52 cesur.net 72.20.46.25 1209282073
53 netadmin.voodoohosting
54 adsl-154-35-207.asm.be 68.154.35.20 1150952399
55 2001:618:400:346a:1337 2001:618:400 0
56 olimp.troep.net.pl
57 voodoohosting-927BBF44
58 voodoohosting-865B51D7
59 voodoohosting-7036AA6B
60 ip-188-252.sn1.eutelli
61 cpe-76-49-216-115.buff 76.49.216.11 1278335091
62 blackhat-hosting.com 72.20.51.199 1209283527
63 blackhat-hosting.com 72.20.51.199 1209283527
64 hax0rs.info 72.20.51.193 1209283521
65 dirty.south.solj.us 72.20.42.124 1209281148
66 dirty.south.solj.us 72.20.42.124 1209281148
67 one.step.ahead.with.un 72.20.2.158 1209270942
68 Sm0kE.W33D.WiV.BLooDzX 72.20.38.37 1209280037
69 136F2BCC.E4BFB21C.E829
70 ti511110a080-5864.bb.o 85.167.238.2 1437069034
71 BSN-77-175-106.dsl.sio 66.45.238.61 1110306365
72 admin.xsroute.com 64.32.4.40 1075840040
73 admin.drifternet.org 67.43.232.66 1126950978
74 us.army.li 66.252.4.193 1123812545
75 83.141.108.140 83.141.108.1 1401777292
76 bitch.you.will.be.ro0t 64.18.149.20 1074959818
77 voodoohosting-D7243D1E
78 ti511110a080-5864.bb.o 85.167.238.2 1437069034
79 voodoohosting-832FDFD5
80 voodoohosting-832FDFD5
81 bnshells.net 72.20.5.18 1209271570
82 d90-128-80-9.cust.tele 90.128.80.9 1518358537
83 need.some.more-weed.ne 72.20.35.144 1209279376
84 need.some.more-weed.ne 72.20.35.144 1209279376
85 spc2-stok7-0-0-cust969 82.9.219.202 1376377802
86 you.cant.be.vadtec.net 72.20.27.122 1209277306
87 adsl-70-113-291-12.dsl
88 host-69-59-90-134.nctv 69.59.90.134 1161517702
89 d83-189-3-175.cust.tel 83.189.3.175 1404896175
90 ncarc6.biblio.arch.uny
91 voodoohosting-7295603C
92 voodoohosting-ABCD5907
93 supid.pl
94 voodoohosting-86E19CA3
95 voodoohosting-7295603C
96 efnet.opers.juped.us 72.20.18.92 1209274972
97 adsl-72-20-49-129.stat 72.20.49.129 1209282945
98 voodoohosting-E76D926B
99 ipchains.secured.my.c0 72.20.49.134 1209282950
100 AC846ECB.ipt.aol.com 172.132.110. -140060702
101 72.20.27.122 72.20.27.122 1209277306
102 cmb2-250.dial-up.arnez
103 69.26.69.188 69.26.69.188 1159349692
104 69.26.69.188 69.26.69.188 1159349692
105 69.26.69.188 69.26.69.188 1159349692
106 dirty.south.solj.us 72.20.42.124 1209281148
107 adsl-72-20-42-205.dsl. 72.20.42.241 1209281265
108 adsl-72-20-42-205.dsl. 72.20.42.241 1209281265
109 ur.little.princess.is.
110 using.the.next.door.ne
111 208.68.93.90
112 stfu.thnx.org
113 phatty.phat.pimp.org
114 68.191.197.211
115 drunk.cuz.i.emptied.th
116 akill.ws
117 thor.novashells.com
118 proxy.shahrul.org
119 wanted.by.the.fbi.be
120 dayz.is.a.decepti.com
121 87-194-94-254.bethere.
122 drunk.cuz.i.emptied.th
123 dirty.south.solj.us
124 virtual.elitehacker.or
125 72.20.51.22
126 AC846ECB.ipt.aol.com
127 voodoohosting-EC612B1C
128 netadmin.voodoohosting
129 just.do.it.cx
130 194.126.241.199
131 c-69-254-237-218.hsd1.
132 64.139.226.80
133 voodoohosting-EE037726
134 207.255.135.122
135 staff.bnshells.net
136 gets.paid.to.have.irc-
137 staff.acmeshells.com
138 voodoohosting-1D67B5C0
139 ip68-13-182-133.om.om.
140 72.20.13.16
141 phishbox.phisher1.com
142 voodoohosting-10BCD9EB
143 netadmin.voodoohosting
144 voodoohosting-FAF59B8E
145 voodoohosting-3B17D4D2
146 200.77.126.82
147 B00M.US
148 2001:618:400:346a:1337
149 65.23.156.189
150 ti511110a080-5864.bb.o
151 staff.tengkorak.org
152 136F2BCC.E4BFB21C.E829
153 netadmin.voodoohosting
154 ip67-88-209-29.z209-88
155 72.20.33.222
156 voodoohosting-FAF59B8E
157 65.23.156.189
158 200.103.131.120
159 d060206.adsl.hansenet.
160 i.am.so.s3xy.de
161 blackhat-hosting.com
162 blackhat-hosting.com
163 your.mother.gave.you.a
164 massive.voltage.co.il
165 72.20.34.181
166 admin.xsroute.com
167 voodoohosting-92CF3BB1
168 64.32.4.40
169 psych0.us
170 cpe-069-133-022-091.r0
171 cpe-069-133-022-091.r0
172 dayz.is.a.decepti.com
173 voodoohosting-ABCD5907
174 cpe-67-9-85-210.hot.re
This is how many rows are in the table, total.
sqlite> select count(id) as count, id, domain, ip, longip from domain order by id;
count id domain ip longip
---------- ---------- ------------------------------ ---------- ----------
174 174 cpe-67-9-85-210.hot.res.rr.com
These are the rows that are returned and should have empty ip and longip fields. It should return 71 rows instead of 37.
sqlite> select id, domain, ip, longip from domain where ip ="" and longip isnull order by id;
id domain ip longip
---------- -------------------------------------- ---------- ----------
8 host130-121.pool80182.interbussines.it
16 voodoohosting-71D7CEA6.nott.cable.ntl.
18 136F2BCC.E4BFB21C.E829E8B5.IP
21 voodoohosting-E76D926B.dsl.hstntx.swbe
22 voodoohosting-71D7CEA6.nott.cable.ntl.
32 pc-1007.ds5.tuniv.szczcecin.pl
33 cpe-238-108-31-26.nyc.res.rr.com
35 170-201.82-139.bia.tkbb.net.pl
37 kablenet.hu
38 netadmin.voodoohosting.com
39 voodoohosting-842A210F.ipt.aol.com
40 4270D75.3DB7DEFD.8B266299.IP
41 voodoohosting-97AC4147.area3.spcsdns.n
43 voodoohosting-C2C6BE02.ipt.aol.com
45 voodoohosting-EFD26719.hsd1.or.comcast
46 clj6-170.dial-up.arnez.si
47 cq253.internetdsl.tpgnet.pl
48 voodoohosting-FAF59B8E.hsd1.fl.comcast
53 netadmin.voodoohosting.com
56 olimp.troep.net.pl
57 voodoohosting-927BBF44.alt.east.verizo
58 voodoohosting-865B51D7.cpe.net.cable.r
59 voodoohosting-7036AA6B.cfl.res.rr.com
60 ip-188-252.sn1.eutellia.it
69 136F2BCC.E4BFB21C.E829E8B5.IP
77 voodoohosting-D7243D1E.ipt.aol.com
79 voodoohosting-832FDFD5.xs4all.nl
80 voodoohosting-832FDFD5.xs4all.nl
87 adsl-70-113-291-12.dsl.snfc21.sbcgloba
90 ncarc6.biblio.arch.unyfi.it
91 voodoohosting-7295603C.carolina.res.rr
92 voodoohosting-ABCD5907.bethere.co.uk
93 supid.pl
94 voodoohosting-86E19CA3.socal.res.rr.co
95 voodoohosting-7295603C.carolina.res.rr
98 voodoohosting-E76D926B.dsl.hstntx.swbe
102 cmb2-250.dial-up.arnez.si
This is how many rows this query returns.
sqlite> select count(id) as count, id, domain, ip, longip from domain where ip ="" and longip isnull order by id;
count id domain ip longip
---------- ---------- ------------------------- ---------- ----------
37 102 cmb2-250.dial-up.arnez.si
This is how many rows have data in the longip field.
sqlite> select count(longip) from domain;
count(longip)
-------------
71
71 - 37 = 66