Select DocumentID,DocumentTypeID,Company,Price,Image,Title,Summary,Users.UserID,Image,EndDate From Document,Users,Subject,Country Where Document.SubjectID = Subject.SubjectID And Document.CountryID = Country.CountryID And Document.UserID = Users.UserID And Document.DocumentStatus = 1 And Document.DocumentTypeID = 3 And Document.StartDate <= Now() And Document.EndDate >= Now() Order By Rand() Limit 7
Select DocumentID,DocumentTypeID,Company,Price,Image,Title,Summary,Users.UserID,Image,EndDate From Document,Users,Subject,Country Where Document.SubjectID = Subject.SubjectID And Document.CountryID = Country.CountryID And Document.UserID = Users.UserID And Document.DocumentStatus = 1 And Document.DocumentTypeID = 4 And Document.StartDate <= Now() And Document.EndDate >= Now() Order By Rand() Limit 7
Bornholms Sportsfiskerforening og Motorklubben Columbus ejer en fiskekutter ved navn Hansa af Årsdale. De arrangere ture ca. hver 14. dag. Det er muligt at deltage hvis du er medlem af en af de to klubber.
