http://maos.inogs.it/stat/drifter_stat10.php quanti per drogue Query usata: SELECT Count(d.id_drifter) AS quanti, d.depth 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 daelaborare=TRUE and p.name='DDR20' GROUP BY d.depth order by d.depth;


SELECT Count(d.id_drifter) AS quanti, depth 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 daelaborare=TRUE and p.name='DDR20' GROUP BY depth order by depth;

Full data not grouped
SELECT Count(d.id_drifter) AS quanti, depth 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 daelaborare=TRUE and p.name='DDR20' GROUP BY depth order by depth;

id_drifterdepth
280
300.3
510.5
515