/home/www/vhosts/argo.ogs.it/stat/prj_ins_num_stat1.php SELECT Count(d.id_drifter) AS quanti,'Drifter' as type, EXTRACT (YEAR from d.deployment_time) AS anno FROM ((tbl_type as y RIGHT JOIN tbl_drifter as d ON y.id_type = d.id_type) LEFT JOIN tbl_img_web_drifter ON d.id_drifter = tbl_img_web_drifter.id_drifter) LEFT JOIN (tbl_project as p RIGHT JOIN tbl_web_pages as i ON p.id_project = i.id_project) ON tbl_img_web_drifter.id_web_pages = i.id_web_pages 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_project as p RIGHT JOIN tbl_web_pages as i ON p.id_project = i.id_project) RIGHT JOIN (tbl_float as d LEFT JOIN tbl_img_web_float ON d.id_float = tbl_img_web_float.id_float) ON i.id_web_pages = tbl_img_web_float.id_web_pages) LEFT 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 tbl_project.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; rimosso group by type