В чем нам даст профит то, что у нас отсортированный набор данных, если мы начнем поиск начиная с id = 1
SELECT `c`.`a_user_index`, `c`.`a_nas` + IFNULL(`s`.`sum`, 0)
FROM (
SELECT `a_user_idx`, SUM(`a_count`) AS `sum`
FROM `t_stash04`
GROUP BY `a_user_idx`
) AS `s`
RIGHT JOIN `t_characters` AS `c`
ON `c`.a_user_index` = `s`.`a_user_idx`SELECT `o`.`link`, ANY_VALUE(`c`.`link`) as `link_r`
FROM (
SELECT `offer_id`, `link`
FROM `cpl_offer_cpa`
WHERE `cpa` IN (
SELECT `name`
FROM `cpl_cpa`
)
) AS `c`
JOIN `cpl_link_offer` AS `o` ON `o`.`offer_id` = `c`.`offer_id`
GROUP BY `o`.`link`SELECT ANY_VALUE(`name`), MIN(`score`) FROM `tab`
SELECT DISTINCT `user_id`
FROM `ticket`
WHERE `user_id` IN (SELECT `user_id` FROM `ticket` WHERE `type` = 2)
AND `user_id` IN (SELECT `user_id` FROM `ticket` WHERE `type` = 3)
AND `user_id` NOT IN (SELECT `user_id` FROM `ticket` WHERE `type` = 1)
AND `user_id` NOT IN (SELECT `user_id` FROM `ticket` WHERE `type` = 4)SELECT `c`.`id`, `c`.`name`, `s`.`score`
FROM (
SELECT `cp`.`id_clan` AS `id_clan`,
SUM(`uc`.`health`) + SUM(`uc`.`power`)
+ SUM(`uc`.`agil`) + SUM(`uc`.`intell`) AS `score`
FROM `clan_part` AS `cp`
JOIN `users_combat` AS `uc` ON `uc`.`id_user` = `cp`.`id_user`
GROUP BY `cp`.`id_clan`
ORDER BY `score` DESC
LIMIT 0, 10
) AS `s`
JOIN `clan` AS `c` ON `c`.`id` = `s`.`id_clan`start2 > end1 || start2 > end1~(start2 > end1 || start2 > end1) =
= ~(start2 > end1) && ~(start2 > end1) =
= start2 <= end1 && start2 <= end1