select time_format(mtotime,'%H:%m') as heure ,round(mtoventangle,0) as ang ,round(mtoventmoy/1.852,2) as moy ,round(mtoventmax/1.852,2) as max from navs nv inner join meteo mto on nvdate = mtodate where time_to_sec(mtotime) between time_to_sec(nvtime)-1800 and (time_to_sec(nvtime)+time_to_sec(nvduration)+3600) and date_format(nvdate,'%Y%m%d')='20150111' group by mtotime
1146 : Table 'daemon64.meteo' doesn't exist