Input

field	value
Query:	SELECT 'Php/7.0.4' 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/7.0.4' 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/7.0.4'::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/7.0.4'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 14 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/7.0.4	gamemeca.com	68878.0	www.gamemeca.com	2023-10-15 03:32:34.049387-07:00	2024-12-23 01:18:56.506825-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	free-powerpoint-templates-design.com	276450.0	free-powerpoint-templates-design.com	2024-03-26 07:47:33.421195-07:00	2024-12-12 07:16:21.835376-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	modoogong.com	288960.0	www.modoogong.com	2023-10-15 12:56:08.871580-07:00	2024-12-08 05:28:00.349266-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	n2ugs.com	345127.0	allstar.n2ugs.com	2024-08-31 23:54:10.590004-07:00	2024-12-11 08:05:13.462601-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	imt-solution.com	402685.0	imt-solution.com	2023-10-15 03:17:14.634254-07:00	2024-12-10 08:17:58.808425-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	rfg3.us	431339.0	rfg3.us	2023-11-19 16:34:21.185393-08:00	2024-10-07 10:12:39.284397-07:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	lenkom.ru	482155.0	lenkom.ru	2023-10-15 08:21:10.286166-07:00	2024-12-05 08:51:15.282514-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	zismo.biz	570224.0	zismo.biz	2023-10-15 09:01:53.128229-07:00	2024-11-15 18:04:57.605955-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	yssolution.co.kr	683462.0	yssolution.co.kr/ko	2024-03-10 22:30:46.558244-07:00	2024-10-03 11:45:00.219986-07:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	v-p.com	996221.0	www.v-p.com	2023-10-16 10:55:43.592847-07:00	2023-12-01 09:21:40.971857-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	hanabang.com	NaN	hanabang.com/shop	2023-10-15 07:31:24.774482-07:00	2024-03-13 13:07:19.686429-07:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	korevalue.com	NaN	korevalue.com	2023-11-09 02:28:04.632164-08:00	2023-11-08 12:00:37.821745-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	edicaodobrasil.com.br	NaN	edicaodobrasil.com.br	2023-11-08 23:57:04.994463-08:00	2023-11-08 13:03:24.268542-08:00	lower(http_request.response_headers) contains 'php/7.0.4'
Php/7.0.4	agrimetal.com.br	NaN	agrimetal.com.br	2023-10-15 09:54:48.857029-07:00	2023-12-27 11:08:40.538838-08:00	lower(http_request.response_headers) contains 'php/7.0.4'