http://maos.inogs.it/stat/drifter_stat8.php http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&al=31/12/2020&oceano=5&depth=15&type=SVP http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=5&type=SVP http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=5&type=CODE http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=5&type=SVP&status=D http://maos.inogs.it/stat/drifter_stat8.php?dal=01/01/2005&oceano=19&type=SVP&status=D http://maos.inogs.it/stat/drifter_stat8.php?type=CODE&status=D http://maos.inogs.it/stat/drifter_stat8.php?type=CARTHE&status=D quantita' per durata 1=30gg (di default) Query usata: SELECT count(d.id_drifter) AS num_drifter, round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/5) AS nmesevita 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 d.transmission_last_date is not null and y.generic='SVP' GROUP BY nmesevita ORDER BY nmesevita; SELECT count(d.id_drifter) AS num_drifter, round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/30) AS nmesevita FROM tbl_drifter AS d INNER JOIN tbl_type AS y ON d.id_type = y.id_type WHERE d.daelaborare=TRUE and d.transmission_last_date is not null and y.generic='SVP' GROUP BY nmesevita ORDER BY nmesevita; TYPE (generic) OTHER CMOD WHOI DWS CARTHE CODE A106/A111 SVP

SELECT count(d.id_drifter) AS num_drifter, round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/5) AS nmesevita 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 d.transmission_last_date is not null and p.id_project='107' GROUP BY nmesevita ORDER BY nmesevita;

Full data not grouped
SELECT d.id_drifter, round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/5) AS nmesevita 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 d.transmission_last_date is not null and p.id_project='107' ORDER BY nmesevita;

id_driftern mesi vita
63270
63530
63340
63470
63480
62880
63660
63670
63680
63690
63710
63150
63160
63330
64380
63040
63020
63010
62840
64300
63000
64130
62990
62830
62950
64240
62930
62910
64200
62890
64180
62870
63240
64090
63200
63740
63730
63100
63650
63051
64681
63221
64111
64101
63061
63141
64221
64282
64312
64262
64152
64142
63072
62942
62962
62972
64173
64123
63233
64323
64293
62823
62923
63133
62903
63723
64193
62863
64073
64274
62984
63094
64084
64374
64404
63034
63185
63706
64217
63177
64237
64417
64657
64257
63118
63328
63568
63428
64668
64398
63519
63549
63389
63419
63369
63219
634010
635710
634310
635010
632611
632511
634511
646714
630819
635524
633125
633526
632826
633026
634926
633733
631954
631254