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
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
)

укоротил

#devops #programming #russian

0

22.11.2016

3 ответов

32 просмотра

Artur BAGArt · Answer 1

Artur BAGArt Автор вопроса

возможно тебе надо and ( s.platform_id is null or cp.adv_campaign_id !=s.platform_id )

0

22.11.2016

Artur BAGArt · Answer 2

Artur BAGArt Автор вопроса

поправил

0

22.11.2016

Artur BAGArt · Answer 3

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.campaign_id )

0

22.11.2016

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

SELECT c.* FROM adv_campaigns as c LEFT

3 ответов

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