here is my sql query....it's kind of gnarly:#1271 - Illegal mix of collations for operation ' IN '
Code: Select all
SELECT *
FROM lp_files
WHERE id
IN (
SELECT fileid
FROM lp_gradelevels
WHERE grlevel
IN (
'1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13'
)
)
AND (
filetype
IN (
'image'
)
)
AND id
IN (
SELECT fileid
FROM lp_subjects
WHERE subject
IN (
'foreign', 'health', 'math', 'reading', 'socialstudies', 'science', 'study', 'technology'
)
)
AND id
IN (
SELECT fileid
FROM lp_topics
WHERE topic
IN (
'spanish', 'chinese', 'japanese', 'french', 'german', 'physed', 'nutrition', 'geometry', 'prea', 'algebra', 'prec', 'cal', 'reading', 'writing', 'spelling', 'phonics', 'ushistory', 'worldhistory', 'geography', 'economics', 'civics', 'biology', 'chemistry', 'physics', 'earth', 'life', 'space', 'notetaking', 'organization', 'timeman', 'skills', 'applications'
)
)
AND title LIKE '%'any ideas here?