let’s give an example…
say you have product XYZ which has 5 flavours, 3 sources, and 7 ingredients
your query will produce 105 rows for product XYZ – please tell me you understand this
if not, you may google “cross join effects”
there are also several threads here on sitepoint which talk about this – read them carefully