SELECT tblPressReleases.PressReleaseID, tblPressReleases.Title, tblPressReleases.PressReleaseDate, tblClients.Name as ClientName
	FROM tblPressReleases, tblClients
	WHERE PressReleaseDate >= STR_TO_DATE( '07/1/2012 00:00:00', '%m/%d/%Y %H:%i:%s')
		AND PressReleaseDate < STR_TO_DATE( '08/1/2012 00:00:00', '%m/%d/%Y %H:%i:%s')
		AND tblPressReleases.Visible = 1
		AND tblClients.ClientID = tblPressReleases.ClientID
		AND tblClients.Visible = 1
	ORDER BY PressReleaseDate DESC