5 : SELECT Distinct Activity.ID AS ID, Activity.Active AS Active, Activity.dir AS Dir, Activity.type AS Type, Activity.title AS Title, Activity.comment AS Titlecomment, Activity.date AS Date1, Activity.date2 AS Date2, Activity_Foto.image AS [Image], Activity_Foto.comment AS Imagecomment
6 : FROM Activity INNER JOIN Activity_Foto ON Activity.ID = Activity_Foto.ID
7 : WHERE (((Activity.ID)=#URL.EventId#) AND ((Activity.Active)=True))
8 :
9 : <cfif #URL.Sort# is 1>
|