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 (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 (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 (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
6437CARTHEDDR20
6438CARTHEDDR20
6440CARTHEDDR20
6441CARTHEDDR20
6465CARTHEDDR20
6466CARTHEDDR20
6467CARTHEDDR20
6468CARTHEDDR20
6282CODEDDR20
6283CODEDDR20
6284CODEDDR20
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
6439CODEDDR20
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
6388CODEMREP20
6389CODEMREP20
6390CODEMREP20
6391CODEMREP20
6392CODEMREP20
6393CODEMREP20
6394CODEMREP20
6395CODEMREP20
6397CODEMREP20
6398CODEMREP20
6399CODEMREP20
6400CODEMREP20
6461CODEMREP20
6462CODEMREP20
6387DWSMREP20
6406DWSMREP20
6442PARCMREP20
6443PARCMREP20
6444PARCMREP20
6446PARCMREP20
6447PARCMREP20
6448PARCMREP20
6451PARCMREP20
6452PARCMREP20
6453PARCMREP20
6455PARCMREP20
6456PARCMREP20
6457PARCMREP20
6458PARCMREP20
6459PARCMREP20
6460PARCMREP20
6375SVPMREP20
6376SVPMREP20
6377SVPMREP20
6378SVPMREP20
6379SVPMREP20
6380SVPMREP20
6381SVPMREP20
6382SVPMREP20
6401SVPMREP20
6402SVPMREP20
6403SVPMREP20
6404SVPMREP20
6405SVPMREP20
6383SVPBMREP20
6384SVPBMREP20
6385SVPBMREP20
6386SVPBMREP20