[webgroup]

I keep receiving this error:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT user.*,usertextfield.*,userfield.*, user.userid, options, fbuser.fbuid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

, IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime



FROM vbnewuser AS user
LEFT JOIN vbnewfbuser AS fbuser ON(user.userid = fbuser.userid)
LEFT JOIN vbnewusertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN vbnewuserfield AS userfield ON(userfield.userid=user.userid)

LEFT JOIN vbnewavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbnewcustomavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1
AND (user.usergroupid IN (-1,6,26,18,23,25,7,21,22,2,20,5))

ORDER BY user.username asc
LIMIT 47600, 100;

MySQL Error : Incorrect key file for table '/tmp/#sql_3714_3.MYI'; try to repair it
Error Number : 126
Request Date : Monday, June 29th 2009 @ 08:32:26 AM
Error Date : Monday, June 29th 2009 @ 08:34:23 AM

YES, I know the error looks like a corrupted DB and reparing it will fix it, but no.
I have ran repairs in the DB many times, ALL is fine, still I keep getting this error.

PLease help.