swa66 - 10:21 am on Feb 14, 2013 (gmt 0)
I'd use the one I wrote earlier:
SELECT m.man_name, s.series_name, p.prod_name
FROM products AS p
INNER JOIN series AS s ON s.series_id = p.prod_series
INNER JOIN manufacturers AS m ON m.man_id = s.series_man
ORDER BY m.order, s.order, p.order ;
it will give you all products and add in the related series and manufacturer data.
(You can add more columns to the select as you need them, they're all available of course).
Make sure to set the sorting so that manufacturers and series stay together. I presumed that they all had different order values, if that's not the case: you need more sorting to make sure they stay together.
Then as you iterate over the results, keep track of the previous manufacturer and the previous series (start out with a nonexistent value such as an empty string). Whenever they change: you start a new series or manufacturer as needed.