SELECT mailing_list_id, mailing_list_name, description, (

SELECT COUNT( nl_at_mailinglist_receiver.receiver_id )
FROM nl_at_mailinglist_receiver, nl_at_letter_receiver
WHERE (

SELECT status FROM nl_receiver
WHERE nl_at_mailinglist_receiver.receiver_id = nl_receiver.receiver_id
) = 'ok'
AND nl_at_mailinglist_receiver.mailing_list_id = nl_mailing_list.mailing_list_id
AND nl_at_letter_receiver.letter_id =0
AND nl_at_letter_receiver.receiver_id = nl_at_mailinglist_receiver.receiver_id

) AS receiver_cnt, (

SELECT COUNT( receiver_id )
FROM nl_at_mailinglist_receiver
WHERE (

SELECT status FROM nl_receiver
WHERE nl_at_mailinglist_receiver.receiver_id = nl_receiver.receiver_id
) = 'ok'
AND nl_at_mailinglist_receiver.mailing_list_id = nl_mailing_list.mailing_list_id

) AS member_cnt
FROM nl_mailing_list
ORDER BY mailing_list_name
LIMIT 0 , 30