Input

field	value
Query:	SELECT 'Php/4.4.7' AS technology_name ,domain ,global_rank ,url_matchable AS url ,created AS first_seen ,last_seen ,CASE WHEN indicator_matchable[2] = 'plain' THEN 'lower(' || indicator_matchable[3] || '.' || indicator_matchable[4] || ') contains ''' || indicator_matchable[1] || '''' ELSE indicator_matchable[3] || '.' || indicator_matchable[4] || ' is regex match of ''' || indicator_matchable[1] || '''' END AS indicator FROM indicator_detection_domain_rollup WHERE (indicator_matchable[1] = 'php/4.4.7' AND indicator_matchable[2] = 'plain' AND indicator_matchable[3] = 'http_request' AND indicator_matchable[4] = 'response_headers') ORDER BY global_rank ASC NULLS LAST

Query Plan

Download: csv json

Query Plan
Limit (cost=3485.21..3486.06 rows=20 width=117)
-> Result (cost=3485.21..3521.68 rows=858 width=117)
-> Sort (cost=3485.21..3487.36 rows=858 width=168)
Sort Key: global_rank
-> Bitmap Heap Scan on indicator_detection_domain_rollup (cost=61.64..3462.38 rows=858 width=168)
Recheck Cond: ((indicator_matchable[1] = 'php/4.4.7'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))
-> Bitmap Index Scan on indicator_detection_domain_rollup_indicator_matchable_arr_idx (cost=0.00..61.43 rows=858 width=0)
Index Cond: ((indicator_matchable[1] = 'php/4.4.7'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 34 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/4.4.7	gmwebsite.com	42335.0	gmwebsite.com/index	2023-10-16 01:46:37.479980-07:00	2024-12-12 02:23:57.127571-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	jjinline.org	107192.0	jjinline.org	2023-10-15 02:41:24.852886-07:00	2024-12-09 01:53:27.487319-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	blueweb.co.kr	107540.0	error.blueweb.co.kr/404	2023-10-15 02:41:22.676770-07:00	2024-12-12 04:10:12.986225-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	nudeandfresh.com	181518.0	nudeandfresh.com	2023-10-15 04:27:21.998414-07:00	2024-12-05 02:46:08.584022-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	theseoultimes.com	217079.0	theseoultimes.com	2023-10-15 04:38:56.994615-07:00	2024-03-14 02:01:36.139502-07:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	autosoft.cz	232818.0	autosoft.cz	2024-01-06 16:31:27.289975-08:00	2024-06-04 18:40:41.445060-07:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	fineartteens.com	293758.0	fineartteens.com	2023-10-15 04:27:03.552131-07:00	2024-12-08 05:26:18.143050-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	mixfiend.com	309009.0	mixfiend.com	2023-10-15 04:34:58.973905-07:00	2024-12-09 05:54:04.823798-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	pushkino.org	328154.0	www.pushkino.org	2023-10-15 08:05:09.248811-07:00	2024-12-11 07:44:33.805033-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	kiy.jp	360980.0	kiy.jp	2023-10-15 06:00:21.324952-07:00	2023-11-01 03:16:59.226775-07:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	mathrainbow.com	378980.0	mathrainbow.com	2023-10-15 04:33:58.669405-07:00	2024-04-14 04:29:46.799975-07:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	izu-kamori.jp	380961.0	izu-kamori.jp	2024-01-16 15:05:07.567066-08:00	2024-09-22 05:41:00.822218-07:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	teenlolly.com	394491.0	teenlolly.com	2023-10-15 12:36:07.578679-07:00	2024-12-13 07:22:47.280416-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	numerousmoney.com	397150.0	numerousmoney.com	2024-01-16 22:21:54.132237-08:00	2024-12-13 07:38:54.455786-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	ufaley.su	409462.0	ufaley.su	2023-10-15 02:42:49.788165-07:00	2023-10-24 00:38:52.682956-07:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	busanopen.org	449459.0	busanopen.org/new/main	2024-08-25 19:37:19.832750-07:00	2024-12-10 09:57:49.244484-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	hcaster.co.kr	465052.0	hcaster.co.kr	2023-12-25 22:18:29.382879-08:00	2024-12-05 07:34:58.344055-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	osijek031.com	470956.0	www.osijek031.com	2023-10-15 08:03:47.093833-07:00	2024-12-13 08:46:27.192304-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	k-yoga.org	481548.0	k-yoga.org	2023-10-15 05:13:33.527187-07:00	2024-12-05 09:09:55.700945-08:00	lower(http_request.response_headers) contains 'php/4.4.7'
Php/4.4.7	chesscorner.com	483298.0	www.chesscorner.com/index	2023-10-15 09:02:58.138954-07:00	2024-03-21 07:43:45.967626-07:00	lower(http_request.response_headers) contains 'php/4.4.7'