Lines Matching refs:score1
4 score1 INT,
7 INDEX (score1, created_at, score2)
13 `score1` int(11) DEFAULT NULL,
17 KEY `score1` (`score1`,`created_at`,`score2`)
19 INSERT INTO items (score1, score2, created_at) VALUES(1, 0, "2015-07-01 00:00:00");
20 INSERT INTO items (score1, score2, created_at) VALUES(2, 0, "2015-07-01 00:00:00");
21 INSERT INTO items (score1, score2, created_at) VALUES(3, 0, "2015-07-01 00:00:00");
22 INSERT INTO items (score1, score2, created_at) VALUES(1, 0, "2015-07-01 12:00:00");
23 INSERT INTO items (score1, score2, created_at) VALUES(2, 0, "2015-07-01 12:00:00");
24 INSERT INTO items (score1, score2, created_at) VALUES(3, 0, "2015-07-01 12:00:00");
25 INSERT INTO items (score1, score2, created_at) VALUES(1, 0, "2015-07-02 00:00:00");
26 INSERT INTO items (score1, score2, created_at) VALUES(2, 0, "2015-07-02 00:00:00");
27 INSERT INTO items (score1, score2, created_at) VALUES(3, 0, "2015-07-02 00:00:00");
30 WHERE score1 = 2 AND created_at <= "2015-07-01 12:00:00"
32 id score1 score2 created_at