0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

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