load method query re wrote decomposing the query in to two