ks

mysql> SELECT IR.phash FROM index_words IW, index_rel IR,    index_section ISEC WHERE   IW.baseword LIKE '%funding%' AND IW.wid=IR.wid   AND ISEC.phash = IR.phash AND is_stopword=0 GROUP BY IR.phash;+-----------+| phash     |+-----------+|  49202586 | |  60446959 | | 118669723 | | 124377026 | | 130422798 | | 143458140 | | 174766452 | | 192237400 | | 194543379 | | 246256409 | +-----------+10 rows in set (3.88 sec)mysql> explain SELECT IR.phash FROM index_words IW, index_rel IR,    index_section ISEC WHERE   IW.baseword LIKE '%funding%' AND IW.wid=IR.wid   AND ISEC.phash = IR.phash AND is_stopword=0 GROUP BY IR.phash;+----+-------------+-------+--------+---------------+---------+---------+--------------------+------+----------------------------------------------+| id | select_type | table | type   | possible_keys | key     | key_len | ref                | rows | Extra                                        |+----+-------------+-------+--------+---------------+---------+---------+--------------------+------+----------------------------------------------+|  1 | SIMPLE      | ISEC  | index  | joinkey       | joinkey | 8       | NULL               | 1590 | Using index; Using temporary; Using filesort | |  1 | SIMPLE      | IR    | ref    | PRIMARY,wid   | PRIMARY | 4       | hancock.ISEC.phash | 2167 | Using index                                  | |  1 | SIMPLE      | IW    | eq_ref | PRIMARY       | PRIMARY | 4       | hancock.IR.wid     |    1 | Using where                                  | +----+-------------+-------+--------+---------------+---------+---------+--------------------+------+----------------------------------------------+3 rows in set (0.00 sec)mysql> describe index_words; describe index_rel; describe index_section ;+-------------+-------------+------+-----+---------+-------+| Field       | Type        | Null | Key | Default | Extra |+-------------+-------------+------+-----+---------+-------+| wid         | int(11)     | NO   | PRI | 0       |       | | baseword    | varchar(60) | NO   | MUL |         |       | | metaphone   | int(11)     | NO   | MUL | 0       |       | | is_stopword | tinyint(3)  | NO   |     | 0       |       | +-------------+-------------+------+-----+---------+-------+4 rows in set (0.00 sec)+-------+----------------------+------+-----+---------+-------+| Field | Type                 | Null | Key | Default | Extra |+-------+----------------------+------+-----+---------+-------+| phash | int(11)              | NO   | PRI | 0       |       | | wid   | int(11)              | NO   | PRI | 0       |       | | count | tinyint(3) unsigned  | NO   |     | 0       |       | | first | tinyint(3) unsigned  | NO   |     | 0       |       | | freq  | smallint(5) unsigned | NO   |     | 0       |       | | flags | tinyint(3) unsigned  | NO   |     | 0       |       | +-------+----------------------+------+-----+---------+-------+6 rows in set (0.00 sec)+----------+------------------+------+-----+---------+----------------+| Field    | Type             | Null | Key | Default | Extra          |+----------+------------------+------+-----+---------+----------------+| phash    | int(11)          | NO   | MUL | 0       |                | | phash_t3 | int(11)          | NO   |     | 0       |                | | rl0      | int(11) unsigned | NO   | MUL | 0       |                | | rl1      | int(11) unsigned | NO   |     | 0       |                | | rl2      | int(11) unsigned | NO   |     | 0       |                | | page_id  | int(11)          | NO   | MUL | 0       |                | | uniqid   | int(11)          | NO   | PRI | NULL    | auto_increment | +----------+------------------+------+-----+---------+----------------+7 rows in set (0.00 sec)