> > 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;
Try:
SELECT ...
FROM user
LEFT JOIN user_detail
ON user_detail.id = user.details
WHERE user.id > 101
AND user.language = 'en'
...
Make sure you index user.details ...
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
