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
Aktuelle rejser
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
