SELECT wikidb.pagelinks.pl_from, GROUP_CONCAT(DISTINCT wikidb.page.page_id ORDER BY wikidb.page.page_id) FROM wikidb.pagelinks INNER JOIN wikidb.page ON wikidb.pagelinks.pl_title = wikidb_quality.page.page_title GROUP BY (wikidb.pagelinks.pl_from) limit 10; # ERROR 1054 (42S22): Unknown column 'wikidb_quality.page.page_title' in 'on clause' SELECT wikidb.pagelinks.pl_from, GROUP_CONCAT(DISTINCT wikidb_quality.page.page_id ORDER BY wikidb.page.page_id) FROM wikidb.pagelinks INNER JOIN wikidb.page ON wikidb.pagelinks.pl_title = wikidb_quality.page.page_title GROUP BY (wikidb.pagelinks.pl_from) limit 10; # ERROR 1054 (42S22): Unknown column 'wikidb_quality.page.page_id' in 'field list'