---

SELECT
    sc.id,
    sc.service_id,
    sc.placement_id,
    p.title AS placement_title,
    sc.external_id,
    sc.title,
    sc.created_at,
    sc.updated_at
FROM smartis_campaigns sc
LEFT JOIN placements p ON p.id = sc.placement_id
WHERE sc.client_id = <client_id>
  AND sc.external_id = '<external_id>'
ORDER BY sc.created_at, sc.id;