queries for sparksee added