check the query created in the application to check the data extracted from the database as well as check what is the cause of the discrepancies
as per checking, there are duplicate data return when executed the newly created query to see each data and to check the cause of an error
this needs to be discussed with Sir Ian, to double-check if why is there duplicate data