question: Which Venue has a Kitmaker of lotto, and a Team of apoel?
answer: SELECT venue FROM table_name_37 WHERE kitmaker = "lotto" AND team = "apoel"
context: CREATE TABLE table_name_37 (venue VARCHAR, kitmaker VARCHAR, team VARCHAR)