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 'Kings Wife' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, diction' 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!=59942 AND dictionaryenglish.english='Queen' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59942 AND dictionaryenglish.english='King\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59942 AND dictionaryenglish.english='Kings Wife' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=59942 AND dictionaryenglish.english='kaiserin,ace,ant,army ant,auntie,beauty queen,bee,begum,best bower,bi-guy,bisexual,bishop,black ant,bower,bull dyke,bumblebee,butch,cards,carpenter ant,castle,catamite,champion,chessman,chicken,choice,chosen,clubs,cream,crown princess,cynosure,czarina,deck,deuce,diamonds,diva,drone,dummy,dyke,elect,elite,emmet,empress,epitome,face cards,fag,faggot,fairy,fat,femme,fire ant,flit,flower,flush,fricatrice,fruit,full house,grand duchess,gunsel,hand,hearts,homo,homophile,homosexual,homosexualist,honeybee,hornet,house ant,idol,infanta,invert,jack,joker,king,knave,knight,kumari,kunwari,leader,leading light,left bower,lesbian,maharani,malikzadi,man,model,monarch,nance,nonesuch,nonpareil,optimum,pack,pair,pansy,paragon,pathic,pawn,pick,picture cards,piece,pismire,playing cards,prima donna,prime,princess,princesse,prize,punk,queen bee,queen consort,queen dowager,queen regent,queen regnant,queer,quintessence,raj-kumari,rani,red ant,rook,round,royal flush,rubber,ruff,ruler,sapphist,select,shahzadi,singleton,slave ant,soldier,sovereign,sovereign princess,sovereign queen,spades,star,straight,superlative,termite,the best,the best ever,the tops,the very best,trey,tribade,trick,trump,wasp,worker,yellow jacket') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=59942 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: 81169


Go Back ⇒
Go Home ⇒