gistfile1.txt

SELECT * FROM activity_map INNER JOIN activity_feed_items ON activity_map.activity_id = activity_feed_items.id INNER JOIN activity_feed_objects ON activity_feed_items.id = activity_feed_objects.activity_id INNER JOIN activity_feed_actors ON activity_feed_items.id = activity_feed_actors.activity_id LEFT JOIN artist_stubs AS object_artist ON activity_feed_objects.object_artist_id = object_artist.id LEFT JOIN event_stubs ON activity_feed_objects.object_event_id = event_stubs.id LEFT JOIN venue_stubs ON activity_feed_objects.object_venue_id = venue_stubs.id LEFT JOIN user_posts ON activity_feed_items.id = user_posts.activity_id LEFT JOIN artist_stubs AS actor_artist ON activity_feed_actors.actor_artist_id = actor_artist.id LEFT JOIN users ON activity_feed_actors.actor_user_id = users.id LEFT JOIN friends ON users.id = friends.friend_user_id WHERE activity_map.list_name = 'my_activity_feed' ORDER BY activity_feed_items.timestamp DESC