All pastes #812928 Raw Edit

Unnamed

public sql v1 · immutable
·published 2007-12-12 02:57 UTC
rendered paste body
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'