Sql: Limit Rows Linked To Each Joined Row

I've certain situation that requires certain result set from MySQL query, let's see the current query first & then ask my question: SELECT thread.dateline AS tdateline, po

Solution 1:

Maybe this SO question: "limit the number of rows to join to in mysql" or more precisely its pointer to How to select the first/least/max row per group in SQL could help.

It all comes down to subqueries though I think.