Input

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

Data

Total Results: 24 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Challenger	adobe.com	23.0	stock.adobe.com/de	2024-03-18 05:02:16.568495-07:00	2024-04-03 00:05:23.549898-07:00	lower(http_request.response_headers) contains 'challenger'
Challenger	shopify.com	112.0	www.shopify.com	2023-11-02 01:50:48.562066-07:00	2023-11-07 00:08:37.659704-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	sportskeeda.com	3209.0	www.sportskeeda.com	2024-08-30 01:54:29.531449-07:00	2024-09-11 00:24:10.567538-07:00	lower(http_request.response_headers) contains 'challenger'
Challenger	denverlibrary.org	31151.0	www.denverlibrary.org	2023-10-16 01:46:37.479980-07:00	2024-12-12 01:52:23.844596-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	the-challenger.ru	33067.0	the-challenger.ru	2024-04-08 06:54:15.648344-07:00	2024-04-08 00:31:53.793778-07:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengergray.com	44606.0	www.challengergray.com	2023-10-16 02:15:30.711992-07:00	2024-12-12 02:26:32.833140-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	ukmeds.co.uk	147245.0	www.ukmeds.co.uk	2023-10-15 03:35:14.855042-07:00	2023-11-09 01:41:39.254180-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	goforward.com	164539.0	goforward.com	2023-10-17 13:19:01.373340-07:00	2023-12-14 01:53:19.156492-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challenger.org	238573.0	challenger.org	2023-10-15 05:13:14.891811-07:00	2024-12-13 04:34:19.341708-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengertalk.com	243082.0	www.challengertalk.com	2023-10-15 04:38:49.295742-07:00	2023-10-30 01:51:53.658370-07:00	lower(http_request.response_headers) contains 'challenger'
Challenger	hubbe.net	258015.0	hubbe.net	2023-10-15 05:27:27.239983-07:00	2024-11-30 04:41:48.410428-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	royalchallengers.com	269966.0	royalchallengers.com	2023-10-15 05:47:56.621218-07:00	2024-12-23 04:26:22.304602-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	theweeklychallenger.com	300432.0	theweeklychallenger.com	2023-10-15 05:41:25.020478-07:00	2024-12-09 05:14:44.806131-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengersports.com	345742.0	challengersports.com	2023-10-15 06:00:34.321652-07:00	2024-12-11 07:59:58.885827-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengerbreadware.com	411313.0	challengerbreadware.com	2023-10-15 15:40:23.183312-07:00	2024-12-23 07:26:40.405804-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengerinc.com	450203.0	challengerinc.com	2023-10-15 08:06:50.226103-07:00	2024-12-05 08:09:56.269696-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengerforumz.com	586323.0	www.challengerforumz.com	2023-10-15 09:53:27.878633-07:00	2023-10-25 07:53:47.280238-07:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challengerschool.com	600507.0	www.challengerschool.com	2023-10-15 09:01:53.128229-07:00	2024-12-12 14:32:30.598935-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challenger.com.au	638455.0	www.challenger.com.au	2024-11-27 21:36:10.359173-08:00	2024-12-13 12:41:41.713854-08:00	lower(http_request.response_headers) contains 'challenger'
Challenger	challenger.sg	667122.0	challenger.sg	2023-10-15 10:37:34.718337-07:00	2023-10-16 07:56:35.034561-07:00	lower(http_request.response_headers) contains 'challenger'