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 'Turn' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryeng' 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!=25109 AND dictionaryenglish.english='Turn Over' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Over' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Overturn' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Topple' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Head Up' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='On One\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Turn' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Turn Face Up' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Set Face Up' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='Face Up' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=25109 AND dictionaryenglish.english='abalienate,alien,alienate,amortize,assign,barter,be lost,bequeath,break,brood over,capsize,careen,carry over,cede,chaw,chew over,circulate,close out,come across with,communicate,con over,confer,consign,convert,convert into cash,convey,crease,crimp,crisp,culbuter,cut under,deed,deed over,deliberate,deliberate over,deliberate upon,deliver,deliver over,demise,deport,devolve upon,diffuse,digest,disseminate,distribute,dog-ear,double,double over,dump,effect a sale,enfeoff,enfold,evert,exchange,expel,export,extradite,flounce,flute,fold,fold over,fork over,forward,founder,frill,gather,give,give in,give out,give over,give title to,go down,hand,hand down,hand forward,hand in,hand on,hand out,hand over,impart,import,infold,interfold,introvert,intussuscept,invaginate,inverse,invert,job,keel,keel over,knock over,lap over,make a sale,make over,market,meditate,meditate upon,merchandise,metastasize,metathesize,move,mull,mull over,muse on,muse over,negotiate,overset,overthrow,overturn,pass,pass on,pass out,pass over,pass the buck,perfuse,pitchpole,plait,plat,pleat,plicate,ply,ponder over,pronate,quill,reach,reflect over,relay,relegate,render,resell,resign,resupinate,retail,reverse,revolve,rotate,ruff,ruffle,ruminate over,run over,sacrifice,scuttle,sell,sell off,sell on consignment,sell out,sell over,sell retail,sell short,sell up,sell wholesale,settle,settle on,sign away,sign over,sink,somersault,spread,subvert,supinate,surrender,switch,think over,tip over,topple,topple over,topsy-turvify,topsy-turvy,trade,transfer,transfer property,transfuse,translate,translocate,transmit,transplace,transplant,transpose,tuck,turn,turn a somersault,turn about,turn around,turn down,turn in,turn inside out,turn into money,turn out,turn the scale,turn the tables,turn topsy-turvy,turn turtle,turn upside down,twill,undercut,undersell,unload,upset,upset the boat,upturn,wholesale') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=25109 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: 82313