<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div style="font-family: arial,helvetica,sans-serif;"><span>Same as Boobatower's. Not working for me.<br></span></div><div style="font-family: arial,helvetica,sans-serif;"> </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><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span
style="font-weight:bold;">From:</span></b> sivaji j.g <sivaji2009@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> support@drupal.org; Ms. Nancy Wichmann <nan_wich@bellsouth.net><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, October 11, 2011 1:05 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [support] Converting a query to D7<br></font><br>
On Tue, Oct 11, 2011 at 9:05 PM, Ms. Nancy Wichmann<br><<a ymailto="mailto:nan_wich@bellsouth.net" href="mailto:nan_wich@bellsouth.net">nan_wich@bellsouth.net</a>> wrote:<br>> Before I pull any more hair out, can someone properly convert this to a D7<br>> select query, please:<br>> SELECT ubr.rid, ubb.* FROM {user_badges_roles} ubr INNER JOIN<br>> {user_badges_badges} ubb ON ubb.bid = ubr.bid WHERE ubr.rid = %d<br><br>I use this online service http://jonduell.com/sql-parser. It always<br>worked good for my needs.<br></div></div></blockquote></div></div></body></html>