//Show all Mailings:
SELECT id, date_format(SendDateTime,'%d.%m.%Y') As ASendDateTime, CampaignName
FROM Campaigns LEFT JOIN CampaignOptions
ON Campaigns.id=CampaignOptions.Campaign_id
RIGHT OUTER JOIN Opening_Stat2
ON (Campaigns.id = Opening_Stat2.Campaign_id)
HAVING COUNT(id) > 50
GROUP BY id
ORDER BY SendDateTime DESC
//Count the Openings of the particular mailing
SELECT COUNT(*) AS Openings
FROM Opening_Stat2 LEFT OUTER JOIN Campaigns
ON (Campaigns.id = Opening_Stat2.Campaign_id)
WHERE Opening_Stat2.Campaign_id = id
GROUP BY Clicks
//Combined
SELECT Campaigns.id, date_format(Campaigns.SendDateTime,'%d.%m.%Y') As ASendDateTime, Campaigns.CampaignName
FROM Campaigns LEFT JOIN CampaignOptions
ON Campaigns.id=CampaignOptions.Campaign_id
RIGHT OUTER JOIN Opening_Stat2
ON (Campaigns.id = Opening_Stat2.Campaign_id)
HAVING COUNT(Campaigns.id) > 50
GROUP BY id, ASendDateTime, Campaigns.CampaignName
ORDER BY Campaigns.SendDateTime DESC