Your query returns the following:
Code:
3 | 1 | x1b2cxd4e5f6y7h8i9j0k102m3nzo5p6 | This is a test Post 2 | The path of the righteous man is beset on all side... | 1348041600 | 1348041602 | replies
2 | 1 | a1b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6 | This is a test Post | The path of the righteous man is beset on all side... | 1348041600 | 1348041601 | comments
2 | 1 | a1b2c3d4e5f6g7h8i9j0k1l2m3n4o5p6 | This is a test Post | The path of the righteous man is beset on all side... | 1348041600 | 1348041600 | posts
3 | 1 | x1b2cxd4e5f6y7h8i9j0k102m3nzo5p6 | This is a test Post 2 | The path of the righteous man is beset on all side... | 1348041600 | 1348041600 | posts
4 | 1 | pq72cxd4e5f6y7igbej0k102m3nzo5pt | This is a test Post 3 | The path of the righteous man is beset on all side... | 1348041600 | 1348041600 | posts
3 | 1 | x1b2cxd4e5f6y7h8i9j0k102m3nzo5p6 | This is a test Post 2 | The path of the righteous man is beset on all side... | 1348041600 | 1348041600 | comments
3 | 1 | x1b2cxd4e5f6y7h8i9j0k102m3nzo5p6 | This is a test Post 2 | The path of the righteous man is beset on all side... | 1348041600 | 1348041600 | replies
This is an improvement on the code, but it is still returning duplicate postId's. Which is one of the main issues I am having.
(P.S. This is my first time working with UNION, so I had no idea UNION ALL existed.)