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 'accomplish,achieve,act,action,activity,agency,agent,ambition,antecedent,aspirati' 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!=29083 AND dictionaryenglish.english='Cause' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Close' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Near' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Touching' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Like' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Kindred' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Intelligible' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='Within One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=29083 AND dictionaryenglish.english='accomplish,achieve,act,action,activity,agency,agent,ambition,antecedent,aspiration,author,basis,be productive,bear,beget,belief,bind,breed,bring about,bring forth,bring into being,bring on,bring to effect,bring to fruition,bring to pass,call,call forth,call up,calling,campaign,case,cause in court,cause to,commitment,compel,conceive,concern,consideration,constrain,create,creator,crusade,determinant,do,draw on,drive,effect,effectuate,elicit,enforce,engender,engineer,establish,evoke,execute,faith,father,force,found,foundation,generate,generator,genesis,gestate,get up,give birth to,give occasion to,give origin to,give rise to,goad,goal,good reason,great cause,ground,grounds,guiding light,guiding star,hatch,have,ideal,impel,impulse,inaugurate,incentive,induce,inducement,industrialize,inspiration,inspire,institute,intention,interest,issue,judicial process,justification,lawsuit,lead to,legal action,legal case,legal proceedings,legal process,legal remedy,lifework,litigation,lodestar,mainspring,make,mass movement,mass-produce,material basis,matter,motivate,motive,movement,muster up,necessity,obligation,occasion,origin,originate,originator,overproduce,perform,precipitate,prime mover,principle,proceedings,produce,producer,promote,prompt,prosecution,provoke,realize,reason,reason for being,restrain,right,root,sake,score,secure,set afloat,set on foot,set up,sire,source,spring,substance,suit,suit at law,summon up,tie,ulterior motive,undertaking,use force upon,vocation,volume-produce,warrant,work,work up') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=29083 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: 84480