https://bugzilla.wikimedia.org/show_bug.cgi?id=25437
--- Comment #3 from Reedy <[email protected]> 2010-12-31 20:42:58 UTC --- mysql> DESCRIBE SELECT cr_message,cr_author,cr_id,ct_tag AS rnotes FROM `mw_code_rev` LEFT JOIN `mw_code_tags` ON ((ct_repo_id = cr_repo_id AND ct_rev_id = cr_id AND ct_tag = "release-notes")) WHERE cr_repo_id = '3' AND (cr_status NOT IN('reverted','deferred','fixme')) AND (cr_message != '') AND (cr_id BETWEEN 77000 AND 78000 AND (cr_path LIKE '/trunk/phase3/%' OR cr_path = '/trunk/phase3')) ORDER BY cr_id DESC ; +----+-------------+--------------+--------+-----------------------------------------+---------+---------+--------------------------------------------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+--------------+--------+-----------------------------------------+---------+---------+--------------------------------------------------------------+------+-------------+ | 1 | SIMPLE | mw_code_rev | range | PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 8 | NULL | 2370 | Using where | | 1 | SIMPLE | mw_code_tags | eq_ref | PRIMARY,ct_repo_id | PRIMARY | 265 | wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id,const | 1 | Using index | +----+-------------+--------------+--------+-----------------------------------------+---------+---------+--------------------------------------------------------------+------+-------------+ 2 rows in set (0.00 sec) That query looks fine :| -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
