db_update.sql

UPDATE site
SET type = 0
WHERE land_page like '%youtube.com%';

UPDATE site
SET type = 1
WHERE page_title like '%本月最受欢迎的交友网站%';

UPDATE site
SET type = 1
WHERE page_title like '%Best dating worldwide <3%';

UPDATE site
set page_title='Best dating worldwide',
    land_page='https://bcdcieg.datedats2.com/',
    type=1
where url like 'IN.SV/MEXI';

UPDATE site
set page_title='AVΗD101 高清在线谜片',
    land_page='https://cn2.af101.live/?utm_source=ta&utm_campaign=u_pc3&utm_medium=16879041&cid=0ccac41b18db4d83b3c6a9d7d72910ca',
    type=1,
    detail=''
where url like 'IN.SV/THECUTE';

UPDATE site
SET type = 1
WHERE land_page LIKE '%snapgirls9.com%'
   OR land_page LIKE '%quickdates0.com%'
   OR land_page LIKE '%privategirlses.com%'
   OR land_page LIKE '%dirtyflirt6.com%'
   OR land_page LIKE '%wewlvk.milfshorny.com%'
   OR land_page LIKE '%big-funhere.life%'
   OR land_page LIKE '%snapgirls1.com%'
   OR land_page LIKE '%boomsex.uno%'
   OR land_page LIKE '%chooseyoursoul.com%'
   OR land_page LIKE '%niceloverskm.com%'
   OR land_page LIKE '%racywomenm0.com%'
   OR land_page LIKE '%loveme.uno%'
   OR land_page LIKE '%quickdates7.com%'
   OR land_page LIKE '%cuminside.uno%'
   OR land_page LIKE '%sexy.adultdates.uno%'
   OR land_page LIKE '%urflirtyjoy.com%'
   OR land_page LIKE '%prettybangh.com%'
   OR land_page LIKE '%love.centre.baby%'
   OR land_page LIKE '%dirtyvalentine4.com%'
   OR land_page LIKE '%naughtycrackerldst.com%'
   OR land_page LIKE '%sex.porngirl.uno%'
   OR land_page LIKE '%snapbabes9.com%'
   OR land_page LIKE '%flirtyho0kup.com%'
   OR land_page LIKE '%girls.centre.baby%'
   OR land_page LIKE '%wewlvk.astonishingdates.net%'
   OR land_page LIKE '%sensualmilfs4r32.com%'
   OR land_page LIKE '%bcdcieg.datedats2.com%'
   OR land_page LIKE '%bestplacefordate.life%'
   OR land_page LIKE '%flirtyhookupd.com%'
   OR land_page LIKE '%freesex.my.id%'
   OR land_page LIKE '%dirtyangel.uno%'
   OR land_page LIKE '%dirtyflirt0.com%'
   OR land_page LIKE '%lynk.id%'
   OR land_page LIKE '%wewlvk.fbwhores.net%'
   OR land_page LIKE '%girls.climax.uno%'
   OR land_page LIKE '%montichk.top%'
   OR land_page LIKE '%seximesmoaning-porn.blogspot.com%'
   OR land_page LIKE '%makeyourwish.net%'
   OR land_page LIKE '%s.anadm.link%'
   OR land_page LIKE '%sex.centre.baby%'
   OR land_page LIKE '%cn2.af101.live%'
   OR land_page LIKE '%sexporn.mirabelle.uno%'
   OR land_page LIKE '%spronjoss3.blogspot.com%'
   OR land_page LIKE '%wewlvk.astonlshingdate.net%'
   OR land_page LIKE '%find-datings.life%'
   OR land_page LIKE '%tra.videoseen.xyz%'
   OR land_page LIKE '%wewlvk.lovelygiri.com%'
   OR land_page LIKE '%porn.centre.baby%'
   OR land_page LIKE '%ch3atinggirls.com%'
   OR land_page LIKE '%best-datingclub.life%'
   OR land_page LIKE '%vulgarfinder6sw.com%'
   OR land_page LIKE '%hot.babydoll.uno%'
   OR land_page LIKE '%inces.uno%'
   OR land_page LIKE '%blonde.centre.baby%'
   OR land_page LIKE '%sites.google.com%'
   OR land_page LIKE '%februaryinjectionproudly.com%'
   OR land_page LIKE '%cdsecurecloud-dt.com%';

UPDATE site
SET type = 0
WHERE type = 2
  and page_title like '%域名%';

UPDATE site
SET type = 0
WHERE type = 2
  and page_title like '%登录%';

UPDATE site
SET type = 1
WHERE type = 2
  and page_title like '%Secret connections in your area%';

UPDATE site
SET type  = 0,
    detail='正在建站'
WHERE type = 2
  and page_title like '%Rock%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%4.fo%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%Aishite.Tokyo%';

UPDATE site
SET type  = 0,
    detail='广告'
WHERE type = 2
  and url like '%ffm.to/dq6m8yr%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%Hotmoms.Uno%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%2RUX.Uno%';

UPDATE site
SET type  = 0,
    detail='广告'
WHERE type = 2
  and url like '%Aslan.Rest%';

UPDATE site
SET type  = 0,
    detail='存疑 即将开放'
WHERE type = 2
  and url like '%xkissss.Uno%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%Slenteng.Uno%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%loveme.Uno%';

UPDATE site
SET type = 1
WHERE type = 2
  and url like '%CUPITINA.Uno%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%zbvbee.milfshorny.com%';

UPDATE site
SET type = 0
WHERE type = 2
  and url like '%www.patreon.com/juliagisella%';


UPDATE site
SET type = 0
WHERE type = 2
  and url like '%1.How%';

UPDATE site
SET type = 0
WHERE type = 2
  and land_page like '%www.amazon.com%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%wewlvk.fancydates.net%';

UPDATE site
SET type  = 0,
    detail='存疑'
WHERE type = 2
  and url like '%baby-girls.my.id%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%wewlvk.sweetmlif.net%';

UPDATE site
SET type = 0
WHERE type = 2
  and url like '%bit.ly/ItachiWeebMerch%';

UPDATE site
SET type = 0
WHERE type = 2
  and url like '%Tri.be%';

UPDATE site
SET type = 0
WHERE type = 2
  and land_page like '%discord.com%';

UPDATE site
SET type  = 0,
    detail='广告'
WHERE type = 2
  and land_page like '%www.boredrodeo.xyz%';


UPDATE site
set page_title='AVΗD101 高清在线谜片',
    land_page='https://cn1.af101.me/?utm_source=ta&utm_campaign=u_pc3&utm_medium=16992289&cid=0cce884b4f3bf94e042cefdd00e0a61b',
    type=1,
    detail=''
where url like 'IN.SV/THEBAST';

UPDATE site
SET type = 0
WHERE type = 2
  and land_page like '%https://nasacademy.com/%';

UPDATE site
SET type = 0
WHERE type = 2
  and land_page like '%rutube.ru%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%micuka0104.top%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%fursie.rapee.me%';

UPDATE site
SET type = 0
WHERE type = 2
  and land_page like '%https://bestbusinessloans.com/%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%jhidjh.localdats.com%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%wewlvk.marveilousdate.net%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%http://fuckaef.toples.uno/%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%http://gitasex.uno/%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%ladies.centre.baby%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%bceaebd.bustyaffar.com%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%belationship.com%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%bestladieshere.life%';

UPDATE site
SET type = 1
WHERE type = 2
  and land_page like '%wewlvk.freelovehere.net%';

UPDATE site
SET type = 0
WHERE type = 2;

UPDATE site
SET type = 0
WHERE type = 1
  AND land_page LIKE '%google.com%';