SELECT c.C_ID, c.C_ModID, c.C_TID, c.C_Poster, c.C_PosterID, c.C_Text, c.C_Date, m.joined, m.member_group_id, n.M_Perms, m.signature, m.pp_main_photo as avatar
FROM garage_comments c
LEFT JOIN gtaf.ibf_core_members m ON (c.C_PosterID=m.member_id)
LEFT JOIN ibf_core_groups g ON (m.member_group_id=g.g_id)
LEFT JOIN garage_modders n ON (m.member_id=n.M_ID)
WHERE C_ModID = 434
ORDER BY C_ID
LIMIT 0,20