OPTION 1:SELECT xc.xar_title, xc.xar_datetime, xc.xar_hostname, xc.xar_text, xr.xar_author, xc.xar_author as xar_uid, xc.xar_cid, xc.xar_pid, xc.xar_status, xc.xar_left, xc.xar_right, xc.xar_postanon FROM xar_comments AS xc LEFT JOIN xar_roles as xr ON xr.xar_uid = xc.xar_author WHERE xc.xar_modid=modid AND xc.xar_status=status AND xc.itemtype=itemtype AND xc.objectid=objectid AND xc.left >= leftlimit AND xc.right <= rightlimitOPTION 2:SELECT xc.xar_title, xc.xar_datetime, xc.xar_hostname, xc.xar_text, xr.xar_author, xc.xar_author as xar_uid, xc.xar_cid, xc.xar_pid, xc.xar_status, xc.xar_left, xc.xar_right, xc.xar_postanon FROM (SELECT * FROM xar_comments AS xc WHERE xc.xar_modid=modid AND xc.xar_status=status AND xc.itemtype=itemtype AND xc.objectid=objectid AND xc.left >= leftlimit AND xc.right <= rightlimit) LEFT JOIN xar_roles as xr ON xr.xar_uid = xc.xar_author