StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4475519
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-12-17T23:02:05.113
FavoriteCount
0
LastActivityDate
2010-12-23T15:40:26.417
LastEditDate
2010-12-23T15:40:26.417
LastEditorUserId
316810
OwnerUserId
316810
ParentId
4474588
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Your query (as written) is looking for the number of projects that have been created in the last 30 days have have attached comments/feedback, and the person in question has commented on this project. The first thing that stands out is that you're checking the date the projected was created, not the date of the comments/feedback. If you do this, when the project becomes more than 30 days old, no more feedbacks will count when running the query. You most likely will want to add a timestamp to the feedbacks table and check that field instead. Also, you're doing a count of the number of projects, rather than the number of feedbacks that meet the criteria. For you're query, I would try something like: <pre><code>SELECT COUNT(feedbacks.id) FROM feedbacks, projects WHERE projects.id = feedbacks.project_id AND projects.status IN (5, 10) AND feedbacks.timestamp >= DATE_SUB('2010-12-17 21:24:51', INTERVAL 30 DAY) ORDER BY projects.id </code></pre> This will find the number of feedbacks per each project (of the given status). If you want to count only the feedbacks that were given by the person who won the bid, you can add to the WHERE clause: <pre><code>AND feedbacks.from in ( SELECT project_bids.bid_owner_id FROM project_bids WHERE project_bids.accepted = 1 AND project_bids.project_id = projects.id ) </code></pre> Your English is a bit difficult to understand, so please clarify I misunderstood something. Note to everyone else: I'm still trying to get used to the Mark Down system. Feel free to correct my formatting above.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POComplicated SQL Query Question
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USVOIDHand
UserOwnerUserId
1. USVOIDHand
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POComplicated SQL Query Question
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThis is answer guided to me to write correct query. Thanks
 singulars
 PostPostId
 PO
 UserUserId
 USmTuran

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.