Input

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

Data

Total Results: 440 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.2.6-1+lenny13	lr21.com.uy	70241.0	lr21.com.uy	2023-10-15 09:41:30.298350+00:00	2024-12-13 01:37:49.024068-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	nanometer.ru	103284.0	www.nanometer.ru	2023-10-16 09:12:51.151783+00:00	2024-10-05 02:21:20.388754-07:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	riegl.com	284747.0	riegl.com	2023-10-15 12:48:39.564392+00:00	2024-12-07 05:16:00.012654-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	lada-largus.com	290249.0	www.lada-largus.com	2023-10-15 11:22:13.186492+00:00	2024-12-08 05:24:17.808622-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	autoprospect.ru	334915.0	www.autoprospect.ru	2023-10-15 14:23:31.797521+00:00	2024-12-01 06:19:58.161505-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	japanforum.com	350536.0	japanforum.com	2023-10-15 11:22:24.814578+00:00	2024-05-02 06:51:43.806413-07:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	hyundai-solaris.com	376887.0	www.hyundai-solaris.com	2023-10-15 11:38:46.862772+00:00	2024-12-12 09:48:41.602912-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	bmwg.de	627358.0	bmwg.de	2023-10-15 16:02:18.480805+00:00	2024-12-05 08:27:15.862032-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	iabi.de	629444.0	iabi.de	2023-10-15 18:20:53.513228+00:00	2024-08-25 17:24:30.907201-07:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	iabr.de	639174.0	iabr.de	2023-10-15 18:41:32.912490+00:00	2024-12-13 12:30:49.259110-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	anep.de	664873.0	anep.de	2023-10-15 16:00:00.221041+00:00	2024-12-12 11:42:31.546781-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	bmdv.de	674384.0	bmdv.de	2023-10-15 16:02:42.876742+00:00	2024-12-13 12:40:36.803686-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	dnvp.de	680949.0	dnvp.de	2023-10-15 16:04:02.391534+00:00	2024-12-12 11:57:42.790445-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	arrp.de	684331.0	arrp.de	2023-10-15 16:00:00.221041+00:00	2024-12-12 12:30:38.761524-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	arsp.de	684332.0	arsp.de	2023-10-15 16:00:00.221041+00:00	2024-12-12 12:30:50.679911-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	aawo.de	687685.0	aawo.de	2023-10-15 16:00:00.221041+00:00	2024-12-03 10:43:55.816420-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	ardp.de	687691.0	ardp.de	2023-10-15 16:01:06.838291+00:00	2024-12-03 10:28:46.184506-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	awbe.de	687694.0	awbe.de	2023-10-15 16:00:00.221041+00:00	2024-11-18 14:18:24.613884-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	bhip.de	687698.0	bhip.de	2023-10-15 16:04:02.391534+00:00	2024-12-03 10:32:18.701221-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'
Php/5.2.6-1+lenny13	bglr.de	687714.0	bglr.de	2023-10-15 16:04:58.115248+00:00	2024-12-03 10:48:08.685611-08:00	lower(http_request.response_headers) contains 'php/5.2.6-1+lenny13'