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 'abscess,ache,aching,ague,anemia,angina,ankylosis,anoxia,apnea,asphyxiation,asthm' 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!=31442 AND dictionaryenglish.english='Colic' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31442 AND dictionaryenglish.english='Alzheimer\' UNION ALL SELECT dictionaryenglish.dictionary AS dictionary, dictionaryenglish.id AS deid FROM dictionaryenglish WHERE dictionaryenglish.`member`=1 AND dictionaryenglish.dictionary!=31442 AND dictionaryenglish.english='abscess,ache,aching,ague,anemia,angina,ankylosis,anoxia,apnea,asphyxiation,asthma,ataxia,atrophy,backache,bellyache,bleeding,blennorhea,cachexia,cachexy,cardialgia,cephalalgia,chill,chills,cholera morbus,collywobbles,constipation,convulsion,costiveness,coughing,cyanosis,diarrhea,dizziness,dropsy,dysentery,dyspepsia,dyspnea,earache,edema,emaciation,fainting,fatigue,fever,fibrillation,flux,fret,gnawing,gripe,gripes,growth,gut-ache,headache,heartburn,hemicrania,hemorrhage,high blood pressure,hydrops,hypertension,hypotension,icterus,indigestion,inflammation,insomnia,irregularity,itching,jaundice,labored breathing,lientery,low blood pressure,lumbago,marasmus,megrim,migraine,nasal discharge,nausea,necrosis,obstipation,odontalgia,otalgia,pain,paralysis,pruritus,pyrosis,rash,rheum,sclerosis,seizure,shock,sick headache,skin eruption,sneezing,sore,spasm,splitting headache,stomachache,tabes,tachycardia,throbbing pain,toothache,trots,tumor,upset stomach,vertigo,vomiting,wasting') candidates INNER JOIN dictionary ON dictionary.id=candidates.dictionary LEFT JOIN dictionarysynonyms ON dictionarysynonyms.dictionary=31442 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: 84476


Go Back ⇒
Go Home ⇒