Input

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

Data

Total Results: 77 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/8.0.24	warthunder.com	10043.0	warthunder.com/us	2023-10-16 02:41:01.001125-07:00	2024-09-19 00:28:03.551971-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	cnmo.com	16503.0	www.cnmo.com	2023-10-16 02:41:01.001125-07:00	2024-11-18 01:06:11.615045-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	minecraftforge.net	35517.0	forums.minecraftforge.net	2023-10-16 01:52:22.919205-07:00	2024-01-28 01:56:30.362326-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	skycoach.gg	71127.0	skycoach.gg	2023-11-17 19:50:21.126932-08:00	2024-02-04 01:49:31.345054-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	ulpressa.ru	97342.0	ulpressa.ru	2023-10-18 02:18:44.834538-07:00	2024-12-07 02:19:53.591848-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	imgrum.net	99446.0	imgrum.net	2023-10-15 03:32:34.049387-07:00	2024-04-19 00:54:47.555036-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	warthunder.ru	128788.0	warthunder.ru/ru	2023-10-21 15:41:24.891041-07:00	2024-03-19 01:26:46.684407-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	ucll.be	135025.0	www.ucll.be/nl	2023-10-15 04:22:17.506069-07:00	2024-01-04 01:53:25.302284-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	sweetlovemessages.com	150074.0	sweetlovemessages.com	2023-10-18 03:01:06.459978-07:00	2024-04-14 05:30:29.312035-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	kedah.gov.my	154661.0	www.kedah.gov.my	2023-10-15 04:27:28.590402-07:00	2024-12-06 03:43:50.435829-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	disneyadvertising.com	156835.0	www.disneyadvertising.com	2023-10-15 04:27:30.870060-07:00	2024-08-29 04:31:24.176654-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	m-x.com.mx	195439.0	m-x.com.mx	2024-02-26 07:05:52.877196-08:00	2024-03-31 02:32:30.695309-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	live555.com	219710.0	live555.com	2023-10-15 04:27:08.356351-07:00	2024-01-22 02:57:41.993778-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	gaijinent.com	228018.0	gaijinent.com	2023-10-15 05:13:19.426909-07:00	2024-12-05 03:47:46.346171-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	casino.help	247807.0	casino.help	2023-10-15 11:42:06.382266-07:00	2023-12-20 08:43:40.008844-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	themepul.com	268496.0	themepul.com	2023-10-15 08:12:37.841376-07:00	2023-11-05 04:07:33.623478-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	desdelafe.mx	287994.0	desdelafe.mx	2023-10-15 05:47:56.621218-07:00	2024-03-28 04:48:45.366531-07:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	star-conflict.com	298724.0	star-conflict.com	2023-10-15 04:47:19.627870-07:00	2024-12-08 05:40:28.549523-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	jorno.ru	308228.0	jorno.ru	2024-02-08 19:29:25.279930-08:00	2024-02-20 10:39:39.820189-08:00	lower(http_request.response_headers) contains 'php/8.0.24'
Php/8.0.24	vesynn.ru	327038.0	www.vesynn.ru	2023-10-15 11:05:03.549661-07:00	2024-01-16 09:48:02.436765-08:00	lower(http_request.response_headers) contains 'php/8.0.24'