Patch
Same underlying cause as bug 15579. STRAIGHT_JOIN does not seem to be required in this case to convince MySQL to use the smart join order. The generated queries are:
- allcategories
SELECT cat_title,pp_propname AS cat_hidden FROM category LEFT JOIN page ON ((page_namespace=14 AND page_title=cat_title)) LEFT JOIN page_props ON ((pp_page=page_id AND pp_propname='hiddencat')) ORDER BY cat_title LIMIT 11;
- categoryinfo; fill in the "IN" clause at the end
SELECT cat_title,cat_pages,cat_subcats,cat_files,pp_propname AS cat_hidden FROM category LEFT JOIN page ON ((page_namespace=14 AND page_title=cat_title)) LEFT JOIN page_props ON ((pp_page=page_id AND pp_propname='hiddencat')) WHERE cat_title IN ('...');
Version: 1.14.x
Severity: normal
Attached: