http://maos.inogs.it/stat/dfg_stat1.php SELECT Count(d.id_drifter) AS quanti,'Drifter' as type, EXTRACT (YEAR from d.deployment_time) AS anno FROM (((tbl_drifter as d INNER JOIN tbl_img_web_drifter ON d.id_drifter = tbl_img_web_drifter.id_drifter) INNER JOIN tbl_web_pages ON tbl_img_web_drifter.id_web_pages = tbl_web_pages.id_web_pages) INNER JOIN tbl_project AS p ON tbl_web_pages.id_project = p.id_project) INNER JOIN tbl_type AS y ON d.id_type = y.id_type WHERE d.daelaborare=TRUE $str_sql_where GROUP BY type, anno ORDER BY type UNION SELECT count(d.id_float), "Float" as type, EXTRACT (YEAR from d.deployment_time) as anno FROM tbl_float as d INNER JOIN tbl_type as y ON d.id_type = y.id_type WHERE no_in_table_web=FALSE $str_sql_where group by anno, type order by anno UNION SELECT count(d.id_deploy_glider), "Glider" as type, EXTRACT (YEAR from d.data_deploy) as anno FROM (tbl_project INNER JOIN (tbl_img_web_glider INNER JOIN tbl_web_pages ON tbl_img_web_glider.id_web_pages = tbl_web_pages.id_web_pages) ON p.id_project = tbl_web_pages.id_project) INNER JOIN tbl_deploy_glider as d ON tbl_img_web_glider.id_deploy_glider = d.id_deploy_glider group by anno,type order by anno;