updated getall items query