rendered paste body
mysql> SELECT * FROM `pagerank` where url like '%kn.wikipedia.org/%';
+--------+-----------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------+
| url_id | url_from | url |
+--------+-----------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------+
| 9175 | bh.wikipedia.org/wiki/%E0%A4%AA%E0%A4%B9%E0%A4%BF%E0%A4%B2%E0%A4%95%E0%A4%BE_%E0%A4%AA%E0%A4%A8%E0%A5%8D%E0%A4%A8%E0%A4%BE
| kn.wikipedia.org/
|
| 9737 | br.wikipedia.org/wiki/Degemer
| kn.wikipedia.org/wiki/
|
| 9645 | bpy.wikipedia.org/wiki/%E0%A6%AA%E0%A6%AF%E0%A6%BC%E0%A6%B2%E0%A6%BE_%E0%A6%AA%E0%A6%BE%E0%A6%A4%E0%A6%BE
| kn.wikipedia.org/wiki/
|
| 9492 | bo.wikipedia.org/wiki/%E0%BD%82%E0%BD%99%E0%BD%BC%E0%BC%8B%E0%BD%84%E0%BD%BC%E0%BD%A6%E0%BC%8D
| kn.wikipedia.org/
|
| 9410 | bn.wikipedia.org/wiki/%E0%A6%AA%E0%A7%8D%E0%A6%B0%E0%A6%A7%E0%A6%BE%E0%A6%A8_%E0%A6%AA%E0%A6%BE%E0%A6%A4%E0%A6%BE
| kn.wikipedia.org/wiki/
|
| 9256 | bh.wikipedia.org/wiki/%E0%A4%AA%E0%A4%B9%E0%A4%BF%E0%A4%B2%E0%A4%95%E0%A4%BE_%E0%A4%AA%E0%A4%A8%E0%A5%8D%E0%A4%A8%E0%A4%BE
| kn.wikipedia.org/wiki/
|
| 8803 | bat-smg.wikipedia.org/wiki/P%C4%97rms_poslapis
| kn.wikipedia.org/wiki/
|
| 8532 | ast.wikipedia.org/wiki/Portada
| kn.wikipedia.org/wiki/
|
| 8336 | arc.wikipedia.org/wiki/%DC%A6%DC%90%DC%AC%DC%90_%DC%AA%DC%AB%DC%9D%DC%90
| kn.wikipedia.org/wiki/
|
| 8185 | an.wikipedia.org/wiki/Portalada
| kn.wikipedia.org/wiki/
|
| 7441 | www.wikipedia.org
| kn.wikipedia.org/wiki/%E0%B2%AE%E0%B3%81%E0%B2%96%E0%B3%8D%E0%B2%AF_%E0%B2%AA%E0%B3%81%E0%B2%9F
|
| 7835 | af.wikipedia.org/wiki/Tuisblad
| kn.wikipedia.org/wiki/
|
| 10247 | chr.wikipedia.org/wiki/%E1%8E%A4%E1%8E%B5%E1%8E%AE%E1%8E%B5%E1%8F%8D%E1%8F%97
| kn.wikipedia.org/wiki/
|
| 10564 | cu.wikipedia.org/wiki/%D0%93%D0%BB%D0%B0%D0%B2%D1%8C%D0%BD%D0%B0_%D1%81%D1%82%D1%80%D0%B0%D0%BD%D0%B8%D1%86%D0%B0
| kn.wikipedia.org/wiki/
|
+--------+-----------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------+
14 rows in set (0.01 sec)