ELECT Name,
lll.Map,
TIME,
min(lll.Timestamp),
min(TYPE),
Server,
max(OldTime),
Points,
Country
FROM
(SELECT Name, Map, TIME, Timestamp, "2 Top 1 rank" AS TYPE,
(SELECT TIME
FROM record_race
WHERE Map = l.map
AND Timestamp < "{0}"
ORDER BY TIME
LIMIT 1) AS OldTime,
Country
FROM
(SELECT Timestamp, Name, Map, TIME,
Server AS Country
FROM record_race
WHERE Timestamp >= "{0}"
AND Timestamp < "{1}") AS l
WHERE TIME <=
(SELECT min(TIME)
FROM record_race
WHERE Map = l.Map)
UNION ALL SELECT record_teamrace.Name,
record_teamrace.Map,
record_teamrace.Time,
record_teamrace.Timestamp,
"1 Top 1 team rank" AS TYPE,
OldTime,
record_race.Server AS Country
FROM
(SELECT ID,
(SELECT TIME
FROM record_teamrace
WHERE Map = l.Map
AND ID != l.ID
AND Timestamp < "{0}"
ORDER BY TIME
LIMIT 1) AS OldTime
FROM
(SELECT DISTINCT ID, Map, TIME
FROM record_teamrace
WHERE Timestamp >= "{0}"
AND Timestamp < "{1}") AS l
LEFT JOIN
(SELECT Map, min(TIME) AS minTime
FROM record_teamrace
GROUP BY Map) AS r ON l.Map = r.Map
WHERE TIME = minTime) AS ll
INNER JOIN record_teamrace ON ll.ID = record_teamrace.ID
JOIN record_race ON record_teamrace.Map = record_race.Map
AND record_teamrace.Name = record_race.Name
AND record_teamrace.Time = record_race.Time
AND record_teamrace.Timestamp = record_race.Timestamp
UNION ALL SELECT Name, Map, TIME, Timestamp, "5 Worst rank on DDNet" AS TYPE,
(SELECT TIME
FROM record_race
WHERE Timestamp < "{0}"
AND Map != "Time Shop"
AND Map != "Care for your Time"
ORDER BY TIME DESC
LIMIT 1) AS OldTime,
Server AS Country
FROM
(SELECT *
FROM record_race
WHERE Map != "Time Shop"
AND Map != "Care for your Time"
AND TIME >
(SELECT TIME
FROM record_race
WHERE Timestamp < "{0}"
AND Map != "Time Shop"
AND Map != "Care for your Time"
ORDER BY TIME DESC
LIMIT 1)
ORDER BY TIME DESC) AS llll
WHERE Timestamp >= "{0}"
AND Timestamp < "{1}" ) AS lll
JOIN record_maps ON lll.Map = record_maps.Map
WHERE lll.Map != "Nyan Cat"
AND record_maps.Server != "Fun"
GROUP BY Name, Map, TIME
ORDER BY lll.Timestamp,
Name ASC; (edited)
for free
1
2
president Hu Jintao forcefully escorted out of #CCP party congress
Li Keqiang, Li Zhanshu, Han Zheng & Wang Yang, all reformist & liberal CCP figures, are out of new CCP Central Committee.
All references to #HuJintao removed from govt website.
https://t.co/ku5HdJ0uHE
1
1
