MySQL [nextcloud] > EXPLAIN
SELECT `polls_polls`.*,
	(
		SELECT COUNT(`user_vote_sub`.`vote_answer`)
		FROM `oc_polls_votes` `user_vote_sub`
		WHERE (`user_vote_sub`.`poll_id` = `polls_polls`.`id`)
			AND (`user_vote_sub`.`user_id` = 'r-e-m-o-v-e-d')
	) AS `current_user_count_votes`,
	(
		SELECT COUNT(`user_vote_sub`.`vote_answer`)
		FROM `oc_polls_votes` `user_vote_sub`
		WHERE (`user_vote_sub`.`poll_id` = `polls_polls`.`id`)
			AND (`user_vote_sub`.`user_id` = 'r-e-m-o-v-e-d')
			AND (`user_vote_sub`.`vote_answer` = 'yes')
	) AS `current_user_count_votes_yes`,
	(
		SELECT COUNT(`user_vote_sub`.`vote_answer`)
		FROM `oc_polls_votes` `user_vote_sub`
			LEFT JOIN `oc_polls_options` `vote_options_join` ON (
				`vote_options_join`.`poll_id` = `user_vote_sub`.`poll_id`
			)
			AND (
				`vote_options_join`.`poll_option_text` = `user_vote_sub`.`vote_option_text`
			)
			AND (`vote_options_join`.`deleted` = '0')
		WHERE (`user_vote_sub`.`poll_id` = `polls_polls`.`id`)
			AND (`user_vote_sub`.`user_id` = 'r-e-m-o-v-e-d')
			AND (`vote_options_join`.`id` IS NULL)
	) AS `current_user_count_orphaned_votes`,
	coalesce(MAX(options.timestamp), 0) AS max_date,
	coalesce(MIN(options.timestamp), 1724870381) AS min_date,
	COUNT(`options`.`id`) AS `count_options`,
	coalesce(user_shares.type, '') AS user_role,
	`user_shares`.`locked` AS `is_current_user_locked`,
	coalesce(user_shares.token, '') AS share_token,
	group_concat(distinct group_shares.user_id SEPARATOR ',') AS group_shares
FROM `oc_polls_polls` `polls_polls`
	LEFT JOIN `oc_polls_options` `options` ON (`polls_polls`.`id` = `options`.`poll_id`)
	AND (`options`.`deleted` = '0')
	LEFT JOIN `oc_polls_share` `user_shares` ON (`polls_polls`.`id` = `user_shares`.`poll_id`)
	AND (`user_shares`.`user_id` = 'r-e-m-o-v-e-d')
	AND (`user_shares`.`deleted` = '0')
	LEFT JOIN `oc_polls_share` `group_shares` ON (`polls_polls`.`id` = `group_shares`.`poll_id`)
	AND (`group_shares`.`type` = 'group')
	AND (`group_shares`.`deleted` = '0')
WHERE `polls_polls`.`owner` <> 'r-e-m-o-v-e-d'
GROUP BY `polls_polls`.`id`,
	`user_shares`.`type`,
	`user_shares`.`locked`,
	`user_shares`.`token`;


+------+--------------------+-------------------+--------+--------------------------------------------------------------+----------------------+---------+---------------------------------+------+----------------------------------------------+
| id   | select_type        | table             | type   | possible_keys                                                | key                  | key_len | ref                             | rows | Extra                                        |
+------+--------------------+-------------------+--------+--------------------------------------------------------------+----------------------+---------+---------------------------------+------+----------------------------------------------+
|    1 | PRIMARY            | polls_polls       | ALL    | polls_polls_owner_deleted_idx,polls_polls_owners_non_deleted | NULL                 | NULL    | NULL                            | 7566 | Using where; Using temporary; Using filesort |
|    1 | PRIMARY            | options           | ref    | UNIQ_options,IDX_9AA5663C947C0F                              | IDX_9AA5663C947C0F   | 8       | nextcloud.polls_polls.id        | 1    | Using where                                  |
|    1 | PRIMARY            | user_shares       | eq_ref | UNIQ_shares,IDX_1C85E16C3C947C0F                             | UNIQ_shares          | 1034    | nextcloud.polls_polls.id,const  | 1    | Using where                                  |
|    1 | PRIMARY            | group_shares      | ref    | UNIQ_shares,IDX_1C85E16C3C947C0F                             | IDX_1C85E16C3C947C0F | 8       | nextcloud.polls_polls.id        | 5    | Using where                                  |
|    4 | DEPENDENT SUBQUERY | user_vote_sub     | ALL    | UNIQ_votes,IDX_A20806F93C947C0F                              | NULL                 | NULL    | NULL                            | 1    | Using where                                  |
|    4 | DEPENDENT SUBQUERY | vote_options_join | ref    | UNIQ_options,IDX_9AA5663C947C0F                              | IDX_9AA5663C947C0F   | 8       | nextcloud.user_vote_sub.poll_id | 1    | Using where; Not exists                      |
|    3 | DEPENDENT SUBQUERY | user_vote_sub     | ALL    | UNIQ_votes,IDX_A20806F93C947C0F                              | NULL                 | NULL    | NULL                            | 1    | Using where                                  |
|    2 | DEPENDENT SUBQUERY | user_vote_sub     | ALL    | UNIQ_votes,IDX_A20806F93C947C0F                              | NULL                 | NULL    | NULL                            | 1    | Using where                                  |
+------+--------------------+-------------------+--------+--------------------------------------------------------------+----------------------+---------+---------------------------------+------+----------------------------------------------+
8 rows in set (0.004 sec)