0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT
Users.Id AS UserId,
Users.DisplayName,
Users.Reputation,
Users.CreationDate AS UserCreationDate,
Users.LastAccessDate,
Users.WebsiteUrl,
Users.Location,
Users.AboutMe,
Users.Views,
Users.UpVotes,
Users.DownVotes,
Users.ProfileImageUrl,
Users.EmailHash,
Users.AccountId,
Posts.Id AS PostId,
Posts.Title AS PostTitle,
Posts.CreationDate AS PostCreationDate,
Posts.Tags
FROM Posts
INNER JOIN Users ON Posts.OwnerUserId = Users.Id
WHERE Posts.Tags LIKE '%elementary-set-theory%'
OR Posts.Tags LIKE '%real-analysis%'
OR Posts.Tags LIKE '%calculus%'
OR Posts.Tags LIKE '%linear-algebra%'
OR Posts.Tags LIKE '%probability%'
OR Posts.Tags LIKE '%abstract-algebra%'
OR Posts.Tags LIKE '%integration%'
OR Posts.Tags LIKE '%sequences-and-series%'
OR Posts.Tags LIKE '%combinatorics%'
OR Posts.Tags LIKE '%general-topology%'
OR Posts.Tags LIKE '%geometry%'
OR Posts.Tags LIKE '%number-theory%'
OR Posts.Tags LIKE '%statistics%'
OR Posts.Tags LIKE '%graph-theory%'
OR Posts.Tags LIKE '%algebraic-geometry%'
OR Posts.Tags LIKE '%differential-geometry%'
OR Posts.Tags LIKE '%algebraic-topology%'
OR Posts.Tags LIKE '%functional-analysis%'
OR Posts.Tags LIKE '%complex-analysis%'
OR Posts.Tags LIKE '%ring-theory%'
OR Posts.Tags LIKE '%category-theory%'
OR Posts.Tags LIKE '%set-theory%'
ORDER BY Users.DisplayName, Posts.CreationDate;

fork query

created dec 2 anonymous