hmm, tak to spravime nasledovne (kedze nemame nahlad na data):
SELECT
a.id,
a.nazev,
case when exists (select 1 from newsletters_skupiny_hlavni where idNewsletter = a.id) then 1 else 0 end as checkbox_checked
FROM newsletters_ a
WHERE a.id = <nejake_cislo>;