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 'Returning To' 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!=57094 AND dictionaryenglish.english='Rejection' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57094 AND dictionaryenglish.english='Not Replying' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57094 AND dictionaryenglish.english='Incomparable\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57094 AND dictionaryenglish.english='Not Returning To' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=57094 AND dictionaryenglish.english='eighteenth amendment,prohibition party,volstead act,abnegation,agnosticism,agreement to disagree,alienation,apostasy,atheism,ban,bar,barring,blackball,blackballing,blockade,booting out,boycott,bucking,castaway,castoff,challenge,circumscription,cold shoulder,complaint,contention,contraband,contradiction,contraposition,contravention,contraversion,counter-culture,counteraction,counterworking,crosscurrent,crossing,debarment,debarring,declension,declination,declinature,declining,deep six,defenestration,demarcation,denial,deprivation,detrusion,difference,dim view,disaccord,disagreement,disallowance,disappointment,disapprobation,disapproval,disbelief,discard,discarding,discharge,disclaimer,disclamation,discontent,discontentedness,discontentment,discredit,disenchantment,disesteem,disfavor,disgruntlement,disillusion,disillusionment,dismissal,disobedience,disparity,displeasure,disposal,disrespect,dissatisfaction,dissension,dissent,dissentience,dissidence,distaste,diversity,dropping out,dumping,ejection,ejectment,elimination,embargo,exception,exclusion,expulsion,extrusion,forbiddance,forbidden fruit,forbidding,head wind,heresy,holding back,impugnation,impugnment,inability to believe,inadmissibility,incredulity,index,index expurgatorius,index librorum prohibitorum,indignation,infidelity,inhibition,injunction,interdict,interdiction,interdictum,jettison,junking,kicking downstairs,law,lockout,low estimation,low opinion,minimifidianism,minority opinion,misbelief,narrowing,nay,negation,negative,negative answer,nix,no,no-no,nonacceptance,nonadmission,nonagreement,nonassent,nonbelief,noncompliance,nonconcurrence,nonconformity,nonconsent,nonobservance,nullifidianism,objection,obtrusion,omission,opposing,opposition,opposure,oppugnation,ostracism,ouster,ousting,preclusion,prevention,prohibition,prohibitory injunction,proscription,protest,rebuff,rebutment,rebuttal,recantation,recusance,recusancy,refusal,refuse,reject,rejectamenta,relegation,removal,renunciation,repression,repudiation,resistance,restriction,restrictive covenants,retention,ruling out,scrapping,secession,spurning,standing against,statute,sumptuary laws,suppression,taboo,the boot,the bounce,throwaway,throwing out,thumbs-down,traversal,turndown,unbelief,unbelievingness,undercurrent,underground,unhappiness,unwillingness,variance,withdrawal,withholding,zoning,zoning laws') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=57094 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: 81982


Go Back ⇒
Go Home ⇒