quantita' per durata 1=30gg (di default)
Query usata: SELECT count(d.id_drifter) AS num_drifter, coalesce(round((coalesce(d.transmission_last_date,d.deployment_time)::date - d.deployment_time::date)/5)::text, 'Unknown') AS nmesevita 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 d.daelaborare=TRUE and d.transmission_last_date is not null AND (id_oceano = 5) AND status = 'A' GROUP BY nmesevita ORDER BY nmesevita;