http://maos.inogs.it/stat/drifter_stat2_bis.php quante trasmissioni al giorno Query usata: SELECT distinct d.id_drifter 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 true and p.name='DDR20' ;
----------------------trovati 114

----------------------trovati

str_where calculated riga 50: id_drifter IN (6311,6330,6332,6321,6308,6432,6413,6325,6284,6326,6410,6305,6430,6301,6328,6342,6412,6303,6374,6288,6313,6338,6300,6291,6428,6417,6366,6307,6322,6409,6315,6414,6314,6373,6425,6293,6290,6296,6371,6437,6298,6354,6419,6327,6292,6369,6467,6340,6466,6422,6289,6431,6297,6368,6407,6465,6312,6355,6420,6336,6349,6316,6317,6439,6318,6427,6353,6306,6323,6356,6418,6335,6302,6426,6441,6370,6415,6341,6345,6282,6367,6372,6440,6331,6347,6408,6294,6324,6348,6283,6319,6423,6468,6304,6295,6286,6365,6357,6299,6334,6350,6343,6333,6309,6411,6337,6438,6310,6421,6351,6429,6287,6320,6424)


str_where calculated riga 65: id_drifter IN (6311,6330,6332,6321,6308,6432,6413,6325,6284,6326,6410,6305,6430,6301,6328,6342,6412,6303,6374,6288,6313,6338,6300,6291,6428,6417,6366,6307,6322,6409,6315,6414,6314,6373,6425,6293,6290,6296,6371,6437,6298,6354,6419,6327,6292,6369,6467,6340,6466,6422,6289,6431,6297,6368,6407,6465,6312,6355,6420,6336,6349,6316,6317,6439,6318,6427,6353,6306,6323,6356,6418,6335,6302,6426,6441,6370,6415,6341,6345,6282,6367,6372,6440,6331,6347,6408,6294,6324,6348,6283,6319,6423,6468,6304,6295,6286,6365,6357,6299,6334,6350,6343,6333,6309,6411,6337,6438,6310,6421,6351,6429,6287,6320,6424)
SELECT Count(id_drifter) AS quanti, to_char(tempo, 'YYYY-MM-DD') AS annomese FROM tbl_drifter_ril WHERE id_drifter IN (6311,6330,6332,6321,6308,6432,6413,6325,6284,6326,6410,6305,6430,6301,6328,6342,6412,6303,6374,6288,6313,6338,6300,6291,6428,6417,6366,6307,6322,6409,6315,6414,6314,6373,6425,6293,6290,6296,6371,6437,6298,6354,6419,6327,6292,6369,6467,6340,6466,6422,6289,6431,6297,6368,6407,6465,6312,6355,6420,6336,6349,6316,6317,6439,6318,6427,6353,6306,6323,6356,6418,6335,6302,6426,6441,6370,6415,6341,6345,6282,6367,6372,6440,6331,6347,6408,6294,6324,6348,6283,6319,6423,6468,6304,6295,6286,6365,6357,6299,6334,6350,6343,6333,6309,6411,6337,6438,6310,6421,6351,6429,6287,6320,6424) GROUP BY annomese ORDER BY annomese;

Full data not grouped
SELECT Count(id_drifter) AS quanti, to_char(tempo, 'YYYY-MM-DD') AS annomese FROM tbl_drifter_ril WHERE id_drifter IN (6311,6330,6332,6321,6308,6432,6413,6325,6284,6326,6410,6305,6430,6301,6328,6342,6412,6303,6374,6288,6313,6338,6300,6291,6428,6417,6366,6307,6322,6409,6315,6414,6314,6373,6425,6293,6290,6296,6371,6437,6298,6354,6419,6327,6292,6369,6467,6340,6466,6422,6289,6431,6297,6368,6407,6465,6312,6355,6420,6336,6349,6316,6317,6439,6318,6427,6353,6306,6323,6356,6418,6335,6302,6426,6441,6370,6415,6341,6345,6282,6367,6372,6440,6331,6347,6408,6294,6324,6348,6283,6319,6423,6468,6304,6295,6286,6365,6357,6299,6334,6350,6343,6333,6309,6411,6337,6438,6310,6421,6351,6429,6287,6320,6424) GROUP BY annomese ORDER BY annomese;

conteggio id per gggiorno
124462020-10-08
276452020-10-09
259582020-10-10
212012020-10-11
202992020-10-12
207852020-10-13
201062020-10-14
197492020-10-15
182212020-10-16
174182020-10-17
167332020-10-18
143012020-10-19
159932020-10-20
152052020-10-21
138782020-10-22
129162020-10-23
91642020-10-24
87862020-10-25
81622020-10-26
70162020-10-27
72042020-10-28
66562020-10-29
52232020-10-30
50302020-10-31
55232020-11-01
53152020-11-02
48542020-11-03
47612020-11-04
48802020-11-05
49632020-11-06
52672020-11-07
54612020-11-08
51162020-11-09
45552020-11-10
48292020-11-11
45742020-11-12
38592020-11-13
37042020-11-14
37902020-11-15
36972020-11-16
33452020-11-17
29352020-11-18
30882020-11-19
27802020-11-20
24322020-11-21
22212020-11-22
20342020-11-23
18572020-11-24
17622020-11-25
15112020-11-26
13822020-11-27
13822020-11-28
11272020-11-29
8242020-11-30
9802020-12-01
9752020-12-02
6892020-12-03
5552020-12-04
5582020-12-05
4382020-12-06
3442020-12-07
3432020-12-08
3552020-12-09
2962020-12-10
2832020-12-11
3282020-12-12
3732020-12-13
4212020-12-14
3632020-12-15
3892020-12-16
3572020-12-17
3382020-12-18
3232020-12-19
2802020-12-20
3112020-12-21
2852020-12-22
3642020-12-23
3302020-12-24
2652020-12-25
2152020-12-26
2342020-12-27
2082020-12-28
2112020-12-29
2072020-12-30
1882020-12-31
1992021-01-01
2162021-01-02
2042021-01-03
1852021-01-04
2102021-01-05
2732021-01-06
1872021-01-07
2092021-01-08
2192021-01-09
2412021-01-10
1802021-01-11
1602021-01-12
2092021-01-13
1152021-01-14
1102021-01-15
762021-01-16
922021-01-17
372021-01-18
262021-01-19
672021-01-20
1152021-01-21
932021-01-22
72021-01-23
272021-07-05