This page uses content from Wikipedia and is licensed under CC BY-SA.

User talk:SQL

Wikipedia Administrator.svgThis user has been an admin for
11 years and 18 days.
244
244 Users were created in the last hour


Up and coming tool: CatUserCompare

I've got a query that I've used for this for a while, figured it might benefit others as a tool. Very much a WIP, and unstable. Will move it to it's own project from my incubator before long. [tools.wmflabs.org].

Tool attempts to compare editor interaction by what category edited pages belong to. Tool attempts to filter out maintenance categories.

TODO:

  • More than 2 editors. Possibly up to 5.
  • Export to it's own project
  • I need to come up with a skin... Not just for this tool, but all of mine.
  • Header/footer/link to home, tool is very raw.
  • Tool can take a "long" time to run (up to 90s) on editors with a lot of edits. Possibly "LIMIT 500"?. It's already limited to 30 days.
Filters. Probably inefficient and could be condensed some
$ignore = array( 
	"All_articles_containing_potentially_dated_statements", 
	"All_articles_with_specifically_marked_weasel-worded_phrases", 
	"All_pages_needing_cleanup", 
	"All_articles_needing_additional_references", 
	"All_articles_that_may_contain_original_research", 
	"Pages_with_missing_files", 
	"Wikipedia_pages_under_discretionary_sanctions", 
	"Redirects_from_other_capitalisations", 
	"Unprintworthy_redirects", 
	"Redirects_from_ambiguous_terms", 
	"Redirects_from_modifications", 
	"Redirects_from_adjectives", 
	"Articles_with_hCards", 
	"Articles_with_inconsistent_citation_formats", 
	"Infobox_person_using_alma_mater", 
	"Pages_using_infobox_scientist_with_unknown_parameters", 
	"Redirects_from_alternative_names", 
	"Redirects_to_sections", 
	"All_articles_lacking_reliable_references", 
	"All_articles_needing_expert_attention", 
	"All_articles_that_are_too_technical", 
	"All_articles_with_broken_links_to_citations", 
	"All_articles_with_dead_external_links", 
	"All_articles_with_failed_verification", 
	"All_self-contradictory_articles", 
	"Interlanguage_link_template_link_number", 
	"Pages_with_missing_ISBNs", 
	"Placeholder_names", 
	"Articles_containing_video_clips", 
	"Articles_incorporating_Cite_DNB_template", 
	"Coordinates_on_Wikidata", 
	"All_article_disambiguation_pages", 
	"All_disambiguation_pages", 
	"Disambiguation_pages", 
	"Disambiguation_pages_with_short_description", 
	"All_Wikipedia_articles_needing_clarification", 
	"Lists_of_lists", 
	"Wikipedia_indefinitely_move-protected_pages", 
	"Wikipedia_indefinitely_semi-protected_pages", 
	"Articles_containing_Danish-language_text",
	"Articles_containing_French-language_text",
	"Articles_containing_German-language_text",
	"Articles_containing_Gothic-language_text",
	"Articles_containing_Icelandic-language_text",
	"Articles_containing_Old_English-language_text",
	"Articles_containing_Old_High_German-language_text",
	"Articles_containing_Punic-language_text",
	"Articles_containing_Swedish-language_text",
	"Articles_containing_Hebrew-language_text",
	"Articles_containing_Russian-language_text",
	"Articles_with_Curlie_links",
	"Articles_with_LibriVox_links",
	"Articles_with_Open_Library_links",
	"All_Wikipedia_GA-Class_vital_articles",
	"All_Wikipedia_level-4_vital_articles",
	"All_Wikipedia_vital_articles",
	"All_Wikipedia_vital_articles_in_Society",
	"Wikipedia_articles_with_LNB_identifiers",
	"Wikipedia_articles_with_MusicBrainz_identifiers",
	"Pages_using_citations_with_accessdate_and_no_URL",
	"Pages_using_web_citations_with_no_URL",
	"Pages_with_broken_reference_names",
	"Pages_with_reference_errors",
	"All_NPOV_disputes",
	"All_articles_with_peacock_terms",
	"All_articles_with_style_issues",
	"All_articles_lacking_sources",
	"All_stub_articles",
	"Webarchive_template_wayback_links",
	"All_articles_with_unsourced_statements" );
$ignore_wild = array(
	"Articles_containing_potentially_dated_statements_from*",
	"Use_dmy_dates_from*",
	"Use_British_English_from*",
	"Articles_lacking_in-text_citations_from*",
	"Articles_lacking_reliable_references_from*",
	"Articles_incorporating_a_citation_from*",
	"Articles_incorporating_text_from*",
	"Articles_lacking_sources_from*",
	"Articles_needing_POV-check_from*",
	"Articles_needing_additional_categories_from*",
	"Articles_needing_additional_medical_references_from*",
	"Articles_needing_expert_attention_from*",
	"Articles_needing_more_viewpoints_from*",
	"Articles_needing_sections_from*",
	"Articles_needing_the_year_an_event_occurred_from*",
	"Articles_needing_translation_from*",
	"Articles_prone_to_spam_from*",
	"Articles_requiring_tables_from*",
	"Articles_slanted_towards_recent_events_from*",
	"Articles_tagged_with_the_inline_citation_overkill_template_from*",
	"Articles_that_may_be_too_long_from*",
	"Articles_with_*",
	"Articles_needing_*",
	"Cleanup_tagged_articles_*",
	"Wikipedia_*",
	"Articles_needing_cleanup_from*",
	"Articles_with_unsourced_statements_from*",
	"Wikipedia_articles_incorporating_a_citation_from*",
	"Articles_with_specifically_marked_weasel-worded_phrases_from*",
	"Articles_needing_additional_references_from*",
	"Articles_with_sections_that_need_to_be_turned_into_prose_from*",
	"Articles_that_may_contain_original_research_from*");

I'd love to hear any feedback, or suggestions. SQLQuery me! 01:19, 21 September 2018 (UTC)

Good stuff, nice job! It may be nice to filter categories with JS by typing in a box at the top, but that's low-priority. Enterprisey (talk!) 02:25, 21 September 2018 (UTC)

Sanity check on a query...

[quarry.wmflabs.org]

It was returning more results than expected...

Intended purpose is to find stuff that's tagged for Commons but shouldn't be. ShakespeareFan00 (talk) 16:33, 21 September 2018 (UTC)

Precious

"Added welcome template to user talk page"

Cornflower blue Yogo sapphire.jpg

Thank you for welcoming hundreds of users, for fighting vandalism with precise messages, for offering service for the Electoral Commission, for providing technical analysis tools, for service from 2007, - repeating (19 February 2009): you are an awesome Wikipedian!

--Gerda Arendt (talk) 23:02, 9 October 2018 (UTC)

Please comment on Wikipedia talk:Username policy

The feedback request service is asking for participation in this request for comment on Wikipedia talk:Username policy. Legobot (talk) 04:29, 12 October 2018 (UTC)

Please comment on Wikipedia talk:Notability (organizations and companies)

The feedback request service is asking for participation in this request for comment on Wikipedia talk:Notability (organizations and companies). Legobot (talk) 04:28, 13 October 2018 (UTC)