connz: limit and offset, and others minor fixes