Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Neechalkaran
.
All Distinct Roman Title without Tamil interlink and with English Category.
Toggle Highlighting
SQL
USE tawiki_p; select Concat("# [[",page_title,"]]") from page where page_namespace=0 and page_title REGEXP '.(ாா|ாி|ாீ|ாு|ாூ|ாெ|ாே|ாை|ாொ|ாோ|ாௌ|ா்|ிா|ிி|ிீ|ிு|ிூ|ிெ|ிே|ிை|ிொ|ிோ|ிௌ|ி்|ீா|ீி|ீீ|ீு|ீூ|ீெ|ீே|ீை|ீொ|ீோ|ீௌ|ீ்|ுா|ுி|ுீ|ுு|ுூ|ுெ|ுே|ுை|ுொ|ுோ|ுௌ|ு்|ூா|ூி|ூீ|ூு|ூூ|ூெ|ூே|ூை|ூொ|ூோ|ூௌ|ூ்|ொ|ெி|ெீ|ெு|ெூ|ெெ|ெே|ெை|ெொ|ெோ|ெௌ|ெ்|ோ|ேி|ேீ|ேு|ேூ|ேெ|ேே|ேை|ேொ|ேோ|ேௌ|ே்|ைா|ைி|ைீ|ைு|ைூ|ைெ|ைே|ைை|ைொ|ைோ|ைௌ|ை்|ொா|ொி|ொீ|ொு|ொூ|ொெ|ொே|ொை|ொொ|ொோ|ொௌ|ொ்|ோா|ோி|ோீ|ோு|ோூ|ோெ|ோே|ோை|ோொ|ோோ|ோௌ|ோ்|ௌா|ௌி|ௌீ|ௌு|ௌூ|ௌெ|ௌே|ௌை|ௌொ|ௌோ|ௌௌ|ௌ்|்ா|்ி|்ீ|்ு|்ூ|்ெ|்ே|்ை|்ொ|்ோ|்ௌ|்்).' LIMIT 1000;
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
.
Checking query status...
