روابط سبام من مستخدم Hasanisawi

Fork of روابط سبام من مستخدم Hasanisawi by Gerges

This query is marked as a draft This query has been published by لوقا.

SQL

/*
select page.page_title, el_to from externallinks
join page on page.page_id = externallinks.el_from

where el_to like "%isawi-bookmark.blogspot.com%"
and el_to not like "%web.archive.org%"
or el_to like "%archdrawingrepresentation.blogspot.com%"
or el_to like "%archifia.blogspot.com%"
or el_to like "%architectural-communication-skills.blogspot.com%"
or el_to like "%architectural-disegno.blogspot.com%"
or el_to like "%free-hand-ju.blogspot.com%"

and page.page_namespace in (0)
limit 10 
*/
desc externallinks;
select * from externallinks limit 10;

SQL

Checking query status...