SearchKit SQL for Activities issue

searchkit_activities_issue.sql

SELECT `a`.`id` AS `id`, GROUP_CONCAT(DISTINCT `Case_CaseContact_Contact_01`.`display_name` SEPARATOR "
") AS `GROUP_CONCAT_Case_CaseContact_Contact_01_display_name`, `a`.`subject` AS `subject`, GROUP_CONCAT(`Case_CaseActivity_Activity_01`.`subject` SEPARATOR "
") AS `GROUP_CONCAT_Case_CaseActivity_Activity_01_subject`, GROUP_CONCAT(`Case_CaseContact_Contact_01`.`id` SEPARATOR "
") AS `GROUP_CONCAT_Case_CaseContact_Contact_01_id`, GROUP_CONCAT(`Case_CaseActivity_Activity_01`.`id` SEPARATOR "
") AS `GROUP_CONCAT_Case_CaseActivity_Activity_01_id`, GROUP_CONCAT(DISTINCT `Food_Discovery_1`.`session_date_332` SEPARATOR "
") AS `GROUP_CONCAT_Case_CaseActivity_Activity_01_Food_Discovery_Session_date`
FROM civicrm_case a
LEFT JOIN (SELECT `b`.`case_id`,`b`.`contact_id`,`c`.`id`,`c`.`contact_type`,`c`.`external_identifier`,`c`.`display_name`,`c`.`organization_name`,`c`.`contact_sub_type`,`c`.`first_name`,`c`.`middle_name`,`c`.`last_name`,`c`.`do_not_email`,`c`.`do_not_phone`,`c`.`do_not_mail`,`c`.`do_not_sms`,`c`.`do_not_trade`,`c`.`is_opt_out`,`c`.`legal_identifier`,`c`.`sort_name`,`c`.`nick_name`,`c`.`legal_name`,`c`.`image_URL`,`c`.`preferred_communication_method`,`c`.`preferred_language`,`c`.`hash`,`c`.`api_key`,`c`.`source`,`c`.`prefix_id`,`c`.`suffix_id`,`c`.`formal_title`,`c`.`communication_style_id`,`c`.`email_greeting_id`,`c`.`email_greeting_custom`,`c`.`email_greeting_display`,`c`.`postal_greeting_id`,`c`.`postal_greeting_custom`,`c`.`postal_greeting_display`,`c`.`addressee_id`,`c`.`addressee_custom`,`c`.`addressee_display`,`c`.`job_title`,`c`.`gender_id`,`c`.`birth_date`,`c`.`is_deceased`,`c`.`deceased_date`,`c`.`household_name`,`c`.`primary_contact_id`,`c`.`sic_code`,`c`.`user_unique_id`,`c`.`employer_id`,`c`.`is_deleted`,`c`.`created_date`,`c`.`modified_date`,`c`.`preferred_mail_format`,`b`.`id` AS `bridge_entity_id_key` FROM `civicrm_case_contact` `b`, `civicrm_contact` `c` WHERE `b`.`contact_id` = `c`.`id`) `Case_CaseContact_Contact_01` ON `Case_CaseContact_Contact_01`.`case_id` = `a`.`id`
INNER JOIN `civicrm_case_activity` `Case_CaseActivity_Activity_01_via_caseactivity` ON `Case_CaseActivity_Activity_01_via_caseactivity`.`case_id` = `a`.`id`
INNER JOIN `civicrm_activity` `Case_CaseActivity_Activity_01` ON `Case_CaseActivity_Activity_01_via_caseactivity`.`activity_id` = `Case_CaseActivity_Activity_01`.`id` AND `Case_CaseActivity_Activity_01`.`activity_type_id` = "144" AND (`Case_CaseActivity_Activity_01`.`subject` <> "" AND `Case_CaseActivity_Activity_01`.`subject` IS NOT NULL)
LEFT JOIN `civicrm_value_food_discover_41` `Food_Discovery_1` ON `Case_CaseActivity_Activity_01`.`id` =  `Food_Discovery_1`.`entity_id`
WHERE (`a`.`case_type_id` = "14") AND (`a`.`is_deleted` = "0")
GROUP BY `a`.`id`
ORDER BY `a`.`subject` ASC
LIMIT 50
OFFSET 0