SELECT page_title, 

       page_namespace                                   AS namespace, 

       el_to                                            AS oldurl, 

       REPLACE(el_to, "www.fiu.edu", "webdept.fiu.edu") AS newurl 

FROM   externallinks 

       JOIN page 

         ON page_id = el_from 

WHERE  page_namespace = 0 

       AND el_to LIKE "http://www.fiu.edu/~mirandas%" 

       AND el_to NOT LIKE "%bios%";