Re: [support] Converting a query to D7

Same as Boobatower's. Not working for me.

Nancy  Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

---

From: sivaji j.g sivaji2009@gmail.com To: support@drupal.org; Ms. Nancy Wichmann nan_wich@bellsouth.net Sent: Tuesday, October 11, 2011 1:05 PM Subject: Re: [support] Converting a query to D7

On Tue, Oct 11, 2011 at 9:05 PM, Ms. Nancy Wichmann nan_wich@bellsouth.net wrote:

...

Before I pull any more hair out, can someone properly convert this to a D7 select query, please: SELECT ubr.rid, ubb.* FROM {user_badges_roles} ubr INNER JOIN {user_badges_badges} ubb ON ubb.bid = ubr.bid WHERE ubr.rid = %d

I use this online service http://jonduell.com/sql-parser. It always worked good for my needs.