Jak resit duplicitu u LEFT JOINu

$query=DB::query("SELECT u.id,u.username,p.loginid,p.ratesum,p.ratenum
                          FROM `"._mysql_prefix . "-photo` p
                          LEFT JOIN `" . _mysql_prefix . "-users` u
                          ON u.id = p.loginid 
                          WHERE p.ratenum!=0 ORDER BY round(ratesum / ratenum) DESC LIMIT ".$limit);
                          
    while ($item = DB::row($query)){

    /* jDanek Ratting System */
    $ratting="";
    if ($item['ratesum'] == 0 && $item['ratenum'] == 1){$ratting = 1;}
    else{
    $tmp_ratting = (($item['ratesum'] / $item['ratenum'])/20);
    $ratting = round(($tmp_ratting*2), 0)/2;
    }
    
    /* --- Avatar --- */

    $avatar="<img src='"._getAvatar($item["id"], true)."' alt='Miss ".$item["username"]."' class='avatar' />";        
    $result.="<div class='blok'>
                <a class='link' href='miss-".strtolower($item['username'])."'>".$item["username"]."</a>
                <a href='miss-".strtolower($item['username'])."'>".$avatar."</a>
                    <div class='mini-star-invisible' title='Hodnocení: ".$ratting." z 5'>
                        <div class='mini-star-".str_replace(".","-",$ratting)." mini-star'></div>
                    </div>
              </div>";
    
}