---

SELECT
    service_id,
    placement_id,
    COUNT(*) AS cnt
FROM smartis_campaigns
WHERE client_id = <client_id>
GROUP BY service_id, placement_id
ORDER BY cnt DESC;

SELECT
    sc0.id AS wrong_id,
    sc0.service_id AS wrong_service_id,
    sc0.placement_id AS wrong_placement_id,
    sc1.id AS ydirect_id,
    sc1.service_id AS ydirect_service_id,
    sc1.placement_id AS ydirect_placement_id,
    sc0.external_id,
    sc0.title AS wrong_title,
    sc1.title AS ydirect_title
FROM smartis_campaigns sc0
JOIN smartis_campaigns sc1
    ON sc1.client_id = sc0.client_id
   AND sc1.external_id = sc0.external_id
   AND sc1.service_id = 1
   AND sc1.placement_id = 11
WHERE sc0.client_id = <client_id>
  AND NOT (sc0.service_id = 1 AND sc0.placement_id = 11);