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.id_project=96
GROUP BY d.depth order by d.depth;