Pla 1140

!! DONT MERGE BEFORE QA !!

@SQLReview 

SELECT page_id,qc_value,page_title FROM `querycache`,`page` 
WHERE (qc_title = page_title) 
	AND (qc_namespace = page_namespace) 
	AND (page_is_redirect = 0) 
	AND qc_type = 'Mostlinked' 
	AND qc_namespace = '0' 
	ORDER BY qc_value DESC 
LIMIT 50

mysql> explain SELECT page_id,qc_value,page_title FROM `querycache`,`page`  WHERE (qc_title = page_title) AND (qc_namespace = page_namespace) AND (page_is_redirect = 0) AND qc_type = 'Mostlinked' AND qc_namespace = '0' ORDER BY qc_value DESC LIMIT 50;
+----+-------------+------------+--------+----------------------------------------+------------+---------+-----------------------------------+------+-------------+
| id | select_type | table      | type   | possible_keys                          | key        | key_len | ref                               | rows | Extra       |
+----+-------------+------------+--------+----------------------------------------+------------+---------+-----------------------------------+------+-------------+
|  1 | SIMPLE      | querycache | ref    | qc_type                                | qc_type    | 32      | const                             |  999 | Using where |
|  1 | SIMPLE      | page       | eq_ref | name_title,page_redirect_namespace_len | name_title | 261     | const,firefly.querycache.qc_title |    1 | Using where |
+----+-------------+------------+--------+----------------------------------------+------------+---------+-----------------------------------+------+-------------+
2 rows in set (0.00 sec)