Technologies

Domains

Query

Blog

About

Query

Schema

Run A Query

Input

field	value
Query:	SELECT 'Php/5.2.10-2ubuntu6' 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.10-2ubuntu6' 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 Result

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.10-2ubuntu6'::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.10-2ubuntu6'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Query Result

Data

Total Results: 16 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.2.10-2ubuntu6	ipron.com	109405.0	www.ipron.com	2023-10-15 03:32:54.049990-07:00	2024-12-23 01:49:37.346617-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	redrocker.com	144083.0	www.redrocker.com	2023-10-15 04:27:30.870060-07:00	2024-12-12 04:22:49.840275-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	dermtv.com	254663.0	dermtv.com	2023-10-15 05:48:58.677213-07:00	2024-12-23 03:51:29.652127-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	chickenfoot.us	363568.0	www.chickenfoot.us	2023-10-15 06:38:04.829080-07:00	2024-12-13 06:19:41.754642-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	easydatacontrol.com	375640.0	secure.easydatacontrol.com/login	2023-10-15 07:01:15.228834-07:00	2024-01-15 03:28:03.746301-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	shelflifeadvice.com	451519.0	shelflifeadvice.com	2023-10-15 10:57:56.742452-07:00	2024-12-06 10:51:29.392490-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	webuje.com	508023.0	webuje.com	2024-04-17 00:44:15.301618-07:00	2024-12-08 09:52:12.592983-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	oedilf.com	656342.0	www.oedilf.com/db/lim	2023-10-15 10:46:14.920796-07:00	2024-12-09 12:39:34.648744-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	badenpage.de	783815.0	www.badenpage.de	2023-10-15 12:01:59.762005-07:00	2024-03-12 11:54:30.875555-07:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	kiss.com.tw	832467.0	www.kiss.com.tw	2023-10-15 10:24:23.754729-07:00	2024-02-11 12:44:54.695941-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	koshki-mishki.ru	856864.0	koshki-mishki.ru	2023-10-17 14:00:13.761591-07:00	2024-08-30 18:18:46.718592-07:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	cableguy.com	893699.0	cableguy.com	2024-02-04 20:59:31.034998-08:00	2024-03-12 11:30:21.202825-07:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	baiyangfoundation.org	NaN	baiyangfoundation.org/index	2023-10-16 04:21:25.282561-07:00	2024-03-14 08:09:05.085987-07:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	startautosbolt.hu	NaN	startautosbolt.hu	2024-08-30 16:44:00.180149-07:00	2024-12-13 12:04:52.294597-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	galeondemanila.org	NaN	galeondemanila.org	2024-01-23 18:38:01.114551-08:00	2024-01-31 16:26:07.371766-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'
Php/5.2.10-2ubuntu6	techwr-l.com	NaN	www.techwr-l.com	2023-10-15 13:07:53.630870-07:00	2024-02-18 19:01:08.910077-08:00	lower(http_request.response_headers) contains 'php/5.2.10-2ubuntu6'