SELECT c.* FROM adv_campaigns as c LEFT

Question

SELECT c.* FROM adv_campaigns as c LEFT

JOIN statistics as s
ON c.id=s.campaign_id
LEFT JOIN adv_campaigns_platforms as cp
ON s.platform_id = cp.platform_id
AND s.type_id=#{STATS_TYPE_APPROVAL}
AND s.uid=?
AND s.platform_id=?
WHERE s.id IS NULL
AND c.status=3
AND cp.adv_campaign_id IS NULL

#devops #programming #russian

0

22.11.2016

3 ответов

3 просмотра

Artur BAGArt

and adv_campaign_id != s.campaign_id же?

0

22.11.2016

Artur BAGArt

SELECT c.* FROM adv_campaigns as c LEFT JOIN statistics as s ON c.id=s.campaign_id AND s.type_id=? AND s.uid=? LEFT JOIN adv_campaigns_platforms as cp ON s.platform_id = cp.platform_id WHERE s.id IS NULL AND c.status=3 — это я не понял зачем AND cp.adv_campaign_id IS NULL and ( s.platform_id != ? —???? s.platform_id is null or cp.adv_campaign_id !=s.platform_id ) укоротил

0

22.11.2016

Cate Archer · Accepted Answer

Cate Archer

Этот вариант уже устарел)

0

22.11.2016

172 похожих чатов

SELECT c.* FROM adv_campaigns as c LEFT

3 ответов

Похожие вопросы