User:Angela/useful stuff

Table of contents 1 Boilerplate texts 2 Database queries 3 Other useful things 4 Search the Wikipedia namespace only 5 Things to work on

Boilerplate texts (more can be found at Wikipedia:Boilerplate text)

Hello, [[Wikipedia:Welcome, newcomers|welcome]] to Wikipedia. I hope you enjoy editing here and being a [[Wikipedia:Wikipedians|Wikipedian]]. You can learn more on the [[Wikipedia:How to edit a page|how to edit]] page. The [[Wikipedia:Naming conventions|naming conventions]] and [[Wikipedia:Manual of Style|manual of style]] pages are also useful. Feel free to experiment at the [[Wikipedia:Sandbox]]. If you have any questions about the project then check out [[Wikipedia:Help]] or add a question to the [[wikipedia:Village pump|Village pump]]. ~~~

Hello and [[Wikipedia:Welcome, newcomers|welcome]] to Wikipedia. Thanks for all your contributions. Why not [[Special:Userlogin|create an account]] and stay awhile? The Wikipedia can use as many quality members as possible. If you ever need editing help visit [[Wikipedia:How to edit a page|How to edit a page]] and experiment at the [[Wikipedia:Sandbox|sandbox]]. If you need pointers on how we title pages visit [[Wikipedia:Naming conventions]]. If you have any other questions about the project then check out [[Wikipedia:Help]] or add a question to the [[wikipedia:Village pump|Village pump]]. I hope you enjoy being here. ~~~

''This article is a [[Wikipedia:The perfect stub article|stub]]. You can help Wikipedia by [[Wikipedia:Find or fix a stub|fixing it]].''

Database queries

To be used at Special:Asksql.

This one finds new users. Finds 20 users, starting at the tenth one.

SELECT user_name, COUNT(*) FROM user, cur WHERE user_id=cur_user GROUP BY user_id ORDER BY user_id DESC LIMIT 10,20

This one finds stub articles.

SELECT cur_title FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text NOT LIKE "%'''%" AND cur_text NOT LIKE "%<b>%" AND cur_text NOT LIKE "%disambiguation%" LIMIT 50 Other useful things

• #REDIRECT [[article]]
• Wikipedia:Votes_for_deletion
• How to use images
• Votes
• Requested articles
• Other utilities, including links to the style manual
• Commonly mispelled words (http://www.library.cornell.edu/tsmanual/TSSU/comis1) and more.
• Special:Newpages

Search the Wikipedia namespace only

/w/wiki.phtml?ns4=1&redirs=1&search=

Things to work on

• Assessment_for_learning[?]
• Requested articles
• SATs-UK[?]
• Macromedia Authorware[?]

---

Put this on a page with possible copyright violation; Removed possible [[Wikipedia:Copyrights|copyright infringement]]. Text that was previously posted here is the same as text from this webpage: :http://www3.uakron.edu/ssma/composers/Johnston.shtml This page is now listed on [[Wikipedia:Votes for deletion]]. To the poster: If there was permission to use this material under terms of our [[Wikipedia:Text of the GNU Free Documentation License|license]] or if you are the copyright holder of the externally linked text, then please indicate so on this page's talk page (to access the talk page, click on ''Discuss this page'' in the sidebar). If there was no permission to use this text then please either replace this message with at least a [[Wikipedia:The perfect stub article|good stub]] and an external link or leave this page to be deleted. (NOTE: unless a stub replaces this text, deletion will occur about one week from the time this page title was placed on the Votes for deletion page). It also should be noted that the posting of copyrighted material that does ''not'' have the express permission from the copyright holder is possibly illegal and is a violation of our [[wikipedia:copyright|policy]]. Those with a history of violations may be temporarily [[Special:Ipblocklist|suspended]] from editing pages. If this is in fact an infringement of copyright, we still welcome any original contributions by you. Thanks, ~~~~