F
Size: a a a
F
F
IS
IS
IS
Е
SELECT DISTINCT i.* FROM (
SELECT DISTINCT t.*, c.avg_ctr as campaign_avg_ctr
FROM (
SELECT DISTINCT api_id AS teaser_id, campaign_id, was_boost, was_blocked, hits, clicks, ctr, decision, created_at
FROM teasers_analytic WHERE is_boost = 1 AND created_at > '2021-04-15 00:00:00' AND created_at < '2021-04-15 23:59:59'
) AS t
JOIN campaigns_analytic AS c
ON t.campaign_id = c.api_id
WHERE c.avg_ctr > 0.8
) AS i
у 'i' есть teaser_id. Мне нужно, чтобы в получаемых записях каждая запись имела уникальный teaser_idF
IS
ДT
ДT
ДT
F
SD
F
Л
Л
Л