StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMySQL query inside query
primarykey
Id
18505848
data
AcceptedAnswerId
18506042
AnswerCount
2
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-08-29T08:29:07.020
FavoriteCount
0
LastActivityDate
2013-08-29T18:26:43.417
LastEditDate
2013-08-29T09:28:03.900
LastEditorUserId
1399570
OwnerUserId
1399570
ParentId
0
PostTypeId
1
Score
2
ViewCount
192
LastEditorDisplayName
text
Body
I'm pretty new to MySQL, so this probably is an easy question for experienced people, but I just can't figure this out. I need to get items from database where user has posted a comment, and there is newer comment by someone else. My table has these collumns <pre><code>app_id - id of the item app_comment - comment blank if rate is present app_rate - rating blank if comment is present date - date of posting device_id - unique id to identify each user. </code></pre> I have written simple query to get each comment the user(device_id) has posted on. <pre><code>temp table: SELECT `app_id` FROM `appaction` WHERE `device_id` = '00000000-5a24-5a06-0000-00005c907706' AND `app_comment` <> '' </code></pre> But can't figure out what to do next. Now I somehow need to get only those app_id from main table where somebody else(different device_id) has a newer post on each of these items Update: Data example: <a href="http://www.sqlfiddle.com/#!2/8d986/1" rel="nofollow">http://www.sqlfiddle.com/#!2/8d986/1</a> Note: that this is just sample to get the idea how the table looks. In reality it has about 10 000 values inside. for example: I'm giving out device_id to php script, and in the output I want all app_id where user has posted himself and there is newer comment after his. Input sample: <a href="http://www.sqlfiddle.com/#!2/66258/1" rel="nofollow">http://www.sqlfiddle.com/#!2/66258/1</a> Desired output is for input ffffffff-c565-9b4a-ffff-ffffc9d821fd img/Honda/AccordPICS/4167946157_a5b77093bc_b.jpg because there is newer post for this app_id by somebody else.
Tags
<mysql><sql>
Title
MySQL query inside query
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDatenshi
UserOwnerUserId
1. USDatenshi
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POMySQL query inside query
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POMySQL query inside query
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

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.