Input

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

Data

Total Results: 11 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.3.10-2	rosieanimaladoption.ca	64326.0	rosieanimaladoption.ca	2023-10-15 03:17:04.380258-07:00	2024-12-23 01:07:01.377374-08:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	anilosclips.com	138786.0	anilosclips.com	2023-10-16 02:16:12.231736-07:00	2024-03-12 01:14:39.267548-07:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	youngertube.com	140224.0	youngertube.com	2023-10-15 03:17:11.749172-07:00	2024-03-18 01:01:56.512196-07:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	anilosmilftube.com	272552.0	anilosmilftube.com	2023-10-15 04:38:56.994615-07:00	2024-03-11 02:24:42.891966-07:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	siburo.ru	475118.0	siburo.ru	2024-10-05 19:47:59.200905-07:00	2024-12-13 08:51:08.581149-08:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	cutielist.com	735387.0	cutielist.com	2023-12-28 18:39:28.590360-08:00	2024-02-15 09:38:02.540069-08:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	myamateursite.net	736669.0	myamateursite.net	2024-02-26 21:43:19.976111-08:00	2024-02-26 13:17:02.283664-08:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	boomerthumbs.com	826446.0	boomerthumbs.com	2023-12-26 17:10:15.100260-08:00	2024-03-10 08:05:31.189795-07:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	yourpornconnection.com	NaN	yourpornconnection.com	2024-03-13 18:10:01.842127-07:00	2024-03-13 13:56:39.103644-07:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	dreamygirls.com	NaN	dreamygirls.com	2024-01-06 17:17:02.879780-08:00	2024-03-20 11:48:44.326523-07:00	lower(http_request.response_headers) contains 'php/5.3.10-2'
Php/5.3.10-2	nndreams.com	NaN	nndreams.com	2023-10-15 09:04:30.300811-07:00	2024-02-16 15:21:52.549246-08:00	lower(http_request.response_headers) contains 'php/5.3.10-2'