<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>Before I pull any more hair out, can someone properly convert this to a D7 select query, please:</span></div><div style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><font size="2"><span>SELECT ubr.rid, ubb.* FROM {user_badges_roles} ubr INNER JOIN {user_badges_badges} ubb ON ubb.bid = ubr.bid WHERE ubr.rid = %d</span></font></div><div><br><span></span></div><div><span>It didn't seem all that difficult, but I keep getting errors.<br></span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><strong>Nancy</strong></i></font></div> <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div></div></body></html>