holyshit.sql

SELECT activity_feed_items.category AS 'activity_feed_items#category', activity_feed_items.description_key AS 'activity_feed_items#description_key', activity_feed_items.id AS 'activity_feed_items#id', activity_feed_items.is_liked AS 'activity_feed_items#is_liked', activity_feed_items.seen AS 'activity_feed_items#seen', activity_feed_items.like_count AS 'activity_feed_items#like_count', activity_feed_items.stream_id AS 'activity_feed_items#stream_id', activity_feed_items.timestamp AS 'activity_feed_items#timestamp', activity_feed_items.verb AS 'activity_feed_items#verb', object_artist.id AS 'object_artist#id', object_artist.media_id AS 'object_artist#media_id', object_artist.name AS 'object_artist#name', object_artist.on_tour AS 'object_artist#on_tour', object_artist.score AS 'object_artist#score', object_artist.source AS 'object_artist#source', object_artist.tracker_count AS 'object_artist#tracker_count', actor_artist.id AS 'actor_artist#id', actor_artist.media_id AS 'actor_artist#media_id', actor_artist.name AS 'actor_artist#name', actor_artist.on_tour AS 'actor_artist#on_tour', actor_artist.score AS 'actor_artist#score', actor_artist.source AS 'actor_artist#source', actor_artist.tracker_count AS 'actor_artist#tracker_count', event_stubs.announced_at AS 'event_stubs#announced_at', event_stubs.artist_id AS 'event_stubs#artist_id', event_stubs.based_on AS 'event_stubs#based_on', event_stubs.id AS 'event_stubs#id', event_stubs.media_id AS 'event_stubs#media_id', event_stubs.rsvp_count AS 'event_stubs#rsvp_count', event_stubs.starts_at AS 'event_stubs#starts_at', event_stubs.title AS 'event_stubs#title', event_stubs.venue_id AS 'event_stubs#venue_id', venue_stubs.latitude AS 'venue_stubs#latitude', venue_stubs.location AS 'venue_stubs#location', venue_stubs.longitude AS 'venue_stubs#longitude', venue_stubs.name AS 'venue_stubs#name', venue_stubs.id AS 'venue_stubs#id', user_posts.activity_id AS 'user_posts#activity_id', user_posts._id AS 'user_posts#_id', user_posts.media_id AS 'user_posts#media_id', user_posts.message AS 'user_posts#message', user_posts.rating AS 'user_posts#rating', users.expiration_date AS 'users#expiration_date', users.facebook_uid AS 'users#facebook_uid', users.first_name AS 'users#first_name', users.has_more_activities AS 'users#has_more_activities', users.media_id AS 'users#media_id', users.last_name AS 'users#last_name', users.latest_activity_item_stream_id AS 'users#latest_activity_item_stream_id', users.location AS 'users#location', users.id AS 'users#id', ifnull(friends.status, 2) AS 'friends#status' 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