http://argo.ogs.it/stat/drifter_stat11.php Quanti strum per project per tipo Query usata: SELECT Count(d.id_drifter) AS quanti, y.generic, coalesce(p.name,'NO NAME') 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 (p.name='DDR20' or p.name='MREP20' ) GROUP BY y.generic, p.name ORDER BY p.name, y.generic;