Login
Enregistrement
Password
EN

The spots > Le Prado > Statistics of the spot > Average number of sailed days per month (2020)


2015 [32] • 2016 [33] • 2017 [24] • 2018 [7] • 2019 [2]
12 last monthsHistorical

Erreur SQL !
select date_format(date,'%Y-%m') as vdate, count(distinct date) as nb from sessions a where a.id_spot=1 and date_format(date,'%m')=11 and ((ventMin+ventMax)/2 >=10 or (isnull(ventMin) and ventMax>=10) or (ventMin>=10 and isnull(ventMax))) and date_format(date,'%Y')=2020 group by date_format(date,'%Y-%m')
Lost connection to MySQL server during query