> The riders list > zerointeractive > Statitics
Profile | Sessions | Equipment | Photos | Statitics
Sessions per year (5 last years)
Sessions per spot (10 most frequented)
Sessions per board (10 most used)
select distinct p.id_voile, concat(marque,' ',modele) as vText, surface, annee, ((select count(*) from sessions s where s.id_rider=3348 and s.id_voile=p.id_voile) + (select count(*) from sessions s, matos_sup m where s.id_rider=3348 and s.id_session=m.id_session and m.type='V' and m.id_matos=p.id_voile)) as nb from voiles p where p.id_rider=3348 union select distinct 0, 'Undefined', 0, 0, count(*) from sessions s where id_rider=3348 and (s.id_voile=0 or isnull(s.id_voile)) group by 1,2,3 order by 5 desc limit 10
Lost connection to MySQL server during query