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 'muslim rulers,prinz,acceptable person,anointed king,atheling,baron,capital fello' 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!=61376 AND dictionaryenglish.english='Prince' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61376 AND dictionaryenglish.english='King\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=61376 AND dictionaryenglish.english='muslim rulers,prinz,acceptable person,anointed king,atheling,baron,capital fellow,chief,chieftain,crown prince,crowned head,czar,diamond,dynast,emir,emperor,gem,gentleman,good fellow,good lot,good man,good person,good sort,good woman,grand duke,heir apparent,heir presumptive,high chief,honest man,imperator,jewel,khan,king,king-emperor,kinglet,knez,lady,lord paramount,majesty,mensch,merchant,mirza,monarch,overlord,paramount,pearl,perfect gentleman,perfect lady,persona grata,petty king,potentate,prince consort,prince regent,princeling,princes of india,real man,right sort,rough diamond,royal,royal personage,royalty,ruler,shahzada,sheikh,sherif,sovereign,suzerain,tetrarch,tycoon,worthy') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=61376 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: 80951


Go Back ⇒
Go Home ⇒