Recent posts:
Syed Saif ur has not published any posts yet.
Recent replies:

In my opinion, the result can be achieved using a join:

SELECT column1, column2, column 3
    FROM  table
    join table2 on
    table.column1 = table2.c1
    and
    table.column2 = table2.c2

Followers:
Syed Saif ur has no followers yet.
Following:
Syed Saif ur has not followed anybody yet.
Global Masters badges:
Syed Saif ur has no Global Masters badges yet.