Regolamento Partecipanti Tappe Maglia Rosa Maglia Ciclamino Maglia Verde

Maglia Rosa

select = select distinct cr.cr_nome as Nome, cr.cr_tipo as Tipo, sq.sq_nome as Team, sq.sq_prop as Manager, sum(if(ld_fine.fn_tp_num <= 2,ld_fine.fn_dist,0)) + sum(if(ld_intergiro.in_tp_num <= 2,ld_intergiro.in_dist,0)) as dist, cr.cr_id, count(ifnull(ld_fine.fn_dist,0)) from ld_corridori as cr join ld_squadre as sq on (cr.cr_sq_id = sq.sq_id) left join ld_fine on (cr.cr_id = ld_fine.fn_cr_id) join ld_tappa on (ld_tappa.tp_id = ld_fine.fn_tp_id) rigth join ld_intergiro on (cr.cr_id = ld_intergiro.in_cr_id) where cr.cr_id < 100 and ld_tappa.tp_num <= 2 group by (cr.cr_id) order by dist desc

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.liga3m.it/home/leader1/rosa.php on line 47

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.liga3m.it/home/leader1/rosa.php on line 51
CorridoreTeam (Manager)ClassificaEnerTappe

Classifica a Squadre

Team (Manager)Classifica
LIGA-B-ONE (Andrea "Liga" Ligabue)-3
EPO (Roberto "Viki" Vaccari)-5
POPPEI (Roberto "Smilzo" Fontana)-5
GAMMA TEAM (Auro "Auro" Miselli)-5
BONONIA (Paolo "Senso" Antonelli )-7
QUALUNQUISTI (Luca "Luca" Montanari)-7
SIR.UDELA BYKERS (Fabio "Monty" Montanari)-9
ASTRANA (Alessandro "Talpa" Alberghini)-9
FANDANGO (Enrico "Rod" Sernesi)-12
I CICLISTI PER CASO (Mattia "Saltuz" Saltini)-12
BOVAZZARI (Federico "Bovaz" Ferrari)-13
QUIQUOQUA (Zhu "Zu" Song)-15