SELECT p1.Id as QuestionID, p1.Title as QuestionTitle, p1...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

SELECT
p1.Id as QuestionID,
p1.Title as QuestionTitle,
p1.Body as QuestionText,
p1.CreationDate as QuestionDate,
p1.OwnerUserId as QOwnerID,
p1.LastEditDate as Edited,
p1.Score as QScore,
p1.ViewCount as QViewCount,
p1.Tags as QTags,
p1.AnswerCount as QAnswerCount,
p1.CommentCount as QCommentCount,
p1.FavoriteCount as QFavoriteCount,
p1.ClosedDate as QClosedDate,
p2.ParentId,
p2.Id,
p2.CreationDate as AnswerDate,
c1.PostId,
c1.Id as CommentID,
c1.Text as CommentText,
c1.CreationDate as CommentDate,
c1.UserID as CommentUserID,
u1.Id as userID,
u1.AccountId as accountId,
u1.Reputation,
u1.CreationDate,
u1.UpVotes,
u1.DownVotes,
u1.Views
FROM Posts p1
LEFT JOIN Posts p2
ON p1.Id=p2.ParentId
LEFT JOIN Comments c1
ON p1.Id=c1.PostId
LEFT JOIN Users u1
ON p1.OwnerUserID=u1.AccountId
WHERE p1.PostTypeID=1
AND p1.CreationDate < '2016-10-01'
AND p1.CreationDate > '2016-10-02'
AND p1.Tags LIKE '%microsoft-word%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results