Database error: Invalid SQL: SELECT COUNT(*) AS count FROM ( SELECT aking_UsingEnglish.upload_files.id, aking_UsingEnglish.upload_files.title, aking_UsingEnglish.upload_files.date_added AS datetime, DATE_FORMAT(aking_UsingEnglish.upload_files.date_added, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.upload_files.author_id, DATE_FORMAT(aking_UsingEnglish.upload_files.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, DATE_FORMAT(aking_UsingEnglish.upload_files.last_edit, '%D %M %Y at %H:%i') AS last_edit, aking_UsingEnglish.upload_files.last_edited_by, '0' AS members_only, 'Upload' AS contrib_type_str, '0' AS contrib_type_id, aking_UsingEnglish.upload_files.filename AS filename, aking_UsingEnglish.upload_files.pending, IF(aking_UsingEnglish.upload_files.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.upload_files WHERE aking_UsingEnglish.upload_files.pending = 0 UNION ALL SELECT aking_UsingEnglish.articles.id, aking_UsingEnglish.articles.heading AS title, aking_UsingEnglish.articles.datetime, DATE_FORMAT(aking_UsingEnglish.articles.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.articles.author_id, DATE_FORMAT(aking_UsingEnglish.articles.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.articles.last_edit, aking_UsingEnglish.articles.last_edited_by, aking_UsingEnglish.articles.membersonly AS members_only, 'Article' AS contrib_type_str, '1' AS contrib_type_id, aking_UsingEnglish.articles.filename AS filename, aking_UsingEnglish.articles.pending, IF(aking_UsingEnglish.articles.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.articles WHERE aking_UsingEnglish.articles.pending = 0 UNION ALL SELECT aking_UsingEnglish.idioms.idiom_id AS id, aking_UsingEnglish.idioms.idiom AS title, aking_UsingEnglish.idioms.datetime, DATE_FORMAT(aking_UsingEnglish.idioms.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.idioms.author_id, DATE_FORMAT(aking_UsingEnglish.idioms.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.idioms.last_edit, aking_UsingEnglish.idioms.last_edited_by, aking_UsingEnglish.idioms.is_sensitive AS members_only, 'Idiom' AS contrib_type_str, '2' AS contrib_type_id, '' AS filename, aking_UsingEnglish.idioms.pending, IF(aking_UsingEnglish.idioms.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.idioms WHERE aking_UsingEnglish.idioms.idiom_type = '1' AND aking_UsingEnglish.idioms.pending = 0 UNION ALL SELECT aking_UsingEnglish.idioms.idiom_id AS id, aking_UsingEnglish.idioms.idiom AS title, aking_UsingEnglish.idioms.datetime, DATE_FORMAT(aking_UsingEnglish.idioms.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.idioms.author_id, DATE_FORMAT(aking_UsingEnglish.idioms.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.idioms.last_edit, aking_UsingEnglish.idioms.last_edited_by, '1' AS members_only, 'Cockney Rhyming Slang' AS contrib_type_str, '3' AS contrib_type_id, '' AS filename, aking_UsingEnglish.idioms.pending, IF(aking_UsingEnglish.idioms.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.idioms WHERE aking_UsingEnglish.idioms.idiom_type = '2' AND aking_UsingEnglish.idioms.pending = 0 UNION ALL SELECT aking_UsingEnglish.idioms.idiom_id AS id, aking_UsingEnglish.idioms.idiom AS title, aking_UsingEnglish.idioms.datetime, DATE_FORMAT(aking_UsingEnglish.idioms.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.idioms.author_id, DATE_FORMAT(aking_UsingEnglish.idioms.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.idioms.last_edit, aking_UsingEnglish.idioms.last_edited_by, '1' AS members_only, 'English Slang' AS contrib_type_str, '4' AS contrib_type_id, '' AS filename, aking_UsingEnglish.idioms.pending, IF(aking_UsingEnglish.idioms.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.idioms WHERE aking_UsingEnglish.idioms.idiom_type = '3' AND aking_UsingEnglish.idioms.pending = 0 UNION ALL SELECT aking_UsingEnglish.idioms.idiom_id AS id, aking_UsingEnglish.idioms.idiom AS title, aking_UsingEnglish.idioms.datetime, DATE_FORMAT(aking_UsingEnglish.idioms.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.idioms.author_id, DATE_FORMAT(aking_UsingEnglish.idioms.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.idioms.last_edit, aking_UsingEnglish.idioms.last_edited_by, '1' AS members_only, 'Swearing' AS contrib_type_str, '5' AS contrib_type_id, '' AS filename, aking_UsingEnglish.idioms.pending, IF(aking_UsingEnglish.idioms.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.idioms WHERE aking_UsingEnglish.idioms.idiom_type = '4' AND aking_UsingEnglish.idioms.pending = 0 UNION ALL SELECT aking_UsingEnglish.idioms.idiom_id AS id, aking_UsingEnglish.idioms.idiom AS title, aking_UsingEnglish.idioms.datetime, DATE_FORMAT(aking_UsingEnglish.idioms.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.idioms.author_id, DATE_FORMAT(aking_UsingEnglish.idioms.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.idioms.last_edit, aking_UsingEnglish.idioms.last_edited_by, '1' AS members_only, 'Chatlish' AS contrib_type_str, '6' AS contrib_type_id, '' AS filename, aking_UsingEnglish.idioms.pending, IF(aking_UsingEnglish.idioms.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.idioms WHERE aking_UsingEnglish.idioms.idiom_type = '5' AND aking_UsingEnglish.idioms.pending = 0 UNION ALL SELECT aking_UsingEnglish.phrasal_verbs.verb_id AS id, aking_UsingEnglish.phrasal_verbs.verb AS title, aking_UsingEnglish.phrasal_verbs.datetime, DATE_FORMAT(aking_UsingEnglish.phrasal_verbs.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.phrasal_verbs.author_id, DATE_FORMAT(aking_UsingEnglish.phrasal_verbs.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.phrasal_verbs.last_edit, aking_UsingEnglish.phrasal_verbs.last_edited_by, aking_UsingEnglish.phrasal_verbs.is_sensitive AS members_only, 'Phrasal Verb' AS contrib_type_str, '7' AS contrib_type_id, '' AS filename, aking_UsingEnglish.phrasal_verbs.pending, IF(aking_UsingEnglish.phrasal_verbs.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.phrasal_verbs WHERE aking_UsingEnglish.phrasal_verbs.pending = 0 UNION ALL SELECT aking_UsingEnglish.glossary.id, aking_UsingEnglish.glossary.pagename AS title, aking_UsingEnglish.glossary.datetime, DATE_FORMAT(aking_UsingEnglish.glossary.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.glossary.author_id, DATE_FORMAT(aking_UsingEnglish.glossary.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.glossary.last_edit, aking_UsingEnglish.glossary.last_edited_by, '0' AS members_only, 'Glossary Entry' AS contrib_type_str, '8' AS contrib_type_id, aking_UsingEnglish.glossary.filename AS filename, aking_UsingEnglish.glossary.pending, IF(aking_UsingEnglish.glossary.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.glossary WHERE aking_UsingEnglish.glossary.pending = 0 UNION ALL SELECT aking_UsingEnglish.quiz_quizzes.quiz_id AS id, aking_UsingEnglish.quiz_quizzes.heading AS title, aking_UsingEnglish.quiz_quizzes.datetime, DATE_FORMAT(aking_UsingEnglish.quiz_quizzes.datetime, '%D %M %Y at %H:%i') AS date_added, aking_UsingEnglish.quiz_quizzes.author_id, DATE_FORMAT(aking_UsingEnglish.quiz_quizzes.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_UsingEnglish.quiz_quizzes.last_edit, aking_UsingEnglish.quiz_quizzes.last_edited_by, aking_UsingEnglish.quiz_quizzes.membersonly AS members_only, 'Quiz/Handout' AS contrib_type_str, '9' AS contrib_type_id, '' AS filename, aking_UsingEnglish.quiz_quizzes.pending, IF(aking_UsingEnglish.quiz_quizzes.pending = 0, 'Published', 'Pending') AS pending_str FROM aking_UsingEnglish.quiz_quizzes WHERE aking_UsingEnglish.quiz_quizzes.pending = 0 UNION ALL SELECT ue_MT.mt_entry.entry_id AS id, ue_MT.mt_entry.entry_title AS title, ue_MT.mt_entry.entry_created_on AS datetime, DATE_FORMAT(ue_MT.mt_entry.entry_created_on, '%D %M %Y at %H:%i') AS date_added, ( SELECT aking_UsingEnglish.staff.id FROM aking_UsingEnglish.staff WHERE aking_UsingEnglish.staff.weblog_id = ue_MT.mt_entry.entry_author_id LIMIT 1 ) AS author_id, DATE_FORMAT(ue_MT.mt_entry.entry_modified_on, '%D %M %Y at %H:%i') AS last_edit_date, ue_MT.mt_entry.entry_modified_on AS last_edit, ( SELECT aking_UsingEnglish.staff.id FROM aking_UsingEnglish.staff WHERE aking_UsingEnglish.staff.weblog_id = ue_MT.mt_entry.entry_modified_by LIMIT 1 ) AS last_edited_by, '0' AS members_only, 'ESL Blog' AS contrib_type_str, '10' AS contrib_type_id, '' AS filename, IF(ue_MT.mt_entry.entry_status = 2, '0', '1') AS pending, IF(ue_MT.mt_entry.entry_status = 2, 'Published', 'Pending') AS pending_str FROM ue_MT.mt_entry WHERE ue_MT.mt_entry.entry_blog_id = 2 AND ue_MT.mt_entry.entry_status = 2 UNION ALL SELECT ue_MT.mt_entry.entry_id AS id, ue_MT.mt_entry.entry_title AS title, ue_MT.mt_entry.entry_created_on AS datetime, DATE_FORMAT(ue_MT.mt_entry.entry_created_on, '%D %M %Y at %H:%i') AS date_added, ( SELECT aking_UsingEnglish.staff.id FROM aking_UsingEnglish.staff WHERE aking_UsingEnglish.staff.weblog_id = ue_MT.mt_entry.entry_author_id LIMIT 1 ) AS author_id, DATE_FORMAT(ue_MT.mt_entry.entry_modified_on, '%D %M %Y at %H:%i') AS last_edit_date, ue_MT.mt_entry.entry_modified_on AS last_edit, ( SELECT aking_UsingEnglish.staff.id FROM aking_UsingEnglish.staff WHERE aking_UsingEnglish.staff.weblog_id = ue_MT.mt_entry.entry_modified_by LIMIT 1 ) AS last_edited_by, '0' AS members_only, 'Editors\' Blog' AS contrib_type_str, '12' AS contrib_type_id, '' AS filename, IF(ue_MT.mt_entry.entry_status = 2, '0', '1') AS pending, IF(ue_MT.mt_entry.entry_status = 2, 'Published', 'Pending') AS pending_str FROM ue_MT.mt_entry WHERE ue_MT.mt_entry.entry_blog_id = 4 AND ue_MT.mt_entry.entry_status = 2 UNION ALL SELECT ue_MT.mt_entry.entry_id AS id, ue_MT.mt_entry.entry_title AS title, ue_MT.mt_entry.entry_created_on AS datetime, DATE_FORMAT(ue_MT.mt_entry.entry_created_on, '%D %M %Y at %H:%i') AS date_added, ( SELECT aking_UsingEnglish.staff.id FROM aking_UsingEnglish.staff WHERE aking_UsingEnglish.staff.weblog_id = ue_MT.mt_entry.entry_author_id LIMIT 1 ) AS author_id, DATE_FORMAT(ue_MT.mt_entry.entry_modified_on, '%D %M %Y at %H:%i') AS last_edit_date, ue_MT.mt_entry.entry_modified_on AS last_edit, ( SELECT aking_UsingEnglish.staff.id FROM aking_UsingEnglish.staff WHERE aking_UsingEnglish.staff.weblog_id = ue_MT.mt_entry.entry_modified_by LIMIT 1 ) AS last_edited_by, '0' AS members_only, 'Site Diary' AS contrib_type_str, '12' AS contrib_type_id, '' AS filename, IF(ue_MT.mt_entry.entry_status = 2, '0', '1') AS pending, IF(ue_MT.mt_entry.entry_status = 2, 'Published', 'Pending') AS pending_str FROM ue_MT.mt_entry WHERE ue_MT.mt_entry.entry_blog_id = 3 AND ue_MT.mt_entry.entry_status = 2 UNION ALL SELECT aking_Polls.ue_poll_lookup.poll_id AS id, aking_Polls.poll_index.question AS title, aking_Polls.ue_poll_lookup.datetime AS datetime, DATE_FORMAT(aking_Polls.ue_poll_lookup.datetime, '%D %M %Y at %H:%i') AS date_added, aking_Polls.ue_poll_lookup.author_id AS author_id, DATE_FORMAT(aking_Polls.ue_poll_lookup.last_edit, '%D %M %Y at %H:%i') AS last_edit_date, aking_Polls.ue_poll_lookup.last_edit, aking_Polls.ue_poll_lookup.last_edited_by, '0' AS members_only, 'Polls' AS contrib_type_str, '13' AS contrib_type_id, '' AS filename, IF(aking_Polls.poll_index.status = 1, '0', '1') AS pending, IF(aking_Polls.poll_index.status = 1, 'Published', 'Pending') AS pending_str FROM aking_Polls.poll_index JOIN aking_Polls.ue_poll_lookup ON aking_Polls.ue_poll_lookup.poll_id = aking_Polls.poll_index.poll_id WHERE aking_Polls.poll_index.status = 1 ) AS MainTable WHERE author_id = 1566
MySQL Error: 1142 (SELECT command denied to user 'aking_dbadmin'@'localhost' for table 'mt_entry')

Session halted.