gistfile1.sql

mysql> mysql> SELECT posts.post_id AS posts_post_id, posts.assignment_id AS posts_assignment_id, posts.client_id AS posts_client_id, posts.post_datetime AS posts_post_datetime, posts.deleted AS posts_deleted, posts.lat AS posts_lat, posts.lng AS posts_lng, mediaobjects.media_object_id AS mediaobjects_media_object_id, mediaobjects.media_id AS mediaobjects_media_id, mediaobjects.file_name AS mediaobjects_file_name, mediaobjects.caption AS mediaobjects_caption, mediaobjeia_text AS mediaobjects_media_text, mediatypes.NAME AS mediatypes_name, mediatypes.description AS mediatypes_description, clients.verified AS clients_verified, clients.client_id AS clients_client_id, languages.language_code AS languages_language_code, languages.NAME AS languages_name FROM posts JOIN postmediaobjects ON posts.post_id = postmediaobjects.post_id JOIN mediaobjects ON mediaobjects.media_object_id = postmediaobjects.media_object_id JOIN mediatypes ON mediatypes.media_type_id = mediaobjects.media_type_id JOIN clients ON clients.client_id = posts.client_id JOIN languages ON languages.language_id = posts.language_id WHERE posts.assignment_id = 1 AND posts.deleted = false GROUP BY posts.post_id ORDER BY posts.post_datetime DESC;
+---------------+---------------------+-----------------+---------------------+---------------+-----------+-----------+------------------------------+--------------------------------------+------------------------+----------------------+-----------------------------------------------------------------+-----------------+------------------------+------------------+-------------------+-------------------------+----------------+
| posts_post_id | posts_assignment_id | posts_client_id | posts_post_datetime | posts_deleted | posts_lat | posts_lng | mediaobjects_media_object_id | mediaobjects_media_id                | mediaobjects_file_name | mediaobjects_caption | mediaobjects_media_text                                         | mediatypes_name | mediatypes_description | clients_verified | clients_client_id | languages_language_code | languages_name |
+---------------+---------------------+-----------------+---------------------+---------------+-----------+-----------+------------------------------+--------------------------------------+------------------------+----------------------+-----------------------------------------------------------------+-----------------+------------------------+------------------+-------------------+-------------------------+----------------+
|             2 |                   1 |               3 | 2015-03-02 14:30:51 |             0 |      43.2 |     -77.5 |                            2 | ee561051-9afa-4cdd-939c-323b27e6084a |                        |                      | Going out to Da CLUB!!!                                         | text            | Text.                  |                0 |                 3 | en                      | English        |
|             1 |                   1 |               2 | 2015-03-02 14:30:49 |             0 |      43.2 |     -77.5 |                            1 | 5673bf55-2439-41d2-bcee-ab06ba3a493f |                        |                      | Hopefully staying awake long enough to see the ball drop ... :/ | text            | Text.                  |                0 |                 2 | en                      | English        |
+---------------+---------------------+-----------------+---------------------+---------------+-----------+-----------+------------------------------+--------------------------------------+------------------------+----------------------+-----------------------------------------------------------------+-----------------+------------------------+------------------+-------------------+-------------------------+----------------+
2 rows in set (0.01 sec)