Page MenuHomePhabricator
Paste P55961

runaway query
ActivePublic
Actions

Authored by jgleeson on Jan 31 2024, 2:06 PM.
Tags
None
Referenced Files
F41734837: runaway query
Jan 31 2024, 2:06 PM
Subscribers
None
/* User : 106 */SELECT
`a`.`id` AS `id`,
`a`.`activity_type_id` AS `activity_type_id:label`,
`a`.`subject` AS `subject`,
`a`.`activity_date_time` AS `activity_date_time`,
`a`.`status_id` AS `status_id:label`,
GROUP_CONCAT(`Activity_ActivityContact_Contact_02`.`id`
ORDER BY `Activity_ActivityContact_Contact_02`.`id`
SEPARATOR '') AS `_GROUP_CONCAT_Activity_ActivityContact_Contact_02_sort_name`,
GROUP_CONCAT(`Activity_ActivityContact_Contact_02`.`sort_name`
ORDER BY `Activity_ActivityContact_Contact_02`.`id`
SEPARATOR '') AS `GROUP_CONCAT_Activity_ActivityContact_Contact_02_sort_name`,
GROUP_CONCAT(`Activity_ActivityContact_Contact_03`.`id`
ORDER BY `Activity_ActivityContact_Contact_03`.`id`
SEPARATOR '') AS `_GROUP_CONCAT_Activity_ActivityContact_Contact_03_sort_name`,
GROUP_CONCAT(`Activity_ActivityContact_Contact_03`.`sort_name`
ORDER BY `Activity_ActivityContact_Contact_03`.`id`
SEPARATOR '') AS `GROUP_CONCAT_Activity_ActivityContact_Contact_03_sort_name`,
GROUP_CONCAT(`Activity_ActivityContact_Contact_04`.`id`
ORDER BY `Activity_ActivityContact_Contact_04`.`id`
SEPARATOR '') AS `_GROUP_CONCAT_Activity_ActivityContact_Contact_04_sort_name`,
GROUP_CONCAT(`Activity_ActivityContact_Contact_04`.`sort_name`
ORDER BY `Activity_ActivityContact_Contact_04`.`id`
SEPARATOR '') AS `GROUP_CONCAT_Activity_ActivityContact_Contact_04_sort_name`,
`a`.`activity_type_id` AS `activity_type_id:icon`,
`a`.`status_id` AS `status_id`,
GROUP_CONCAT(DISTINCT `Activity_ActivityContact_Contact_02`.`id`
ORDER BY `Activity_ActivityContact_Contact_02`.`id`
SEPARATOR '') AS `GROUP_CONCAT_Activity_ActivityContact_Contact_02_id`,
GROUP_CONCAT(DISTINCT `Activity_ActivityContact_Contact_03`.`id`
ORDER BY `Activity_ActivityContact_Contact_03`.`id`
SEPARATOR '') AS `GROUP_CONCAT_Activity_ActivityContact_Contact_03_id`,
GROUP_CONCAT(DISTINCT `Activity_ActivityContact_Contact_04`.`id`
ORDER BY `Activity_ActivityContact_Contact_04`.`id`
SEPARATOR '') AS `GROUP_CONCAT_Activity_ActivityContact_Contact_04_id`
FROM
civicrm_activity a
INNER JOIN
(`civicrm_activity_contact` `Activity_ActivityContact_Contact_01_via_activitycontact`
INNER JOIN `civicrm_contact` `Activity_ActivityContact_Contact_01` ON (`Activity_ActivityContact_Contact_01_via_activitycontact`.`contact_id` = `Activity_ActivityContact_Contact_01`.`id`)) ON `Activity_ActivityContact_Contact_01_via_activitycontact`.`activity_id` = `a`.`id`
LEFT JOIN
(`civicrm_activity_contact` `Activity_ActivityContact_Contact_02_via_activitycontact`
INNER JOIN `civicrm_contact` `Activity_ActivityContact_Contact_02` ON (`Activity_ActivityContact_Contact_02_via_activitycontact`.`contact_id` = `Activity_ActivityContact_Contact_02`.`id`)) ON `Activity_ActivityContact_Contact_02_via_activitycontact`.`record_type_id` = '2'
AND `Activity_ActivityContact_Contact_02_via_activitycontact`.`activity_id` = `a`.`id`
LEFT JOIN
(`civicrm_activity_contact` `Activity_ActivityContact_Contact_03_via_activitycontact`
INNER JOIN `civicrm_contact` `Activity_ActivityContact_Contact_03` ON (`Activity_ActivityContact_Contact_03_via_activitycontact`.`contact_id` = `Activity_ActivityContact_Contact_03`.`id`)) ON `Activity_ActivityContact_Contact_03_via_activitycontact`.`record_type_id` = '3'
AND `Activity_ActivityContact_Contact_03_via_activitycontact`.`activity_id` = `a`.`id`
LEFT JOIN
(`civicrm_activity_contact` `Activity_ActivityContact_Contact_04_via_activitycontact`
INNER JOIN `civicrm_contact` `Activity_ActivityContact_Contact_04` ON (`Activity_ActivityContact_Contact_04_via_activitycontact`.`contact_id` = `Activity_ActivityContact_Contact_04`.`id`)) ON `Activity_ActivityContact_Contact_04_via_activitycontact`.`record_type_id` = '1'
AND `Activity_ActivityContact_Contact_04_via_activitycontact`.`activity_id` = `a`.`id`
WHERE
(((`a`.`activity_type_id` IN (3 , 4,
5,
6,
9,
10,
11,
12,
13,
14,
15,
16,
27,
28,
30,
36,
42,
43,
44,
45,
46,
47,
48,
53,
54,
55,
56,
57,
58,
59,
60,
61,
62,
63,
64,
65,
66,
67,
68,
69,
70,
71,
72,
73,
74,
77,
78,
79,
80,
81,
82,
83,
84,
85,
86,
87,
88,
89,
90,
91,
92,
93,
95,
96,
97,
99,
100,
102,
103,
104,
105,
106,
107,
108,
109,
110,
111,
112,
113,
114,
115,
116,
117,
118,
119,
120,
121,
122,
123,
124,
125,
126,
127,
128,
129,
130,
132,
133,
134,
135,
136,
137,
138,
139,
140,
142,
143,
144,
145,
146,
147,
148,
150,
151,
152,
153,
154,
155,
156,
158,
159,
160,
161,
162,
163,
165,
166,
168,
170,
171,
174))))
AND (`Activity_ActivityContact_Contact_01`.`id` = '42616156')
AND (`a`.`is_test` = '0')
AND (`a`.`is_deleted` = '0')
GROUP BY `a`.`id`
ORDER BY `a`.`activity_date_time` DESC
LIMIT 50 OFFSET 0
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL