Děkuji.
Zdá se že funguje.
Omylem jsem sem položil jen částečný SQL dotaz.
Celé to vypadá takto:
SELECT entry_company, entry_state
FROM (
SELECT entry_state, address_book_id AS address_book_id, entry_company AS entry_company, p.id_adresy, p.id_skupiny checkbox_checked
FROM address_book
LEFT JOIN skupina_obsah p ON p.id_adresy = address_book.address_book_id
AND (
id_skupiny =27
)
WHERE entry_state NOT LIKE ' '
) AS finalni_emaily
WHERE checkbox_checked NOT LIKE ''
GROUP BY entry_state
UNION ALL
SELECT DISTINCT '' AS entry_company, email AS entry_state
FROM bulletin_registr
Značím vyřešeno!