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
Certes
.
Toggle Highlighting
SQL
SELECT *from linktarget where lt_title IN ("Starbox_begin") AND lt_namespace=10 /*SELECT P1.page_title Title, P1.page_is_redirect Redir, REGEXP_REPLACE(REGEXP_REPLACE(CONVERT(P1.page_title USING utf8), "(\\p{Greek}+)", "[Greek \\1]"), "(\\p{Cyrillic}+)", "[Cyrillic \\1]") AnnotatedTitle FROM page P1 LEFT JOIN templatelinks TL1 ON TL1.cl_from=page_id AND TL1.tl_target_id IN ("Chembox", "Drugbox") WHERE P1.page_namespace=0 AND P1.page_title NOT LIKE "%μSA%" AND CONVERT(P1.page_title USING utf8) REGEXP "\\p{Greek}|\\p{Cyrillic}" AND CONVERT(P1.page_title USING utf8) REGEXP "\\p{Latin}" AND NOT EXISTS (SELECT 1 FROM redirect JOIN page P2 ON P2.page_title=rd_title AND P2.page_namespace=0 JOIN categorylinks CL2 ON CL2.cl_from=P2.page_id AND CL2.cl_to IN ("Chembox", "Drugbox") AND CL2.cl_type='page' WHERE rd_from=P1.page_id AND rd_namespace=0) AND CL1.cl_from IS NULL ORDER BY P1.page_title*/
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...