Input

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

Data

Total Results: 74 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/7.1.18	ltd.com	15933.0	ltd.com	2023-10-16 01:13:44.105098-07:00	2023-12-17 00:18:30.279045-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	casinolifemagazine.com	101777.0	www.casinolifemagazine.com	2023-10-15 07:23:59.230442-07:00	2024-12-23 01:22:36.414518-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	iku.edu.tr	118912.0	iku.edu.tr	2023-10-15 04:22:02.051440-07:00	2024-12-11 03:31:34.205156-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	titck.gov.tr	154684.0	titck.gov.tr	2023-10-15 05:02:05.633854-07:00	2024-05-28 10:58:49.522045-07:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	teko.biz	224694.0	teko.biz	2023-10-15 07:30:41.091828-07:00	2024-12-05 03:33:49.983411-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	extremstyle.ua	265820.0	extremstyle.ua/ua	2023-10-15 05:47:51.258628-07:00	2024-12-23 04:09:26.404085-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	republiq.nl	281381.0	republiq.nl	2023-10-15 12:02:15.003245-07:00	2024-03-30 04:57:06.901534-07:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	virastisam.ru	311440.0	virastisam.ru	2023-10-15 13:10:48.338548-07:00	2024-12-05 04:58:39.112255-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	lashworld.ru	333033.0	lashworld.ru	2023-10-15 05:13:33.527187-07:00	2024-12-06 07:57:53.857347-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	autocomtrans.ru	334861.0	autocomtrans.ru	2023-10-15 04:27:05.196680-07:00	2024-12-02 06:11:55.604698-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	theaquariumwiki.com	393888.0	theaquariumwiki.com/wiki/main_page	2023-10-15 05:13:43.353305-07:00	2024-10-09 08:15:57.550947-07:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	souwoo.com	397649.0	souwoo.com	2023-10-15 06:58:15.837787-07:00	2024-12-13 07:33:54.948394-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	optmobex.ru	419360.0	optmobex.ru	2023-10-16 07:12:46.300805-07:00	2024-12-23 07:52:52.569212-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	dkb63.ru	419657.0	dkb63.ru	2023-10-15 13:07:53.630870-07:00	2024-02-23 07:19:28.321868-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	aelita-gold.ru	431208.0	aelita-gold.ru	2023-11-09 02:47:17.691894-08:00	2024-03-05 07:13:34.748261-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	okn-kuzbass.ru	457045.0	okn-kuzbass.ru	2023-12-28 18:39:28.590360-08:00	2024-12-04 09:52:58.888283-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	brain-smart.ru	482290.0	brain-smart.ru	2023-12-08 14:22:51.965363-08:00	2024-12-03 10:44:45.541135-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	molopttorg.su	519160.0	molopttorg.su	2023-10-15 18:02:07.985336-07:00	2024-12-11 12:29:22.647557-08:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	zovbest.ru	552285.0	zovbest.ru	2023-10-15 14:14:14.194185-07:00	2024-10-08 17:36:16.097684-07:00	lower(http_request.response_headers) contains 'php/7.1.18'
Php/7.1.18	rushomeopat.ru	629553.0	rushomeopat.ru	2023-10-15 12:06:59.082409-07:00	2024-10-05 18:19:02.860001-07:00	lower(http_request.response_headers) contains 'php/7.1.18'