SELECT id WHERE ( (key1 IS "foo") AND (key2 IS "bar)) OR (key4 < 10)