09年:
16:
NOT IN (1,2,3,4,5,6,7,8,9) 4个以10开始,4个以11开始
2 link group: 4 (0个3 link)
1 link group: 9 (2个3 link)
none link: 3
11:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 8 (3个3 link)
1 link group: 2 (0个3 link)
none link: 1
15:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 2 (1个3 link)
1 link group: 9 (2个3 link)
none link: 4
-------------------------------------------
08年:
19:
NOT IN (1,2,3,4,5,6,7,8,9) 8个以10开始
2 link group: 6 (2个3 link)
1 link group: 10 (2个3 link)
none link: 3
13:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 1 (0个3 link)
1 link group: 8 (3个3 link)
none link: 4
16:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 4 (1个3 link)
1 link group: 7 (1个3 link)
none link: 5
-------------------------------------------
07年:
13:
NOT IN (1,2,3,4,5,6,7,8,9) 3个以10开始
2 link group: 2 (1个3 link)
1 link group: 9 (4个3 link)
none link: 2
9:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 2 (0个3 link)
1 link group: 5 (3个3 link)
none link: 2
15:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 3 (0个3 link)
1 link group: 9 (2个3 link)
none link: 2
-------------------------------------------
06年:
15:
NOT IN (1,2,3,4,5,6,7,8,9) 1个以10开始
2 link group: 2 (1个3 link)
1 link group: 11 (1个3 link)
none link: 3
13:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 4 (2个3 link)
1 link group: 6 (2个3 link)
none link: 3
14:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 4 (2个3 link)
1 link group: 6 (1个3 link)
none link: 4
-------------------------------------------
05年:
16:
NOT IN (1,2,3,4,5,6,7,8,9) 3个以10开始,5个以11开始
2 link group: 2 (2个3 link)
1 link group: 7 (2个3 link)
none link: 7
17:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 2 (0个3 link)
1 link group: 7 (0个3 link)
none link: 8
16:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 1 (0个3 link)
1 link group: 9 (1个3 link)
none link: 6
-------------------------------------------
04年:
(总122期: 2004122)
19:
NOT IN (1,2,3,4,5,6,7,8,9) 7个以10开始,4个以11开始
2 link group: 3 (0个3 link)
1 link group: 15 (1个3 link)
none link: 1
12:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 3 (1个3 link)
1 link group: 5 (0个3 link)
none link: 4
12:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 3 (1个3 link)
1 link group: 5 (1个3 link)
none link: 4
-------------------------------------------
03年:
(总89期: 2003089)
10:
NOT IN (1,2,3,4,5,6,7,8,9) 2个以10开始,2个以11开始
2 link group: 3 (1个3 link)
1 link group: 5 (0个3 link)
none link: 2
9:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 2 (0个3 link)
1 link group: 6 (0个3 link)
none link: 1
14:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 6 (3个3 link)
1 link group: 7 (1个3 link)
none link: 1
++++++++++++++++++++++++++++++++++++++++++++++++++++
select * from caihistory where num1 not in (20,21,22,23,24,25,26,27,28,29) and
num2 not in (20,21,22,23,24,25,26,27,28,29) and
num3 not in (20,21,22,23,24,25,26,27,28,29) and
num4 not in (20,21,22,23,24,25,26,27,28,29) and
num5 not in (20,21,22,23,24,25,26,27,28,29) and
num6 not in (20,21,22,23,24,25,26,27,28,29) order by 1 desc
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14377/viewspace-1028581/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14377/viewspace-1028581/