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_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) where daelaborare=TRUE and status='A' ;

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_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) where daelaborare=TRUE and status='A' ) group by id_drifter ORDER BY good_data