SELECT *
FROM GMS_FILE
INNER JOIN (
SELECT UID, ACC, title, organism, mode, shareusers, keywords
FROM GMS
WHERE
(mode = 'public' AND active = 'on' AND keywords LIKE '%Sjogren's syndrome %' )
) AS T1
ON T1.ACC = GMS_FILE.ACC
ORDER BY GMS_FILE.ACC ASC
runQuery(): SQLSTATE[42000]: Syntax error or access violation: 1064 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 's syndrome %' ) ) AS T1 ON T1.ACC = GMS_FILE.ACC ORDER BY GMS_FIL' at line 7
runQuery(): SQLSTATE[42000]: Syntax error or access violation: 1064 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 's syndrome %' ) ) AS T1 ON T1.ACC = GMS_FILE.ACC ORDER BY GMS_FIL' at line 7
Keyword >> Sjogren's syndrome
Accession | File (0) | Cell/Tissue | Keywords |
---|