https://bugzilla.wikimedia.org/show_bug.cgi?id=42923
--- Comment #3 from Sam Reed (reedy) <[email protected]> --- mysql:wikiadmin@db63 [enwiki]> EXPLAIN SELECT /* ORMTable::rawSelect Reedy */ course_id,course_org_id,course_name,course_title,course_start,course_end,course_description,course_token,course_students,course_instructors,course_online_ambs,course_campus_ambs,course_field,course_level,course_term,course_lang,course_student_count,course_instructor_count,course_oa_count,course_ca_count,course_touched FROM `ep_courses` WHERE course_term = 'All of them'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: ep_courses type: ref possible_keys: ep_course_term key: ep_course_term key_len: 257 ref: const rows: 1 Extra: Using where 1 row in set (0.01 sec) mysql:wikiadmin@db63 [enwiki]> EXPLAIN SELECT /* ORMTable::rawSelect Reedy */ DISTINCT article_page_id FROM `ep_articles` WHERE article_course_id = '1'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: ep_articles type: ref possible_keys: ep_articles_course_page,ep_articles_course_id key: ep_articles_course_page key_len: 4 ref: const rows: 1 Extra: Using where; Using temporary 1 row in set (0.01 sec) ^ Using temporary is a starting point -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
