Как можно такое реализовать

SELECT 
    winner, 
    dp.gameid as id, 
    newcolour, 
    datetime, 
    gamename, 
    original, 
    description, 
    kills, 
    deaths, 
    assists, 
    creepkills, 
    creepdenies, 
    neutralkills, 
    name, 
    CASE when(gamestate = '17') then 'PRIV' else 'PUB' end as type,
    CASE WHEN (kills = 0) THEN 0 WHEN (deaths = 0) then 1000 ELSE (kills*1.0/deaths) end as kdratio,
    CASE when ((winner=1 and newcolour < 6) 
    or (winner=2 and newcolour > 5)) 
    AND gp.`left`/g.duration >= $minPlayedRatio  then 'WON' when ((winner=2 and newcolour < 6) 
    or (winner=1 and newcolour > 5)) 
    AND gp.`left`/g.duration >= $minPlayedRatio  then 'LOST' when  winner=0 then 'DRAW' else '$LEAVER' end as outcome 
    FROM dotaplayers AS dp 
    LEFT JOIN gameplayers AS gp ON gp.gameid = dp.gameid and dp.colour = gp.colour 
    LEFT JOIN dotagames AS dg ON dg.gameid = dp.gameid 
    LEFT JOIN games AS g ON g.id = dp.gameid 
    LEFT JOIN heroes as e ON dp.hero = heroid 
    WHERE LOWER(name) = LOWER('$username') and original <> 'NULL' 
    ORDER BY $order $sortdb, g.id $sortdb 
    LIMIT $offset, $rowsperpage

  SELECT winner, dp.gameid, gp.colour, newcolour, original as hero, level, description, kills, deaths, assists, creepkills, creepdenies, neutralkills, towerkills, gold,  raxkills, courierkills, 
       item1, item2, item3, item4, item5, item6, 
       it1.icon as itemicon1, 
       it2.icon as itemicon2, 
       it3.icon as itemicon3, 
       it4.icon as itemicon4, 
       it5.icon as itemicon5, 
       it6.icon as itemicon6, 
       it1.name as itemname1, 
       it2.name as itemname2, 
       it3.name as itemname3, 
       it4.name as itemname4, 
       it5.name as itemname5, 
       it6.name as itemname6, 
       leftreason, 
       gp.left, 
       gp.name as name, 
       gp.ip as ip,
       b.name as banname 
       FROM dotaplayers AS dp 
       LEFT JOIN gameplayers AS gp ON gp.gameid = dp.gameid and dp.colour = gp.colour 
       LEFT JOIN dotagames AS dg ON dg.gameid = dp.gameid 
       LEFT JOIN games AS g ON g.id = dp.gameid 
       LEFT JOIN bans as b ON b.name=gp.name
       LEFT JOIN heroes as f ON hero = heroid
       LEFT JOIN items as it1 ON it1.itemid = item1
       LEFT JOIN items as it2 ON it2.itemid = item2
       LEFT JOIN items as it3 ON it3.itemid = item3
       LEFT JOIN items as it4 ON it4.itemid = item4
       LEFT JOIN items as it5 ON it5.itemid = item5
       LEFT JOIN items as it6 ON it6.itemid = item6
       WHERE dp.gameid=$gid
       GROUP by gp.name
       ORDER BY newcolour