[Explorer] Execution failed for question 27cc061d-4121-434c-87d8-fdd7ee06edde: web3技术框架

[gary163]

Hi, It's failed to execute the question 27cc061d-4121-434c-87d8-fdd7ee06edde web3技术框架 (errorType = error-query-timeout):

• executedAt: 2024-05-28T08:48:21.000+00:00
• requestedAt: 2024-05-28T08:48:21.000+00:00

Error message

Query inactivity timeout

Generated SQL

SELECT
  `gr`.`repo_name` AS `repo_name`,
  `gr`.`stars` AS `stars`,
  COUNT(DISTINCT `ge`.`actor_id`) AS `contributors`,
  COUNT(*) AS `pull_requests`,
  AVG(
    TIMESTAMPDIFF(
      SECOND,
      `ge`.`pr_or_issue_created_at`,
      `ge`.`closed_at`
    )
  ) AS `open_to_merged_time`
FROM
  `github_events` AS `ge`
  INNER JOIN `github_repos` AS `gr` ON `ge`.`repo_id` = `gr`.`repo_id`
WHERE
  LOWER(`gr`.`description`) LIKE '%react%'
  AND `ge`.`type` = 'PullRequestEvent'
  AND `ge`.`action` = 'closed'
  AND `ge`.`pr_merged` = 1
GROUP BY
  `gr`.`repo_name`
ORDER BY
  `gr`.`stars` DESC,
  `contributors` DESC,
  `pull_requests` DESC,
  `open_to_merged_time` ASC
LIMIT
  20