SELECT `link`, `link_r` FROM (SELECT `cpl_link_offer`.`link` , `cpl_offer_cpa`.`link` as `link_r` FROM `cpl_link_offer` JOIN `cpl_offer_cpa` ON `cpl_link_offer`.`offer_id` = `cpl_offer_cpa`.`offer_id` JOIN `cpl_cpa` ON `cpl_cpa`.`name` = `cpl_offer_cpa`.`cpa` ORDER BY `cpl_offer_cpa`.`rating` DESC, `cpl_cpa`.`rating` DESC) AS `t1` GROUP BY `link`
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`
Простой
Простой
Простой
Средний
Средний
