{
"version": 4,
"select": [
"id",
"subject",
"Case_CaseContact_Contact_01.display_name",
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.activity_date_time",
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.activity_type_id:label",
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.subject",
"Case_CaseContact_Contact_01.id",
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.id"
],
"orderBy": [],
"where": [
[
"case_type_id:name",
"=",
"learningitalian"
],
[
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.activity_type_id:name",
"=",
"WrittenTest"
],
[
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.status_id:name",
"=",
"Completed"
],
[
"status_id:name",
"!=",
"Closed"
]
],
"groupBy": [],
"join": [
[
"Contact AS Case_CaseContact_Contact_01",
"LEFT",
"CaseContact",
[
"id",
"=",
"Case_CaseContact_Contact_01.case_id"
]
],
[
"Activity AS Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01",
"LEFT",
"ActivityContact",
[
"Case_CaseContact_Contact_01.id",
"=",
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.contact_id"
],
[
"Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.record_type_id:name",
"=",
"\"Activity Targets\""
]
]
],
"having": [],
"debug": true,
"limit": 60,
"offset": 0
SELECT `a`.`id` AS `id`, `a`.`subject` AS `subject`, `Case_CaseContact_Contact_01`.`display_name` AS `Case_CaseContact_Contact_01.display_name`, `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`activity_date_time` AS `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.activity_date_time`, `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`activity_type_id` AS `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.activity_type_id:label`, `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`subject` AS `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.subject`, `Case_CaseContact_Contact_01`.`id` AS `Case_CaseContact_Contact_01.id`, `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`id` AS `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01.id`
FROM civicrm_case a
LEFT JOIN (SELECT `b`.`case_id`,`b`.`contact_id`,`c`.`id`,`c`.`contact_type`,`c`.`contact_sub_type`,`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`.`external_identifier`,`c`.`sort_name`,`c`.`display_name`,`c`.`nick_name`,`c`.`legal_name`,`c`.`image_URL`,`c`.`preferred_communication_method`,`c`.`preferred_language`,`c`.`preferred_mail_format`,`c`.`hash`,`c`.`api_key`,`c`.`source`,`c`.`first_name`,`c`.`middle_name`,`c`.`last_name`,`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`.`organization_name`,`c`.`sic_code`,`c`.`user_unique_id`,`c`.`employer_id`,`c`.`is_deleted`,`c`.`created_date`,`c`.`modified_date` 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`
LEFT JOIN (SELECT `b`.`activity_id`,`b`.`contact_id`,`b`.`record_type_id`,`c`.`id`,`c`.`source_record_id`,`c`.`activity_type_id`,`c`.`subject`,`c`.`activity_date_time`,`c`.`duration`,`c`.`location`,`c`.`phone_id`,`c`.`phone_number`,`c`.`details`,`c`.`status_id`,`c`.`priority_id`,`c`.`parent_id`,`c`.`is_test`,`c`.`medium_id`,`c`.`is_auto`,`c`.`relationship_id`,`c`.`is_current_revision`,`c`.`original_id`,`c`.`result`,`c`.`is_deleted`,`c`.`campaign_id`,`c`.`engagement_level`,`c`.`weight`,`c`.`is_star`,`c`.`created_date`,`c`.`modified_date` FROM `civicrm_activity_contact` `b`, `civicrm_activity` `c` WHERE `b`.`activity_id` = `c`.`id` AND (`c`.`activity_type_id` IS NULL OR (`c`.`activity_type_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 58, 60, 62, 64, 66, 67, 68, 69)))) `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01` ON `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`record_type_id` = "3" AND `Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`contact_id` = `Case_CaseContact_Contact_01`.`id`
WHERE (`a`.`case_type_id` = "4") AND (`Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`activity_type_id` = "69") AND (`Case_CaseContact_Contact_01_Contact_ActivityContact_Activity_01`.`status_id` = "2") AND (`a`.`status_id` != "2") AND (`a`.`is_deleted` = "0")
LIMIT 60
OFFSET 0