http://maos.inogs.it/stat/drifter_stat11.php Quanti strum per project per tipo Query usata: SELECT Count(d.id_drifter) AS quanti, y.generic, coalesce(p.name,'NO NAME') 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 argo_mission='a' and (p.name='DDR20' or p.name='MREP20' ) GROUP BY y.generic, p.name ORDER BY p.name, y.generic;

SELECT Count(d.id_drifter) AS quanti, y.generic, coalesce(p.name,'NO NAME') 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 argo_mission='a' and (p.name='DDR20' or p.name='MREP20' ) GROUP BY y.generic, p.name ORDER BY p.name, y.generic;

Full data not grouped
SELECT d.id_drifter, y.generic, coalesce(p.name,'NO NAME') 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 argo_mission='a' and (p.name='DDR20' or p.name='MREP20' ) ORDER BY p.name, y.generic, id_drifter;

id_driftertypeProject
6306CARTHEDDR20
6307CARTHEDDR20
6308CARTHEDDR20
6309CARTHEDDR20
6310CARTHEDDR20
6311CARTHEDDR20
6312CARTHEDDR20
6313CARTHEDDR20
6314CARTHEDDR20
6315CARTHEDDR20
6316CARTHEDDR20
6317CARTHEDDR20
6318CARTHEDDR20
6319CARTHEDDR20
6320CARTHEDDR20
6321CARTHEDDR20
6322CARTHEDDR20
6323CARTHEDDR20
6324CARTHEDDR20
6325CARTHEDDR20
6286CODEDDR20
6287CODEDDR20
6288CODEDDR20
6289CODEDDR20
6290CODEDDR20
6291CODEDDR20
6292CODEDDR20
6293CODEDDR20
6294CODEDDR20
6295CODEDDR20
6296CODEDDR20
6297CODEDDR20
6298CODEDDR20
6299CODEDDR20
6300CODEDDR20
6301CODEDDR20
6302CODEDDR20
6303CODEDDR20
6304CODEDDR20
6305CODEDDR20
6326CODEDDR20
6327CODEDDR20
6328CODEDDR20
6330CODEDDR20
6331CODEDDR20
6332CODEDDR20
6333CODEDDR20
6334CODEDDR20
6335CODEDDR20
6336CODEDDR20
6337CODEDDR20
6338CODEDDR20
6340CODEDDR20
6341CODEDDR20
6342CODEDDR20
6343CODEDDR20
6345CODEDDR20
6347CODEDDR20
6348CODEDDR20
6349CODEDDR20
6350CODEDDR20
6351CODEDDR20
6353CODEDDR20
6354CODEDDR20
6355CODEDDR20
6356CODEDDR20
6357CODEDDR20
6373CODEDDR20
6374CODEDDR20
6370DWSDDR20
6371DWSDDR20
6372DWSDDR20
6407PARCDDR20
6408PARCDDR20
6409PARCDDR20
6410PARCDDR20
6411PARCDDR20
6412PARCDDR20
6413PARCDDR20
6414PARCDDR20
6415PARCDDR20
6417PARCDDR20
6418PARCDDR20
6419PARCDDR20
6420PARCDDR20
6421PARCDDR20
6422PARCDDR20
6423PARCDDR20
6424PARCDDR20
6425PARCDDR20
6426PARCDDR20
6427PARCDDR20
6428PARCDDR20
6429PARCDDR20
6430PARCDDR20
6431PARCDDR20
6432PARCDDR20
6365SVPDDR20
6366SVPDDR20
6367SVPDDR20
6368SVPDDR20
6369SVPDDR20
6387DWSMREP20
6442PARCMREP20
6443PARCMREP20
6444PARCMREP20
6446PARCMREP20
6447PARCMREP20
6448PARCMREP20
6451PARCMREP20
6452PARCMREP20
6453PARCMREP20
6455PARCMREP20
6456PARCMREP20
6457PARCMREP20
6458PARCMREP20
6459PARCMREP20
6460PARCMREP20
6375SVPMREP20
6376SVPMREP20
6377SVPMREP20
6378SVPMREP20
6379SVPMREP20
6380SVPMREP20
6381SVPMREP20
6382SVPMREP20
6383SVPBMREP20
6384SVPBMREP20
6385SVPBMREP20
6386SVPBMREP20