http://maos.inogs.it/stat/drifter_stat11pie.php
Quanti strum per project per tipo
Query usata:
SELECT Count(d.id_drifter) AS quanti, y.generic
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.id_project=96
GROUP BY y.generic;