Links possivelmente bloqueados para o YouTube

This query is marked as a draft This query has been published by Danilo.mac.

Consulta aos links externos no domínio principal com regex feita usando os url para o YouTube na spam-blacklist. Para confirmar se o link está mesmo bloqueados ainda é necessário conferir se o link não está na spam-whitelist.

SQL

USE ptwiki_p;
SELECT
  el_to,
  page_title
FROM externallinks
INNER JOIN page ON el_from = page_id
WHERE el_to REGEXP "[[:<:]]youtube\.com/(user|pantanal55|pubistube|results\?|v/|view_play_list\?|playlist|watch\?)"
  AND page_namespace = 0;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...