mysql> SELECT wikidb.pagelinks.pl_from,wikidb_quality.page.page_id FROM wikidb.pagelinks INNER JOIN wikidb.page ON (wikidb_quality.page.page_title = wikidb.page.page_title) GROUP BY (wikidb.pagelinks.pl_from) limit 10;
ERROR 1054 (42S22): Unknown column 'wikidb_quality.page.page_id' in 'field list'
mysql> use wikidb_quality;
Database changed
mysql> describe page;
+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| page_id           | int(8) unsigned     | NO   | PRI | NULL    | auto_increment |
| page_namespace    | int(11)             | NO   | MUL |         |                |
| page_title        | varchar(255)        | NO   | MUL |         |                |
| page_restrictions | tinyblob            | NO   |     |         |                |
| page_counter      | bigint(20) unsigned | NO   |     | 0       |                |
| page_is_redirect  | tinyint(1) unsigned | NO   |     | 0       |                |
| page_is_new       | tinyint(1) unsigned | NO   |     | 0       |                |
| page_random       | double unsigned     | NO   | MUL |         |                |
| page_touched      | char(14)            | NO   |     |         |                |
| page_latest       | int(8) unsigned     | NO   |     |         |                |
| page_len          | int(8) unsigned     | NO   | MUL |         |                |
+-------------------+---------------------+------+-----+---------+----------------+
11 rows in set (0.63 sec)