Probably cardinality changes in your joins to other tables. I can't tell from here.

Try using DISTINCT in your query (it goes immediately after SELECT).

I would suggest you to check the relationships between your tables and find out if duplicating rows in joins is permitted by the database schema or is due to a wrong query.