SV02ri2t

1CREATE TABLE IF NOT EXISTS `shares` (
2      `sname` int(11) NOT NULL,
3      `share` text,
4      `shareCount` int(11) NOT NULL DEFAULT '0',
5      `shareLevel` int(11) NOT NULL DEFAULT '1',
6      `lastPlay` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7      PRIMARY KEY (`sname`),
8      KEY `shareLevel` (`shareLevel`),
9      KEY `lastPlay` (`lastPlay`)
10    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
11
12
13SELECT * FROM shares WHERE 
14"2016-09-25" < lastPlay AND 
15shareLevel < 107750 AND 
16shareLevel > 1 AND 
17NOT sname = 1234567 
18ORDER BY shareLevel DESC 
19LIMIT 60