List of Featured Article and Good Article in jawiki

This query is marked as a draft This query has been published by 軽快.

SQL

use wikidatawiki_p;

select *
from archive
limit 10;

select *
from archive_userindex
limit 10;

select *
from babel
limit 10;

select *
from change_tag
limit 10;

select *
from filearchive
limit 10;

select *
from filearchive_userindex
limit 10;

select *
from interwiki
limit 10;

select *
from ip_changes
limit 10;

select *
from iwlinks
limit 10;

select *
from l10n_cache
limit 10;

select *
from linter
limit 10;ed

select *
from math
limit 10;

select *
from module_deps
limit 10;

select *
from msg_resource_links
limit 10;

select *
from oldimage
limit 10;

select *
from oldimage_userindex
limit 10;

select *
from ores_classification
limit 10;

select *
from ores_model
limit 10;

select *
from page
limit 10;

select *
from page_props
limit 10;

select *
from page_restrictions
limit 10;

select *
from pagelinks
limit 10;

select *
from protected_titles
limit 10;

select *
from recentchanges
limit 10;

select *
from recentchanges_userindex
limit 10;

select *
from redirect
limit 10;

select *
from revision
limit 10;

select *
from revision_userindex
limit 10;

select *
from site_identifiers
limit 10;

select *
from site_stats
limit 10;

select *
from sites
limit 10;

select *
from tag_summary
limit 10;

select *
from templatelinks
limit 10;

select *
from transcode
limit 10;

select *
from updatelog
limit 10;

select *
from valid_tag
limit 10;

select *
from wb_changes
limit 10;

select *
from wb_changes_dispatch
limit 10;

select *
from wb_changes_subscription
limit 10;

select *
from wb_id_counters
limit 10;

select *
from wb_items_per_site
limit 10;

select *
from wb_property_info
limit 10;

select *
from wb_terms
limit 10;

select *
from wbc_entity_usage
limit 10;

select *
from wbqc_constraints
limit 10;

select *
from wbs_propertypairs
limit 10;

​x
 
use wikidatawiki_p;​select *from archivelimit 10;​select *from archive_userindexlimit 10;​select *from babellimit 10;​select *from change_taglimit 10;​select *from filearchivelimit 10;​select *from filearchive_userindexlimit 10;​select *from interwikilimit 10;​select *from ip_changeslimit 10;​select *from iwlinkslimit 10;​select *from l10n_cachelimit 10;​select *from linterlimit 10;ed​select *from mathlimit 10;​select *from module_depslimit 10;​select *from msg_resource_linkslimit 10;​select *from oldimagelimit 10;​select *from oldimage_userindexlimit 10;​select *from ores_classificationlimit 10;​select *from ores_modellimit 10;​select *from pagelimit 10;​select *from page_propslimit 10;​select *from page_restrictionslimit 10;​select *from pagelinkslimit 10;​select *from protected_titleslimit 10;​select *from recentchangeslimit 10;​select *from recentchanges_userindexlimit 10;​select *from redirectlimit 10;​select *from revisionlimit 10;​select *from revision_userindexlimit 10;​select *from site_identifierslimit 10;​select *from site_statslimit 10;​select *from siteslimit 10;​select *from tag_summarylimit 10;​select *from templatelinkslimit 10;​select *from transcodelimit 10;​select *from updateloglimit 10;​select *from valid_taglimit 10;​select *from wb_changeslimit 10;​select *from wb_changes_dispatchlimit 10;​select *from wb_changes_subscriptionlimit 10;​select *from wb_id_counterslimit 10;​select *from wb_items_per_sitelimit 10;​select *from wb_property_infolimit 10;​select *from wb_termslimit 10;​select *from wbc_entity_usagelimit 10;​select *from wbqc_constraintslimit 10;​select *from wbs_propertypairslimit 10;

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...