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'