create temporary table tries(device_id int not null unique, cnt int not null);
SELECT version, (
CASE WHEN known_ids.device_name IS NULL
THEN source.device_id
ELSE known_ids.device_name
END
) AS device, TIME, submission, country, level, try, hint, moves
FROM (

SELECT @submission := (
CASE @device
WHEN device_id
THEN @submission +1
ELSE 1
END ) AS submission,
BEGIN
INSERT INTO tries( level_id, cnt )
VALUES (
play_logs.level_id, 1
) ON DUPLICATE
KEY UPDATE cnt = cnt +1;

SELECT version,
        (case when known_ids.device_name is null then source.device_id else known_ids.device_name end) as device,
        time, submission, country, level, try, hint, moves
FROM (
        SELECT @submission := (
                CASE @device
                WHEN device_id THEN @submission + 1
                ELSE 1
                END ) AS submission,
                @try := (
                CASE @level
                WHEN level_id THEN @try + 1
                ELSE 1
                END ) AS try, version, @device := device_id AS device_id, TIME, country, @level := level_id…

$query = "SELECT lcc.contestid, lcc.duration, lcc.num_entries, lcc.winning_number, lcc.deadline, lcc.winner_userid,
                       lu.display_name
                FROM ld_completed_contests lcc
                INNER JOIN ld_entries le ON le.userid = $userid AND lcc.contestid = le.contestid
                INNER JOIN ld_users lu ON lu.userid = lcc.winner_userid\n";

$query = "SELECT lcc.contestid, lcc.duration, lcc.num_entries, lcc.winning_number, lcc.deadline, lcc.winner_userid,
                       lu.display_name
                FROM ld_completed_contests lcc
                INNER JOIN ld_entries le ON le.userid = $userid AND lcc.contestid = le.contestid
                INNER JOIN ld_users lu ON lu.userid = lcc.winner_userid\n";
if($type == "1")
{
    $query .= "WHERE lcc.duration = 1\n";
}
else if($type == "24")
{
    $query .= "WHERE lcc.duration = 24\n";