---

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.