Moin,
das sollte dir helfen:
SELECT products_id,products_price AS PRODUCTS_PRICE, products_quantity FROM products WHERE products_id IN (
SELECT products_id FROM products_to_categories WHERE categories_id IN (
SELECT
categories_id
FROM
(
SELECT
@rownum := @rownum+1 AS rownum,
IF(@lastid <> mylist.categories_id, @id := mylist.categories_id, @id) AS pathid,
@lastid := mylist.categories_id AS categories_id,
@id := (SELECT parent_ID FROM categories WHERE categories_id = @id) AS parent_ID
FROM
(SELECT @id := 0, @lastid := 0, @rownum := 0) AS vars,
(SELECT categories_id FROM categories) AS myloop,
(SELECT categories_id FROM categories) AS mylist
) AS t
WHERE
pathid = 1
)
)
Die PathID mußt du natürlich selber ermitteln und die Felder auswählen, die Du ermitteln willst!
vg,
mhbosch