select * from caihistory where num1 not in (2,3,4,5,6,7,8,10,12,15,17,20,26,30,31,32) and
num2 not in (2,3,4,5,6,7,8,10,12,15,17,20,26,30,31,32) and
num3 not in (2,3,4,5,6,7,8,10,12,15,17,20,26,30,31,32) and
num4 not in (2,3,4,5,6,7,8,10,12,15,17,20,26,30,31,32) and
num5 not in (2,3,4,5,6,7,8,10,12,15,17,20,26,30,31,32) and
num6 not in (2,3,4,5,6,7,8,10,12,15,17,20,26,30,31,32) order by 1 desc
almost every year, we have records not in above numbers, but so for since 2009, havn't got any record falling out above numbers.
1 8132 9 13 16 25 27 33 8
2 8073 1 9 13 22 28 33 8
3 8006 1 14 16 18 22 27 14
4 2007132 1 9 16 21 22 23 5
5 2007092 24 14 23 18 22 33 9
6 2007068 11 18 19 22 23 28 1
7 2006129 9 14 18 22 27 29 12
8 2006089 1 13 16 18 19 22 1
9 2005101 9 16 19 21 22 24 12
10 2004054 9 11 14 16 27 28 11
1,9,11,13,14,16,18,19,21,22,23,24,25,27,28,29,33
1,9,13,14,16,22,23,24