Unnamed

mysql> SELECT pl_from,                                                                                                                                                                                                                  GROUP_CONCAT(DISTINCT page.page_id ORDER BY page.page_id)                                                                                                                                                                    FROM   pagelinks                                                                                                                                                                                                                 INNER JOIN page                                                                                                                                                                                                           ON pagelinks.pl_title = page.page_title                                                                                                                                                                                   INNER JOIN ratedpage              ON ratedpage.page_id = page.page_id       WHERE pl_from IN (SELECT page_id FROM ratedpage)              AND page.page_id in (SELECT page_id FROM ratedpage)       GROUP BY (pl_from)                                                                                                                                                                                                       INTO   OUTFILE '/home/mime/student/mingus/data/pagerank/final_quality.links'