SELECT el_to, 

       page_title 

FROM   externallinks 

       JOIN page 

         ON page_id = el_from 

WHERE  el_to LIKE "%celebrityboss.com%" 

        OR el_to LIKE "%celebrityboss.%" 

        OR el_to LIKE "%starsunfolded.%" 

        OR el_to LIKE "%heightline.%" 

        OR el_to LIKE "%gophercentral%" 

        OR el_to LIKE "%celebhealthy%" 

        OR el_to LIKE "%goldenchennai%" 

        OR el_to LIKE "%veethi.%" 

        OR el_to LIKE "%findheight.%" 

        OR el_to LIKE "%heightcelebs.%" 

        OR el_to LIKE "%filmreference.%" 

        OR el_to LIKE "%celebswiki%" 

        OR el_to LIKE "%naanoo.de%" 

        OR el_to LIKE "%taddlr.%" 

        OR el_to LIKE "%celebriot%" 

        OR el_to LIKE "%zimbio.%" 

        OR el_to LIKE "%spokeo%" 

        OR el_to LIKE "%toprichests%" 

        OR el_to LIKE "%arenapile%" 

        OR el_to LIKE "%filmibeat%" 

        OR el_to LIKE "%bookmyshow%" 

        OR el_to LIKE "%onenov%" 

        OR el_to LIKE "%celebrityborn%" 

        OR el_to LIKE "%gomolo%" 

        OR el_to LIKE "%cinetrooth%" 

        OR el_to LIKE "%filmilive%" 

        OR el_to LIKE "%mallumoviereporter%" 

        OR el_to LIKE "%famousbirthdays%" 

        OR el_to LIKE "%tamilstar%" 

        OR el_to LIKE "%rediff%" 

        OR el_to LIKE "%factcase%" 

        OR el_to LIKE "%southspy%" 

        OR el_to LIKE "%indusladies%" 

        OR el_to LIKE "%supertelugu%" 

        OR el_to LIKE "%idlebrain%" 

        OR el_to LIKE "%sukh-dukh.%" 

        OR el_to LIKE "%eenaducinema%" 

        OR el_to LIKE "%vaibhavitech%" 

        OR el_to LIKE "%indiaglitz%" 

        OR el_to LIKE "%amardesh.%" 

        OR el_to LIKE "%biographybd%" 

        OR el_to LIKE "%last.fm%" 

        OR el_to LIKE "%mediabix%" 

        OR el_to LIKE "%.online-dhaka.%" 

        OR el_to LIKE "%om-guru%" 

        OR el_to LIKE "%amaderbrahmanbaria%" 

        OR el_to LIKE "%bdentertainers%" 

        OR el_to LIKE "%nettv4u%" 

        OR el_to LIKE "%pocketnewsalert%" 

        OR el_to LIKE "%cochintalkies%" 

        OR el_to LIKE "%webindia123%" 

        OR el_to LIKE "%filmimpressions%" 

        OR el_to LIKE "%funvills%" 

        OR el_to LIKE "%onlinemoviess%" 

        OR el_to LIKE "%bollywoodlife%" 

        OR el_to LIKE "%updatesweekly%" 

        OR el_to LIKE "%kannadamoviesinfo.wordpress.%" 

        OR el_to LIKE "%dthforum.%" 

        OR el_to LIKE "%iwmbuzz.%" 

        OR el_to LIKE "%firstpost.%" 

        OR el_to LIKE "%telugucinemacharitra%" 

        OR el_to LIKE "%awardsandwinners%" 

        OR el_to LIKE "%indiascanner%" 

        OR el_to LIKE "%chitramala.in%" 

        OR el_to LIKE "%filmyprofiles%" 

        OR el_to LIKE "%ragalahari%" 

        OR el_to LIKE "%bharatwaves%" 

        OR el_to LIKE "%telugumoviepedia%" 

        OR el_to LIKE "%magazine.maalika.org%" 

        OR el_to LIKE "%wirally.%" 

        OR el_to LIKE "%marymartin.%" 

        OR el_to LIKE "%marathi.tv%" 

        OR el_to LIKE "%justmarathi.%" 

        OR el_to LIKE "%youthdevelopers.%" 

        OR el_to LIKE "%biogtown.%" 

        OR el_to LIKE "%tamilnow.%" 

        OR el_to LIKE "%mazale.in%" 

        OR el_to LIKE "%cinejalsha.%" 

        OR el_to LIKE "%asklaila%" 

        OR el_to LIKE "%online-dhaka.%" 

        OR el_to LIKE "%bollywoodshaadis%" 

        OR el_to LIKE "%contestantbio.%" 

        OR el_to LIKE "%wikibiopharm.%" 

        OR el_to LIKE "%healthyceleb.%" 

        OR el_to LIKE "%celebsjourney.%" 

        OR el_to LIKE "%celebrityinside.%" 

        OR el_to LIKE "%celebsolino.%" 

        OR el_to LIKE "%californiabirthindex.org%" 

        OR el_to LIKE "%wealtholino.%" 

        OR el_to LIKE "%starsfact.%" 

        OR el_to LIKE "%moviesplatter%" 

        OR el_to LIKE "%lifenlesson%" 

        OR el_to LIKE "%ozee.%" 

        OR el_to LIKE "%greatnewschannel.website%" 

        OR el_to LIKE "%whosdatedwho.%" 

        OR el_to LIKE "%famousheights.net%" 

        OR el_to LIKE "%articlebio.%" 

        OR el_to LIKE "%timesalert.%" 

        OR el_to LIKE "%thefamouspeople.%" 

           AND page_namespace = 0;