SELECT tableX.a
, tableX.b
, tableX.c
, tableY.a
, tableY.b
, tableY.c
, ( SELECT COUNT(*)
FROM tableZ
WHERE tableZ.parentForum = tableX.forumId ) AS num_rows
FROM tableX
INNER
JOIN tableY
ON tableY.authorId = tableX.id
1 Like