Activetopics - Get max 5 topics per category
- by Arjen
Hey,
I want to get the 5 latest active topics within several category's. Each topic has a subcatid and this subcatid relates to a catid.
What I want is to get the 5 active topics within each catid.
I'm trying to use the query below, but this isn't working at all:
set @num := 0, @catid := 0;
SELECT
…