Input

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

Data

Total Results: 9 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Best team in the	sozialversicherung.at	56084.0	www.sozialversicherung.at/cdscontent	2023-10-15 09:41:31.500275+00:00	2024-12-23 00:59:53.484019-08:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	gesundheitskasse.at	57053.0	www.gesundheitskasse.at/cdscontent	2023-10-15 09:42:49.788165+00:00	2024-12-23 01:09:59.139859-08:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	auva.at	110102.0	www.auva.at/cdscontent	2023-10-21 23:57:17.333182+00:00	2024-04-30 03:09:44.432453-07:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	svs.at	134297.0	www.svs.at/cdscontent	2023-10-15 11:22:08.867162+00:00	2024-12-12 04:10:21.081546-08:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	pv.at	259391.0	www.pv.at/cdscontent	2023-10-15 12:41:25.020478+00:00	2024-06-08 09:27:07.587943-07:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	bvaeb.at	456204.0	www.bvaeb.at/cdscontent	2023-10-15 15:30:36.022432+00:00	2024-12-04 09:34:15.677646-08:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	chipkarte.at	565808.0	www.chipkarte.at/cdscontent	2023-10-15 17:06:10.824926+00:00	2024-12-13 11:04:05.642412-08:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	elda.at	831667.0	www.elda.at/cdscontent	2023-10-15 19:56:08.871580+00:00	2024-12-02 19:42:23.954844-08:00	lower(http_request.response_headers) contains 'best team in the'
Best team in the	meinegesundheit.at	NaN	www.meinegesundheit.at/cdscontent	2023-10-15 20:42:27.177673+00:00	2024-02-26 11:17:47.748036-08:00	lower(http_request.response_headers) contains 'best team in the'