Created
February 16, 2010 00:11
-
-
Save mcfunley/305129 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Query one. | |
select thing_id, user_id, description | |
from things | |
where thing_id=56778; | |
-- Query two. | |
select user_id, text | |
from thing_comments | |
where thing_id=56778 | |
order by creation_time asc; | |
-- Query three. | |
select target_id, target_type, clicks | |
from thing_elements | |
where thing_id = 56778 | |
order by creation_time asc; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment