http://maos.inogs.it/stat/drifter_stat8.php http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&al=31/12/2020&oceano=5&depth=15&type=SVP http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=5&type=SVP http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=5&type=CODE http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=5&type=SVP&status=D http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=19&type=SVP&status=D http://maos.inogs.it/stat/drifter_stat8.php?type=CODE&status=D http://maos.inogs.it/stat/drifter_stat8.php?type=CARTHE&status=D quantita' per durata 1=30gg (di default) Query usata: SELECT count(d.id_drifter) AS num_drifter, round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/5) AS nmesevita FROM (((((tbl_drifter AS d LEFT JOIN tbl_img_web_drifter AS i ON d.id_drifter = i.id_drifter) LEFT JOIN tbl_web_pages as wpages ON i.id_web_pages = wpages.id_web_pages) LEFT JOIN tbl_type AS y ON d.id_type = y.id_type) LEFT JOIN tbl_positioning_system AS pos ON d.id_positioning_system = pos.id_positioning_system) LEFT JOIN tbl_telemetry AS t ON d.id_telemetry = t.id_telemetry) LEFT JOIN tbl_project AS p ON wpages.id_project = p.id_project WHERE d.daelaborare=TRUE and d.transmission_last_date is not null and y.generic='SVP' GROUP BY nmesevita ORDER BY nmesevita; SELECT count(d.id_drifter) AS num_drifter, round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/30) AS nmesevita FROM tbl_drifter AS d INNER JOIN tbl_type AS y ON d.id_type = y.id_type WHERE d.daelaborare=TRUE and d.transmission_last_date is not null and y.generic='SVP' GROUP BY nmesevita ORDER BY nmesevita; TYPE (generic) OTHER CMOD WHOI DWS CARTHE CODE A106/A111 SVP