Also ich habe mal folgendes mit variablen probiert:
SELECT
Category.id AS `Category.id`,
Category.name AS `Category.name`,
Forum.id AS `Forum.id`,
Forum.name AS `Forum.name`,
Forum.modified AS `Forum.modified`,
@catId:=Category.id AS catId
FROM
forum_categories AS...