Input

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

Data

Total Results: 57 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Bitrix24.sites	ekipirovka.shop	66213.0	ekipirovka.shop	2024-03-02 19:40:48.815685-08:00	2024-07-07 17:10:46.688859-07:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	myfeelix.de	122143.0	myfeelix.de	2023-10-15 10:57:34.903880-07:00	2024-11-13 04:12:57.431613-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	ushakamarineworld.co.za	406412.0	ushakamarineworld.co.za	2023-11-02 20:38:45.565969-07:00	2023-11-02 04:20:12.104416-07:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	bestrank.ru	428047.0	bestrank.ru	2023-10-15 15:14:32.292737-07:00	2024-12-05 07:51:47.931563-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	qm-s.com	438752.0	qm-s.com	2023-10-16 04:47:42.120641-07:00	2024-12-23 08:07:21.736202-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	ec89.ru	452086.0	ec89.ru	2023-11-09 04:00:28.956572-08:00	2024-12-04 09:30:29.286388-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	intermarkrelocation.ru	463427.0	intermarkrelocation.ru	2023-10-15 06:20:34.009280-07:00	2024-12-09 08:10:14.979671-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	bejet.ru	478836.0	bejet.ru	2023-10-15 10:03:58.331780-07:00	2024-12-13 09:09:54.878912-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	axiom24.ru	482313.0	axiom24.ru	2023-10-15 08:30:53.537657-07:00	2024-12-05 08:41:10.101042-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	nailmarket.pro	547963.0	nailmarket.pro	2024-12-06 22:30:33.832492-08:00	2024-12-12 13:51:11.834498-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	htg.ru	573633.0	htg.ru	2024-12-06 22:52:43.361038-08:00	2024-12-07 11:00:50.637647-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	webpay.by	591829.0	webpay.by	2023-10-15 09:04:02.391534-07:00	2024-12-09 11:47:15.713394-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	gefera.ru	592812.0	gefera.ru	2023-11-21 22:35:49.050493-08:00	2024-10-08 15:56:54.364612-07:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	sozdavatel.ru	610172.0	sozdavatel.ru	2024-08-20 22:39:31.589066-07:00	2024-12-09 11:44:12.333669-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	volgamarine.com	688292.0	volgamarine.com	2023-10-15 09:02:42.876742-07:00	2024-03-29 08:13:17.877032-07:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	kaz-engineering.kz	747900.0	kaz-engineering.kz	2024-05-28 22:02:10.171551-07:00	2024-09-24 10:45:48.737029-07:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	dkomi.ru	850158.0	dkomi.ru	2023-10-15 04:27:33.526375-07:00	2024-09-16 12:08:20.225237-07:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	net-52.ru	970431.0	net-52.ru	2024-08-20 15:36:46.142381-07:00	2024-11-18 14:52:40.340139-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	skyfish.ru	986161.0	skyfish.ru	2023-10-15 15:14:32.292737-07:00	2024-02-15 16:41:55.746337-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'
Bitrix24.sites	free-sys.ru	998425.0	free-sys.ru	2023-10-15 14:38:17.296007-07:00	2023-12-08 10:35:49.635261-08:00	lower(http_request.response_headers) contains 'bitrix24.sites'