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 'Spiderweb' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictiona' 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!=60022 AND dictionaryenglish.english='Wool' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60022 AND dictionaryenglish.english='Fur' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60022 AND dictionaryenglish.english='Cobweb' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60022 AND dictionaryenglish.english='Spider\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60022 AND dictionaryenglish.english='Spiderweb' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=60022 AND dictionaryenglish.english='aralac,avisco,celanese,chemstrand,dacron,dynel,lastex,manila,orlon,terylene,velon,vicara,acetate rayon,alpaca,angora,bast,blubber,breeze,bristle,butter,capillament,cashmere,cilium,clay,cloth,coat,coir,cotton,cushion,dough,down,drapery,eiderdown,etoffe,fabric,feather bed,feathers,felt,flax,fleece,floss,flue,fluff,foam,fur,goods,hair,hemp,horsehair,jute,kapok,lace,linen,llama hair,mane,material,merino,mohair,napery,near-silk,nylon,oakum,pelt,pile,pillow,plush,pubescence,pubic hair,pudding,puff,putty,raffia,rag,rayon,rubber,satin,setula,shag,silk,sisal,spandex,spun rayon,stuff,swansdown,textile,textile fabric,texture,thistledown,tissu,tissue,tussah,velvet,wax,weave,web,weft,woof,worsted,yarn,zephyr') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=60022 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: 81983


Go Back ⇒
Go Home ⇒