SQL ERROR

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Try Hard To' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictio' at line 1

SELECT candidates.dictionary AS id, COUNT(DISTINCT candidates.deid) AS total, IF(dictionary.level>0,1,0) AS haslevel, dictionarysynonyms.dictionary AS ds FROM (SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='Strive' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='To' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='Strive To' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='Ready With' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='Do One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='Try Hard To' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='Do Ones Utmost' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=47579 AND dictionaryenglish.english='agonize,aim,aim to,assay,attempt,attempt to,battle,be determined,box,brawl,broil,buffet,clash,close,collide,combat,come to blows,compete,contend,contest,cut and thrust,dare to,drive,duel,endeavor,essay,exchange blows,fence,feud,fight,fight a duel,give and take,give satisfaction,go all out,grapple,grapple with,grunt and sweat,hassle,huff and puff,jostle,joust,labor,make every effort,mix it up,moil,offer,pretend to,quarrel,rassle,resolve,riot,run a tilt,scramble,scuffle,seek,seek to,skirmish,spar,strain,strive to,struggle,study,study to,sweat,sweat blood,thrust and parry,tilt,toil,tourney,travail,try,try and,try hard,try to,tug,tussle,undertake,venture to,wage war,war,work,work at,wrestle') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=47579 AND dictionarysynonyms.synonym=candidates.dictionary WHERE (dictionarysynonyms.ismatch IS NULL OR dictionarysynonyms.ismatch=1) GROUP BY candidates.dictionary ORDER BY ismatch DESC, total DESC, haslevel DESC, dictionary.level LIMIT 40

Error Table ID: 82266


Go Back ⇒
Go Home ⇒