All pastes #804172 Raw Edit

Unnamed

public sql v1 · immutable
·published 2007-12-03 04:47 UTC
rendered paste body
# In the following query, my eventual goal is to get output that looks something like this:# 0 | 13744878, 8523154, 8600448, 2721809# 1 | 34682, 63211, 6083615mysql> SELECT pl_from, page_id FROM pagelinks INNER JOIN page ON pagelinks.pl_title = page.page_title;+---------+----------+| pl_from | page_id  |+---------+----------+|       0 | 13744878 | |       0 |  8523154 | |       0 |  8600448 | |       0 |  2721809 | |       1 |    34682 | |       1 |    63211 | |       1 |  6083615 | +---------+----------+