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 'albigensian,catharist,diogenes,franciscan,hieronymian,hieronymite,sabbatarian,ti' 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!=14402 AND dictionaryenglish.english='Hermit' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=14402 AND dictionaryenglish.english='Recluse' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=14402 AND dictionaryenglish.english='Ascetic' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=14402 AND dictionaryenglish.english='Priest' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=14402 AND dictionaryenglish.english='Scholar' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=14402 AND dictionaryenglish.english='\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=14402 AND dictionaryenglish.english='albigensian,catharist,diogenes,franciscan,hieronymian,hieronymite,sabbatarian,timon of athens,trappist,waldensian,abbacomes,abbot,abstainer,alien,anchoress,anchoret,anchorite,ascetic,beadsman,bedridden invalid,bhikshu,brother,caloyer,case,celibate,cenobite,character,cloistered monk,closet cynic,conventual,conventual prior,crackpot,crank,dervish,desert fathers,desert saints,eccentric,eremite,fakir,fanatic,flagellant,friar,grand prior,hermitess,hieromonach,hobo,homebody,invalid,isolationist,kook,lay abbot,lay brother,lone wolf,loner,marabout,maverick,mendicant,meshuggenah,monastic,monk,natural,nonconformist,nut,odd fellow,oddball,oddity,original,outcast,outsider,palmer,pariah,pilgrim,pillar saint,pillarist,prior,puritan,queer duck,queer fish,queer specimen,rara avis,recluse,religieux,religious,sannyasi,screwball,seclusionist,shut-in,solitaire,solitary,solitudinarian,stay-at-home,stylite,tramp,type,yogi,yogin,zealot') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=14402 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: 84419


Go Back ⇒
Go Home ⇒