SQL-controlequery toegevoegde marktlijstleden

SELECT FilteredListMember.listmemberid, FilteredListMember.createdbyname, FilteredListMember.modifiedon, FilteredList.listname, DATEPART(m, FilteredListMember.createdon) AS Maand, DATEPART(yy, FilteredListMember.createdon) AS Jaar, DATEPART(dd, FilteredListMember.createdon) AS Dag, FilteredListMember.createdby

FROM FilteredListMember INNER JOIN FilteredList ON FilteredListMember.listid = FilteredList.listid

WHERE (FilteredListMember.listid = '6E093B6F-E775-DE11-B303-005056940368') AND (DATEPART(m, FilteredListMember.createdon) = 8) AND (DATEPART(yy, FilteredListMember.createdon) = 2009) AND (DATEPART(dd, FilteredListMember.createdon) = 18) AND (FilteredListMember.createdby = 'A26FF5EE-AF22-DE11-8C4D-005056940368')

ORDER BY FilteredListMember.modifiedon DESC