Jump to content

వాడుకరి:రహ్మానుద్దీన్/sql queries run

వికీపీడియా నుండి

select user_name,user_editcount from user where user_registration>'20140630235959' and user_registration<'20141001000000' and user_editcount > 5
Databases for Telugu :
tewiki
tewiki_p
tewikibooks
tewikibooks_p
tewikiquote
tewikiquote_p
tewikisource
tewikisource_p

Tables_in_tewiki_p
Tables_in_tewiki_p
abuse_filter
abuse_filter_action
abuse_filter_history
abuse_filter_log
archive
archive_userindex
category
categorylinks
change_tag
externallinks
filearchive
filearchive_userindex
geo_tags
global_block_whitelist
hitcounter
image
imagelinks
interwiki
ipblocks
ipblocks_ipindex
iwlinks
l10n_cache
langlinks
logging
logging_logindex
logging_userindex
mark_as_helpful
math
module_deps
msg_resource
msg_resource_links
oldimage
oldimage_userindex
page
page_props
page_restrictions
pagelinks
pif_edits
povwatch_log
povwatch_subscribers
protected_titles
recentchanges
recentchanges_userindex
redirect
revision
revision_userindex
site_identifiers
site_stats
sites
tag_summary
templatelinks
transcode
updatelog
updates
user
user_daily_contribs
user_former_groups
user_groups
user_properties
valid_tag


Field Type Null Key Default Extra
Field

Type

Null

Key

Default

Extra
page_content_model varbinary(32) YES
page_counter bigint(20) unsigned NO 0
page_id int(8) unsigned NO 0
page_is_new tinyint(1) unsigned NO 0
page_is_redirect tinyint(1) unsigned NO 0
page_latest int(8) unsigned NO 0
page_len int(8) unsigned NO 0
page_links_updated varbinary(14) YES
page_namespace int(11) NO 0
page_no_title_convert tinyint(1) NO 0
page_random double unsigned NO 0
page_restrictions varbinary(255) NO
page_title varbinary(255) NO
page_touched varbinary(14) NO