Page MenuHomePhabricator

Slow query on live
Open, MediumPublic


This query caused an issue (reported by @Jgreen )

user/215 */

CREATE TEMPORARY TABLE IF NOT EXISTS contribution_search_scredit_combined AS
   SELECT as id, con.contact_id, as filter_id, NULL as scredit_id
     FROM civicrm_contribution con
LEFT JOIN civicrm_contribution_soft cso ON = cso.contribution_id
 GROUP BY id, contact_id, scredit_id,
   SELECT scredit.contribution_id as id, scredit.contact_id, as filter_id, as scredit_id
     FROM civicrm_contribution_soft as scredit;

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 19 2017, 1:05 AM
DStrine triaged this task as Medium priority.Jul 19 2017, 8:03 PM
Aklapper removed Eileenmcnaughton as the assignee of this task.Jun 19 2020, 4:20 PM

This task has been assigned to the same task owner for more than two years. Resetting task assignee due to inactivity, to decrease task cookie-licking and to get a slightly more realistic overview of plans. Please feel free to assign this task to yourself again if you still realistically work or plan to work on this task - it would be welcome!

For tips how to manage individual work in Phabricator (noisy notifications, lists of task, etc.), see for available options.
(For the records, two emails were sent to assignee addresses before resetting assignees. See T228575 for more info and for potential feedback. Thanks!)