Input

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

Data

Total Results: 176 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/8.0.26	nano.gov	39966.0	www.nano.gov	2023-10-16 02:15:30.711992-07:00	2024-04-26 01:42:39.697929-07:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	flightsafety.org	42333.0	flightsafety.org	2023-10-15 02:42:47.299365-07:00	2023-10-29 00:37:05.875081-07:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	reasonstobecheerful.world	48633.0	reasonstobecheerful.world	2023-10-16 02:41:51.082152-07:00	2023-11-25 00:18:45.742208-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	altaro.com	58296.0	www.altaro.com	2023-10-16 02:44:01.481699-07:00	2023-12-03 00:32:23.719760-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	capturetheatlas.com	62664.0	capturetheatlas.com	2024-01-18 05:34:09.606322-08:00	2024-12-23 00:58:17.775319-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	cleanup.jp	75631.0	cleanup.jp	2023-10-15 03:17:13.879097-07:00	2024-12-13 01:49:06.042343-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	umsida.ac.id	87869.0	umsida.ac.id	2023-10-15 02:42:49.788165-07:00	2024-12-23 01:31:07.908945-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	ims.com.br	96092.0	ims.com.br	2023-10-15 03:32:56.731483-07:00	2023-11-06 00:57:06.081437-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	packhelp.com	117009.0	packhelp.com	2023-10-15 03:17:13.879097-07:00	2024-12-11 03:24:06.952383-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	smartmarineguide.com	117261.0	www.smartmarineguide.com	2023-10-15 03:34:10.690011-07:00	2024-12-11 03:31:29.513787-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	smartmotorguide.com	123797.0	www.smartmotorguide.com	2023-10-15 03:17:08.417916-07:00	2024-12-05 02:16:29.790848-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	staysure.co.uk	124156.0	www.staysure.co.uk	2023-10-15 03:35:14.855042-07:00	2024-11-25 03:01:01.381809-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	dcplogy.kz	127057.0	dcplogy.kz	2024-11-19 19:59:33.521008-08:00	2024-11-30 02:09:32.429951-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	xn--d1avfbwl.xn--p1ai	128096.0	xn--d1avfbwl.xn--p1ai	2024-11-19 19:59:33.521008-08:00	2024-12-02 02:53:10.920365-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	xn----7sbfkcavqhv4bi.xn--p1ai	128830.0	xn----7sbfkcavqhv4bi.xn--p1ai	2024-11-19 19:59:33.521008-08:00	2024-12-02 02:43:33.178555-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	lourdes.edu	130148.0	lourdes.edu	2024-03-14 17:54:06.398539-07:00	2024-12-12 04:09:42.173810-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	dverivz.ru	137686.0	dverivz.ru	2024-04-12 23:29:08.810448-07:00	2024-12-23 07:28:04.414021-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	nur-sultankenes.kz	140832.0	nur-sultankenes.kz	2024-11-16 12:48:24.810810-08:00	2024-12-12 04:15:07.851548-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	kungur-school12.ru	141137.0	kungur-school12.ru	2024-11-16 12:23:13.971330-08:00	2024-12-12 04:14:28.458390-08:00	lower(http_request.response_headers) contains 'php/8.0.26'
Php/8.0.26	qyzylorda-csb.kz	142062.0	qyzylorda-csb.kz	2024-11-25 18:48:27.379168-08:00	2024-12-12 04:10:43.211245-08:00	lower(http_request.response_headers) contains 'php/8.0.26'