SELECT *, MATCH(keyword) AGAINST( 'video,media,avi,mpg,wmv,mpeg,jpg,bmp,gif,picture,photo,multimedia,free,lock,prevent,protect,access,password,encrypt,decrypt,windows,software,shareware,freeware,pro,free,trial,xp,nt,2000' IN BOOLEAN MODE ) AS score FROM sds_soft_basic_info WHERE MATCH (keyword) AGAINST ('video,media,avi,mpg,wmv,mpeg,jpg,bmp,gif,picture,photo,multimedia,free,lock,prevent,protect,access,password,encrypt,decrypt,windows,software,shareware,freeware,pro,free,trial,xp,nt,2000' IN BOOLEAN MODE) and sid!=53481 ORDER BY score DESC LIMIT 0,7;
Mysql error:Error writing file '/tmp/MYPafNdA' (Errcode: 122)
Mysql error number:3