https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

--- Comment #3 from Reedy <s...@reedyboy.net> 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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to