URL shorteners II

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT id as [Post Link], Title FROM Posts
WHERE (PostTypeId = 4 OR PostTypeId = 5)
AND (
    lower(BODY) LIKE '%zi.mu%'
    OR lower(BODY) LIKE '%zi.ma%'
    OR lower(BODY) LIKE '%yhoo.it%'
    OR lower(BODY) LIKE '%yfrog.com%'
    OR lower(BODY) LIKE '%yep.it%'
    OR lower(BODY) LIKE '%y.ahoo.it%'
    OR lower(BODY) LIKE '%xurl.es%'
    OR lower(BODY) LIKE '%xrl.us%'
    OR lower(BODY) LIKE '%xrl.in%'
    OR lower(BODY) LIKE '%wp.me%'
    OR lower(BODY) LIKE '%url.ie%'
    OR lower(BODY) LIKE '%url.co.uk%'
    OR lower(BODY) LIKE '%url.az%'
    OR lower(BODY) LIKE '%u.nu%'
    OR lower(BODY) LIKE '%twurl.nl%'
    OR lower(BODY) LIKE '%twurl.cc%'
    OR lower(BODY) LIKE '%tr.im%'
    OR lower(BODY) LIKE '%to.ly%'
    OR lower(BODY) LIKE '%tnij.org%'
    OR lower(BODY) LIKE '%tinyurl.com%'
    OR lower(BODY) LIKE '%tinylink.in%'
    OR lower(BODY) LIKE '%tiny.pl%'
    OR lower(BODY) LIKE '%tiny.ly%'
    OR lower(BODY) LIKE '%tiny.cc%'
    OR lower(BODY) LIKE '%tcrn.ch%'
    OR lower(BODY) LIKE '%ta.gd%'
    OR lower(BODY) LIKE '%//t.co%'
    OR lower(BODY) LIKE '%//t.cn%'
    OR lower(BODY) LIKE '%su.pr%'
    OR lower(BODY) LIKE '%sp2.ro%'
    OR lower(BODY) LIKE '%snurl.com%'
    OR lower(BODY) LIKE '%snipr.com%'
    OR lower(BODY) LIKE '%shrt.st%'
    OR lower(BODY) LIKE '%shorturl.com%'
    OR lower(BODY) LIKE '%short.ie%'
    OR lower(BODY) LIKE '%shorl.com%'
    OR lower(BODY) LIKE '%shar.es%'
    OR lower(BODY) LIKE '%sameulr.com%'
    OR lower(BODY) LIKE '%safe.mn%'
    OR lower(BODY) LIKE '%post.ly%'
    OR lower(BODY) LIKE '%ping.fm%'
    OR lower(BODY) LIKE '%ow.ly%'
    OR lower(BODY) LIKE '%om.ly%' 
    OR lower(BODY) LIKE '%nyti.ms%' 
    OR lower(BODY) LIKE '%nsfw.in%' 
    OR lower(BODY) LIKE '%moby.to%' 
    OR lower(BODY) LIKE '%migre.me%' 
    OR lower(BODY) LIKE '%lnkd.in%' 
    OR lower(BODY) LIKE '%linkbun.ch%' 
    OR lower(BODY) LIKE '%linkbee.com%' 
    OR lower(BODY) LIKE '%liip.to%' 
    OR lower(BODY) LIKE '%krunchd.com%' 
    OR lower(BODY) LIKE '%j.mp%' 
    OR lower(BODY) LIKE '%is.gd%' 
    OR lower(BODY) LIKE '%hurl.me%' 
    OR lower(BODY) LIKE '%huff.to%' 
    OR lower(BODY) LIKE '%goo.gl%' 
    OR lower(BODY) LIKE '%fwd4.me%' 
    OR lower(BODY) LIKE '%flic.kr%' 
    OR lower(BODY) LIKE '%fff.to%' 
    OR lower(BODY) LIKE '%ff.im%' 
    OR lower(BODY) LIKE '%fb.me%' 
    OR lower(BODY) LIKE '%fav.me%' 
    OR lower(BODY) LIKE '%eepurl.com%' 
    OR lower(BODY) LIKE '%doiop.com%' 
    OR lower(BODY) LIKE '%dlvr.it%'
    OR lower(BODY) LIKE '%disq.us%' 
    OR lower(BODY) LIKE '%digg.com%' 
    OR lower(BODY) LIKE '%digbig.com%' 
    OR lower(BODY) LIKE '%decenturl.com%' 
    OR lower(BODY) LIKE '%cutt.us%' 
    OR lower(BODY) LIKE '%cot.ag%' 
    OR lower(BODY) LIKE '%cli.gs%' 
    OR lower(BODY) LIKE '%clck.ru%' 
    OR lower(BODY) LIKE '%cl.ly%' 
    OR lower(BODY) LIKE '%chilp.it%' 
    OR lower(BODY) LIKE '%budurl.com%' 
    OR lower(BODY) LIKE '%bit.ly%'
    OR lower(BODY) LIKE '%binged.it%' 
    OR lower(BODY) LIKE '%bacn.me%' 
    OR lower(BODY) LIKE '%arst.ch%' 
    OR lower(BODY) LIKE '%alturl.com%' 
    OR lower(BODY) LIKE '%afx.cc%' 
    OR lower(BODY) LIKE '%adjix.com%' 
    OR lower(BODY) LIKE '%adf.ly%' 
    OR lower(BODY) LIKE '%4sq.com%' 
    OR lower(BODY) LIKE '%3.ly%' 
    OR lower(BODY) LIKE '%0rz.tw%' 
    --- Not blacklisted
    OR lower(BODY) LIKE '%freeimagehosting.net%' 
    OR lower(BODY) LIKE '%git.io%'
    --- Dead third party images
    OR lower(BODY) LIKE '%imageshack.%' 
    OR lower(BODY) LIKE '%img42.com%' 
    --- Alive third party images
    OR lower(BODY) LIKE '%ibb.co%' 
    OR lower(BODY) LIKE '%pasteboard.co%' 
    --- OR lower(BODY) LIKE '%flickr.com%' --- Might produce false positives
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results