Search Results
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 |
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 …
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, …
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 …
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 …
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. …
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.
…
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 …
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 …
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 …
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 …
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 …
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 …
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?
…
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:
# …
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 …