I am new to SQL report writing, trying to generate report from SQL tables but getting 3 duplicate rows against each desired rows in a result. However, the output data is as per my requirements. The entire code is given below kindly help me to resolve.

```
SELECT 
   v.dateaccessioned AS 'Date', v.barcode AS 'Acc. No.', w.title AS 'Title',
   w.author AS 'Author/Editor', concat_ws(' , ', o.editionstatement, 
   v.enumchron) AS 'Ed./Vol.',
   concat_ws(' ', o.place, o.publishercode) AS 'Place & Publisher',
   w.copyrightdate AS 'Year', o.pages AS 'Page(s)', s.name AS 'Source',
   v.itemcallnumber AS 'Class No./Book No.', concat_ws(', ₹', concat(' ',
   z.symbol, x.listprice), x.rrp_tax_included) AS 'Cost', concat_ws(' , ',
   r.invoicenumber, r.shipmentdate) AS 'Bill No. & Date', '' AS 'Withdrawn 
   Date', '' AS 'Remarks'

FROM biblioitems o
LEFT JOIN items v ON v.biblioitemnumber=o.biblioitemnumber
LEFT JOIN biblio w ON w.biblionumber=o.biblionumber
LEFT JOIN aqorders x ON x.biblionumber=o.biblionumber
LEFT JOIN currency z ON z.currency=x.currency
LEFT JOIN aqinvoices r ON r.booksellerid=v.booksellerid
LEFT JOIN aqbooksellers s ON s.id=v.booksellerid

WHERE v.barcode BETWEEN <<Accession Number>> AND <<To Accession Number>>
ORDER BY v.barcode ASC

```