http://argo.ogs.it/stat/drifter_stat_tx_e_editati.php Quanti editati (con redeploy/split) Query usata: select d.id_drifter as id_drifter 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 i.id_web_pages=;

select id_drifter,round(manual_ed::decimal/(manual_ed+auto_ed+good_data),4) as manual_ed_perc, round(auto_ed::decimal/(manual_ed+auto_ed+good_data),4) as auto_ed_perc, round(good_data::decimal/(manual_ed+auto_ed+good_data),4) as good_data_perc from (SELECT id_drifter, count(id_drifter) filter (where qc>=1024) as manual_ed, count(id_drifter) filter (where qc>0 and qc<1024) as auto_ed, count(id_drifter) filter (where qc=0) as good_data from tbl_drifter_dec_ril where id_drifter IN (select d.id_drifter as id_drifter 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 i.id_web_pages=) group by id_drifter ) as tmp ORDER BY good_data_perc