You could create views to encapsulate the long/complicated queries; for syntax and examples check this:...
Separate names with a comma.