Nette database 2.4.9 translates query code $database->query("SELECT * FROM table WHERE ? <= date_to AND ? >= date_from AND type_id IN (?)", "2020-04-01 00:00:00", "2020-04-02 00:00:00", [1,2]); into query SELECT * FROM table WHERE '2020-04-01 00:00:00' <= date_to AND '2020-04-02 00:00:00' >= date_from AND type_id IN ((1) AND (2)) Query with placed IN at beginning is ok. $database->query("SELECT * FROM table WHERE type_id IN (?) AND ? <= date_to AND ? >= date_from", [1,2], "2020-04-01 00:00:00", "2020-04-02 00:00:00");