Untitled

'SELECT count(DISTINCT(`fs_events`.`id`)) AS `count` FROM `fs_events` AS `fs_events` INNER JOIN `fw_accounts` AS `account` ON `fs_events`.`account_id` = `account`.`id` AND (`account`.`archived_at` IS NULL AND ((`account`.`tenant_id` = 2) OR `account`.`tenant_id` = `fs_events`.`tenant_id` OR `account`.`tenant_id` IS NULL)) LEFT OUTER JOIN `fw_entity_assignees` AS `assignees` ON `fs_events`.`id` = `assignees`.`entity_linking_id` AND (`assignees`.`archived_at` IS NULL AND (`assignees`.`entity_id` = 15 AND ((`assignees`.`tenant_id` = 2) OR `assignees`.`tenant_id` = `fs_events`.`tenant_id` OR `assignees`.`tenant_id` IS NULL))) LEFT OUTER JOIN `fw_entities` AS `assignees->entity` ON `assignees`.`entity_id` = `assignees->entity`.`id` AND (`assignees->entity`.`archived_at` IS NULL AND (`assignees->entity`.`tenant_id` = `fs_events`.`tenant_id` OR `assignees->entity`.`tenant_id` IS NULL)) LEFT OUTER JOIN `fw_users` AS `assignees->assigned_user` ON `assignees`.`user_id` = `assignees->assigned_user`.`id` AND (`assignees->assigned_user`.`archived_at` IS NULL AND (`assignees->assigned_user`.`tenant_id` = `fs_events`.`tenant_id` OR `assignees->assigned_user`.`tenant_id` IS NULL)) LEFT OUTER JOIN `fw_group_users` AS `assignees->assigned_user->groups` ON `assignees->assigned_user`.`id` = `assignees->assigned_user->groups`.`user_id` AND (`assignees->assigned_user->groups`.`archived_at` IS NULL AND (`assignees->assigned_user->groups`.`tenant_id` = `fs_events`.`tenant_id` OR `assignees->assigned_user->groups`.`tenant_id` IS NULL)) LEFT OUTER JOIN `fw_files` AS `assignees->assigned_user->profile_file` ON `assignees->assigned_user`.`profile_file_id` = `assignees->assigned_user->profile_file`.`id` AND (`assignees->assigned_user->profile_file`.`archived_at` IS NULL AND (`assignees->assigned_user->profile_file`.`tenant_id` = `fs_events`.`tenant_id` OR `assignees->assigned_user->profile_file`.`tenant_id` IS NULL)) LEFT OUTER JOIN `fw_file_resized` AS `assignees->assigned_user->profile_file->file_resized` ON `assignees->assigned_user->profile_file`.`id` = `assignees->assigned_user->profile_file->file_resized`.`file_id` AND (`assignees->assigned_user->profile_file->file_resized`.`archived_at` IS NULL AND (`assignees->assigned_user->profile_file->file_resized`.`tenant_id` = `fs_events`.`tenant_id` OR `assignees->assigned_user->profile_file->file_resized`.`tenant_id` IS NULL)) LEFT OUTER JOIN `fw_ref_country_states` AS `state_data` ON `fs_events`.`state` = `state_data`.`state_code` AND (`state_data`.`archived_at` IS NULL AND ((`state_data`.`tenant_id` = 2) OR `state_data`.`tenant_id` = `fs_events`.`tenant_id` OR `state_data`.`tenant_id` IS NULL)) WHERE (`fs_events`.`archived_at` IS NULL AND ((COUNT(`et`.`taxonomy_id`) = 1 AND \n' +  
    '              EXISTS (\n' +
    '                SELECT 1 FROM fw_entity_taxonomies et\n' +      
    '                WHERE et.entity_id = 15\n' +
    '                  AND et.entity_linking_id = fs_events.id\n' +  
    '                  AND et.taxonomy_id IN (441)\n' +
    '              )\n' +
    "            ) AND `fs_events`.`sif_event_id` IS NOT NULL AND `fs_events`.`min_event_date` BETWEEN '2024-11-30T16:00:00.000Z' AND '2024-12-31T15:59:59.999Z' AND (`fs_events`.`tenant_id` = 2 OR `fs_events`.`tenant_id` IS NULL)));"