mysql> explain -> SELECT /* ApiQueryBacklinks::run 213.221.18.157 */ page_id,page_title,page_namespace,page_is_redirect,pl_title,pl_namespace FROM `page`,`pagelinks` WHERE (pl_from=page_id) AND ((pl_title = 'Insurance_company' AND pl_namespace = '0') OR (pl_title = 'Assurfinance' AND pl_namespace = '0') OR (pl_title = 'Insured' AND pl_namespace = '0')) AND (page_id>=18025107) ORDER BY pl_namespace, pl_title, pl_from LIMIT 101 -> ; +-----------+-------+----------------------+---------+---------+--------------------+---------+----------------------------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-----------+-------+----------------------+---------+---------+--------------------+---------+----------------------------------------------+ | page | range | PRIMARY | PRIMARY | 4 | NULL | 3012360 | Using where; Using temporary; Using filesort | | pagelinks | ref | pl_from,pl_namespace | pl_from | 8 | page.page_id,const | 3 | Using where; Using index | +-----------+-------+----------------------+---------+---------+--------------------+---------+----------------------------------------------+ 2 rows in set (0.00 sec)