SELECT
DISTINCT u.email,
su.metaInfo,
(SELECT count(*) as viewCount
        FROM StatisticEvent se, Subscription s
        WHERE se.eventType = 'display' and
        se.subscription.id = s.id and
        s.campaign.id = 1 and
        s.user.id=u.id) ,
(SELECT count(*) as clickCount
        FROM StatisticEvent se, Subscription s
        WHERE se.eventType = 'click' and
        se.subscription.id = s.id and
        s.campaign.id = 1 and
        s.user.id=u.id) as clicks
FROM User u, Subscription su
WHERE u.id = su.user.id AND su.campaign.id =  1
ORDER BY  u.email