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 'Popular' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionary' 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!=43431 AND dictionaryenglish.english='People' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43431 AND dictionaryenglish.english='People\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43431 AND dictionaryenglish.english='Popular' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=43431 AND dictionaryenglish.english='everyman,john doe,public,richard roe,agnate,ancestors,ancestry,anchor,animal kingdom,assembly,billet at,bivouac,blood,blood relation,blood relative,bodies,body politic,bourgeoisie,breed,brethren,brood,burrow,camp,children,churchgoers,citizenry,clan,clansman,class,cognate,collateral,collateral relative,colonize,come to anchor,common man,common people,commonage,commonality,commonalty,commoners,commonwealth,community,community at large,congregation,connections,consanguinean,constituency,consumers,cultural community,deme,demos,denizen,distaff side,distant relation,domesticate,drop anchor,dwellers,empeople,enate,ensconce,establish residence,estate,everybody,everyman,everyone,everywoman,family,flesh,flesh and blood,flock,fold,folk,folks,forebears,general public,gens,gentry,german,get,grass roots,habitancy,hearth,hive,hoi polloi,homefolks,house,household,inhabit,inhabitants,issue,keep house,kin,kind,kindred,kinfolk,kinnery,kinsfolk,kinsman,kinsmen,kinswoman,kith and kin,laity,laymen,line,lineage,linguistic community,live at,locate,masses,matriclan,men,menage,minyan,mobile vulgus,moor,mortals,move,multitude,nation,nationality,near relation,nest,next of kin,nonclerics,nonordained persons,occupy,offspring,order,parish,parishioners,park,patriclan,people at large,people in general,perch,persons,phratry,phyle,plant,plant kingdom,plebeians,plebes,polity,populace,populate,population,posterity,proletariat,public,race,ragtag and bobtail,rank and file,relations,relatives,relocate,reside,roost,seculars,sept,set up housekeeping,set up shop,settle,settle down,settle in,sheep,sib,sibling,silent majority,sit down,society,spear kin,spear side,species,speech community,spindle kin,spindle side,squat,stand,state,stay at,stem,stirps,stock,strain,strike root,subjects,sword side,take residence at,take root,take up residence,tenant,the citizenry,the crowd,the general public,the people,the populace,the population,the public,third estate,totem,tribe,tribesman,uterine kin,whole people,world,you and me') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=43431 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: 81773


Go Back ⇒
Go Home ⇒