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
Forening af interesserede sportsfiskere, som gennem organisation søger at fremme medlernes adgang til sportsfiskeri samt pleje fiskebestanden i foreningens fiskevande som er Vindinge Å, Ørbæk Å, Kongshøj Å, Ladegårds Å, Holdsted Å i Jylland
www.nyborgsportsfiskerforening.dk - Fiskeri - Dansk
