[b][sql][/b]DB::query('Select u.username as nick, FLOOR(('.$pkt.')/1000) as punkty, SUM(p.points_fleet) as pkt_floty, Floor(('.$tech.')/1000) as badania, ('.$il.') as ilosc_badan, Floor(SUM(p.points)/1000) as pkt_za_flote, floor(('.$kap.')/1000) as pkt_za_kapitol,SUM(points_defense) as ilosc_obrony from ugml_planets p Left Join ugml_users u on u.id=id_owner left join ugml_kapitol k on k.user_id=id_owner where u.id='.$idGr.' group by p.id_owner',__FILE__,__LINE__)); [b][/sql][/b]