Input

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

Data

Total Results: 133 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Mpoplay v2.0	lexus234a.com	66679.0	lexus234a.com	2024-08-21 09:11:08.623377-07:00	2024-11-23 03:20:00.084333-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	lexus234b.com	67165.0	lexus234b.com	2024-11-25 19:25:09.649719-08:00	2024-11-28 02:33:22.295488-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	mpo777best.com	72941.0	mpo777best.com	2024-11-24 21:06:55.654000-08:00	2024-11-24 10:35:45.509385-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	bukumalaysia.com	101142.0	bukumalaysia.com	2024-11-29 12:55:31.525574-08:00	2024-12-23 01:28:05.201712-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	ohioriverradio.org	120238.0	ohioriverradio.org	2024-11-29 13:21:28.263706-08:00	2024-11-30 02:25:58.027736-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	codingforums.com	128900.0	www.codingforums.com	2023-11-10 05:08:10.878057-08:00	2023-12-05 00:21:05.929073-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	files-upload.com	133462.0	files-upload.com	2024-11-26 20:23:56.968491-08:00	2024-11-30 04:14:28.651778-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	cmsimple.name	148048.0	cmsimple.name	2024-12-05 05:22:59.710299-08:00	2024-12-12 04:43:16.686498-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	newdealstudios.com	216404.0	www.newdealstudios.com	2024-09-16 08:38:33.500434-07:00	2024-09-19 04:01:47.554181-07:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	hosteleriasevilla.com	243174.0	hosteleriasevilla.com	2024-08-29 12:52:04.225649-07:00	2024-12-11 05:38:34.943327-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	survivingprogress.com	249547.0	survivingprogress.com	2024-10-01 04:56:08.048645-07:00	2024-10-06 12:58:24.899495-07:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	777ma.net	277926.0	777ma.net	2024-09-18 08:47:35.691892-07:00	2024-12-12 07:21:50.127325-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	cantyouseeimbusy.com	295710.0	cantyouseeimbusy.com	2023-10-25 14:27:11.733820-07:00	2023-11-15 03:13:55.448591-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	japanesenintendo.com	303224.0	www.japanesenintendo.com	2023-10-28 10:01:45.259388-07:00	2023-10-31 03:53:26.601741-07:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	qqslotwish.com	341912.0	qqslotwish.com	2024-09-19 14:52:37.869852-07:00	2024-09-21 04:02:47.844838-07:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	lexus234b.net	341925.0	lexus234b.net	2024-11-30 00:35:24.001765-08:00	2024-12-03 02:01:00.488652-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	gameagonline.com	350431.0	gameagonline.com	2024-11-28 11:14:28.201765-08:00	2024-12-03 06:36:05.375506-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	just-ping.com	367668.0	just-ping.com	2023-11-10 15:03:35.033895-08:00	2023-12-12 02:24:32.219726-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	okeslot.com	393583.0	okeslot.com	2024-04-10 18:09:16.172762-07:00	2024-12-13 07:22:55.280840-08:00	lower(http_request.response_headers) contains 'mpoplay v2.0'
Mpoplay v2.0	programminghorizon.com	414889.0	programminghorizon.com	2024-02-23 05:11:46.610642-08:00	2024-05-02 06:16:35.174891-07:00	lower(http_request.response_headers) contains 'mpoplay v2.0'