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 'Royal Family' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dicti' 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!=48460 AND dictionaryenglish.english='Empire' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=48460 AND dictionaryenglish.english='Reigning King\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=48460 AND dictionaryenglish.english='Royal Family' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=48460 AND dictionaryenglish.english='administration,ally,archduchy,archdukedom,authority,body politic,buffer state,caliphate,captive nation,chieftaincy,chieftainry,city-state,civil government,claws,clutches,colony,command,commonweal,commonwealth,control,country,county,czardom,direction,discipline,dispensation,disposition,domain,dominion,duchy,dukedom,earldom,emperorship,empery,form of government,free city,governance,government,grand duchy,grip,hand,hands,imperialism,iron hand,jurisdiction,kaiserdom,kinghood,kingship,land,majesty,management,mandant,mandate,mandated territory,mandatee,mandatory,nation,nationality,oversight,polis,political organization,polity,possession,power,principality,principate,protectorate,province,puppet government,puppet regime,queenhood,queenship,raj,rajaship,realm,regime,regimen,regnancy,regulation,reign,republic,royalty,rule,satellite,seneschalty,settlement,sovereign nation,sovereignty,state,sultanate,sultanship,superpower,supervision,sway,system of government,talons,territory,the crown,the throne,toparchia,toparchy') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=48460 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: 82576


Go Back ⇒
Go Home ⇒