Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 62429

Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.

8 votes

Query to find users from Australia

You should use (if the SQL version wasn't T-SQL, which it is. Thanks @Millie Smith and @Vogel612) lower(u.Location) LIKE '%australia%' In case of lowercase writing of Australia. I wouldn't really …
Quill's user avatar
  • 11.9k
1 vote

Stack Exchange moderation-action auto-comments

* Enough documentation for you? It's certainly enough for me. You said it, your documentation is a little over the top, consider only saying/including what's necessary and trim the fat a little, …
Quill's user avatar
  • 11.9k
3 votes

Stack Exchange userscript for showing spoilers on questions with particular tags

Jokes aside, your code is good, but there's a few things it could use to make it great: Using the right levels of abstraction and user control: var SHOW_ME_SPOILERS_IF_TAGGED = [ "harry-p0t …
Quill's user avatar
  • 11.9k
7 votes

Calculate questions per day on CodeGolf.SE

Code Style import requests, datetime, time Imports should not be on one line, as per PEP8 Your code doesn't meet the "too many characters on one line" rule of PEP8, however, you should avoid hav …
Quill's user avatar
  • 11.9k
4 votes

Adding links to tags on StackExchange sites

At the start: (function() { 'use strict'; console.debug("BEGIN StackExchange Questions..."); You're starting a block, so you need to indent all its children correctly. …
Quill's user avatar
  • 11.9k
6 votes
Accepted

Finding questions to answer

First, your comments: They're structured well, but, the content could be improved: -- SELECT the final results. Data is filtered based ^^^^^^^^^^^^^^^^^^^^^^^^^ -- on the following conditions. …
Quill's user avatar
  • 11.9k
7 votes
Accepted

The Handy-Dandy Apocalypse Assistant

There's a few things you can improve. UserScripts should follow the *.user.js format, so that TamperMonkey, GreaseMonkey, GoogleChrome and the other installers can pick up on the fact that it's a U …
Quill's user avatar
  • 11.9k
7 votes

Stack Exchange Post Reminder

reminders.js is good, but you don't need to return an array in for var reminders: Use the prototype chain instead: var Reminders = function(){}; Reminders.prototype.Add = function(reminder){}; Remin …
Quill's user avatar
  • 11.9k
16 votes

You hate h̶a̶t̶s̶ reputation? Click here to get rid of it

Update url UserScripts have the magical ability to update themselves if you provide a link to a raw version of your script as a UserScript header: Note: You actually have to increase the version, or …
Quill's user avatar
  • 11.9k
13 votes
Accepted

Stack Exchange User Activity Score

TOP 1 When selecting values that correspond to Unique fields referenced by constants (OwnerUserId), you're only really selecting one field, meaning this is redundant. UVN Unexplained Variable Nam …
Quill's user avatar
  • 11.9k
7 votes

Stack Exchange Chat Caret Pathfinder

One line variable declaration Please avoid declaring variables on the same line: var elements = {}, messages; It's also a great way to royally mess up scope issues if you do it on two lines but …
Quill's user avatar
  • 11.9k
48 votes
Accepted

Shielding your CodeReview on GitHub

On a personal note, your code is really clean, the idea is brilliant, and I really hope to see it implemented soon. Your code is well implemented and structured, but there's syntax points that coul …
Quill's user avatar
  • 11.9k
7 votes
Accepted

Hot Post-ato Guessing Game

Button adding: var button = createTopbarButton(); var topbar = document.getElementsByClassName("topbar-menu-links")[0]; topbar.appendChild(button); Why not bundle this all in createTopbarButton? …
Quill's user avatar
  • 11.9k
2 votes

What are the top voted comments on closed questions, and who made the comments?

SEDE has two great features that you should incorporate into your code: Input parameters Magic markup columns Input parameters SEDE lets you declare fields to be input towards the query, like so: # …
Quill's user avatar
  • 11.9k
3 votes

Finding questions to answer - Part 2

Your code's looking really good! I can only really see a few things that could be improved. SELECT [Posts].Id AS [Post Link] , [Posts].OwnerUserId AS [User Link] into: SELECT [Posts].Id …
Quill's user avatar
  • 11.9k

15 30 50 per page