Unnamed

//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
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