Input

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

Data

Total Results: 46 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Slt-mid	lanzoui.com	15069.0	lanzoui.com	2023-10-16 02:41:01.001125-07:00	2024-04-28 01:10:49.144449-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	lanzouw.com	23347.0	lanzouw.com	2023-10-16 01:29:45.222754-07:00	2024-04-29 01:24:55.549474-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	lanzout.com	29594.0	lanzout.com	2023-10-16 01:46:37.479980-07:00	2024-04-27 01:09:35.633751-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	lanzouq.com	40706.0	lanzouq.com	2023-10-15 03:37:26.095069-07:00	2024-04-27 01:49:05.962488-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	lanzoup.com	56689.0	lanzoup.com	2023-10-16 02:41:51.082152-07:00	2024-04-28 02:09:22.748787-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	lanzouv.com	58535.0	lanzouv.com	2023-10-15 03:32:54.049990-07:00	2024-04-27 02:30:00.481283-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	yuntue.com	60731.0	yuntue.com	2023-10-16 01:46:37.479980-07:00	2024-01-21 00:28:26.504039-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	lanzouy.com	63239.0	lanzouy.com	2023-10-16 01:56:02.570067-07:00	2024-04-27 01:22:05.492216-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	okooo.com	90771.0	www.okooo.com	2024-01-05 11:13:41.007179-08:00	2024-01-05 02:04:07.880934-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	idcsmart.com	107224.0	www.idcsmart.com	2023-12-05 19:19:29.658489-08:00	2024-05-24 06:18:55.254129-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	gao7.com	154565.0	www.gao7.com	2023-10-15 04:21:06.096233-07:00	2024-09-11 04:39:17.854619-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	weaver.com.cn	321076.0	www.weaver.com.cn	2024-05-28 15:33:31.277125-07:00	2024-12-11 07:13:47.334166-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	zjlr.cn	367729.0	www.zjlr.cn	2023-10-15 03:41:06.019592-07:00	2024-12-23 05:18:09.155026-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	whylzy.com	429744.0	www.whylzy.com	2023-10-16 03:10:45.140920-07:00	2024-12-08 07:44:12.148454-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	54dr.org.cn	465413.0	www.54dr.org.cn	2023-10-15 04:26:58.338739-07:00	2023-10-30 02:27:13.501424-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	haodonglaw.com	471856.0	www.haodonglaw.com	2023-10-15 05:12:49.722558-07:00	2023-10-29 03:13:13.076471-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	dehong.com.cn	478798.0	www.dehong.com.cn	2023-10-15 05:13:27.976349-07:00	2023-12-16 03:49:16.464926-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	ppcn.net	535072.0	www.ppcn.net	2023-12-14 19:18:19.565827-08:00	2024-10-04 13:08:41.187741-07:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	010lf.com	698675.0	www.010lf.com	2024-08-25 17:33:37.893416-07:00	2024-12-03 15:18:44.136139-08:00	lower(http_request.response_headers) contains 'slt-mid'
Slt-mid	yilianmeiti.com	746265.0	www.yilianmeiti.com	2023-10-15 06:00:21.324952-07:00	2024-10-05 19:16:20.589504-07:00	lower(http_request.response_headers) contains 'slt-mid'