> > Im running the following query:
> >
> > SELECT
> > user.nickname,
> > user.id,
> > user_detail.points
> > FROM
> > user,
> > user_detail
> > WHERE
> > user.details = user_detail.id
> > AND user.id > 101
> > AND user.language = 'en'
> > ORDER BY user_detail.point
* Maximo Migliari
> Im running the following query:
>
> SELECT
> user.nickname,
> user.id,
> user_detail.points
> FROM
> user,
> user_detail
> WHERE
> user.details = user_detail.id
> AND user.id > 101
> AND user.language = 'en'
> ORDER BY user_detail.
John Ragan wrote:
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id > 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
I don't really know how LEFT JOINS, INNER
> Im running the following query:
>
> SELECT
> user.nickname,
> user.id,
> user_detail.points
> FROM
> user,
> user_detail
> WHERE
> user.details = user_detail.id
> AND user.id > 101
> AND user.language = 'en'
> ORDER BY user_detail.points DESC
> L
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id > 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
It basically lets me know the top 5 contributors to my website.
