SGNET Query Results

Query summary

Selected options: date, path, code_injection

Grouped options: date, country

Rate threshold: 3

---

SELECT count(distinct(source.source_id)) AS nbs, floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1) AS Date_, info_source_maxmind.country AS Country FROM source,tiny_session,scriptgen_session,path,injection_attack,info_source_maxmind WHERE tiny_session.source_id=source.source_id AND tiny_session.begin_at>to_date('19-MAR-8') AND tiny_session.begin_at<to_date('31-MAR-8') AND scriptgen_session.tiny_session_id=tiny_session.tiny_session_id AND scriptgen_session.path_id=path.path_id AND (scriptgen_session.path_id='1050') AND injection_attack.session_id=scriptgen_session.session_id AND scriptgen_session.type='SG' AND info_source_maxmind.source_id=source.source_id GROUP BY floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1), info_source_maxmind.country ORDER BY floor((cast(tiny_session.begin_at as date)-to_date('19-MAR-8'))/1), count(distinct(source.source_id)) DESC

23,Mar-2008 -> 24,Mar-2008(3)

Country	Number of sources
DE	20
FR	9
TR	7
ES	1
CZ	1
Others	1

24,Mar-2008 -> 25,Mar-2008(4)

Country	Number of sources
DE	35
FR	10
TR	8
ES	3
US	2
HR	1
CZ	1
PL	1
	1
AT	1
Others	5

25,Mar-2008 -> 26,Mar-2008(5)

Country	Number of sources
DE	54
FR	15
TR	2
ES	6
HR	2
CZ	2
PL	2
	1
AT	1
Others	4

26,Mar-2008 -> 27,Mar-2008(6)

Country	Number of sources
DE	33
FR	4
TR	3
ES	1
PL	1
	2
AT	2
Others	2

27,Mar-2008 -> 28,Mar-2008(7)

Country	Number of sources
DE	16
FR	3
	1
Others	2

28,Mar-2008 -> 29,Mar-2008(8)

Country	Number of sources
DE	11
FR	1
TR	1
HR	1
Others	1

29,Mar-2008 -> 30,Mar-2008(9)

Country	Number of sources
DE	1
Others