Top:

SELECT Feeds.parents_model, Feeds.parents_id, FeedsChallengeSubmissions.moderated, FeedsChallengeSubmissionsChallenges.title, FeedsChallengeSubmissionsChallenges.points, FeedsChallengeSubmissionsCrews.name, FeedsChallengeSubmissionsCrews.slug, FeedsChallengeSubmissionsCrewsCities.city, FeedsChallengeSubmissionsUsers.nickname, FeedsChallengeSubmissionsUsers.avatar, FeedsChallengeSubmissionsUsers.avatars_id, FeedsChallengeSubmissionsUsersCrews.name, FeedsMedias.id, FeedsMedias.file, FeedsMedias.video, FeedsMedias.description, FeedsMedias.created, FeedsMedias.users_id, FeedsMediasCrews.name, FeedsMediasCrews.slug, FeedsMediasCrewsCities.city, FeedsMediasUsers.nickname, FeedsMediasUsers.avatar, FeedsMediasUsers.avatars_id, FeedsMediasUsersCrews.name, FeedsPosts.id, FeedsPosts.comment, FeedsPosts.photo, FeedsPosts.video, FeedsPosts.created, FeedsPostsCrews.name, FeedsPostsCrews.slug, FeedsPostsCrewsCities.city, FeedsPostsUsers.nickname, FeedsPostsUsers.avatar, FeedsPostsUsers.avatars_id, FeedsPostsUsersCrews.name FROM `feeds` AS `Feeds` LEFT JOIN `challenge_submissions` AS `FeedsChallengeSubmissions` ON Feeds.parents_id = FeedsChallengeSubmissions.id LEFT JOIN `challenges` AS `FeedsChallengeSubmissionsChallenges` ON FeedsChallengeSubmissions.challenges_id = FeedsChallengeSubmissionsChallenges.id LEFT JOIN `crews` AS `FeedsChallengeSubmissionsCrews` ON FeedsChallengeSubmissions.crews_id = FeedsChallengeSubmissionsCrews.id LEFT JOIN `cities` AS `FeedsChallengeSubmissionsCrewsCities` ON FeedsChallengeSubmissionsCrews.cities_id = FeedsChallengeSubmissionsCrewsCities.id LEFT JOIN `users` AS `FeedsChallengeSubmissionsUsers` ON FeedsChallengeSubmissions.users_id = FeedsChallengeSubmissionsUsers.id LEFT JOIN `crews` AS `FeedsChallengeSubmissionsUsersCrews` ON FeedsChallengeSubmissionsUsers.crews_id = FeedsChallengeSubmissionsUsersCrews.id LEFT JOIN `medias` AS `FeedsMedias` ON Feeds.parents_id = FeedsMedias.id LEFT JOIN `crews` AS `FeedsMediasCrews` ON FeedsMedias.crews_id = FeedsMediasCrews.id LEFT JOIN `cities` AS `FeedsMediasCrewsCities` ON FeedsMediasCrews.cities_id = FeedsMediasCrewsCities.id LEFT JOIN `users` AS `FeedsMediasUsers` ON FeedsMedias.users_id = FeedsMediasUsers.id LEFT JOIN `crews` AS `FeedsMediasUsersCrews` ON FeedsMediasUsers.crews_id = FeedsMediasUsersCrews.id LEFT JOIN `posts` AS `FeedsPosts` ON Feeds.parents_id = FeedsPosts.id LEFT JOIN `crews` AS `FeedsPostsCrews` ON FeedsPosts.crews_id = FeedsPostsCrews.id LEFT JOIN `cities` AS `FeedsPostsCrewsCities` ON FeedsPostsCrews.cities_id = FeedsPostsCrewsCities.id LEFT JOIN `users` AS `FeedsPostsUsers` ON FeedsPosts.users_id = FeedsPostsUsers.id LEFT JOIN `crews` AS `FeedsPostsUsersCrews` ON FeedsPostsUsers.crews_id = FeedsPostsUsersCrews.id WHERE Feeds.deleted = '0' AND (Feeds.parents_model != 'ChallengeSubmissions' OR (FeedsChallengeSubmissions.deleted = '0' AND FeedsChallengeSubmissionsChallenges.deleted = '0' AND FeedsChallengeSubmissionsCrews.deleted = '0' AND FeedsChallengeSubmissionsCrewsCities.deleted = '0' AND (FeedsChallengeSubmissions.users_id IS NULL OR (FeedsChallengeSubmissionsUsers.deleted = '0' AND (FeedsChallengeSubmissionsUsers.crews_id IS NULL OR (FeedsChallengeSubmissionsUsersCrews.deleted = '0')))))) AND (Feeds.parents_model != 'Medias' OR (FeedsMedias.deleted = '0' AND FeedsMediasCrews.deleted = '0' AND FeedsMediasCrewsCities.deleted = '0' AND FeedsMediasUsers.deleted = '0' AND (FeedsMediasUsers.crews_id IS NULL OR (FeedsMediasUsersCrews.deleted = '0')))) AND (Feeds.parents_model != 'Posts' OR (FeedsPosts.deleted = '0' AND FeedsPostsCrews.deleted = '0' AND FeedsPostsCrewsCities.deleted = '0' AND FeedsPostsUsers.deleted = '0' AND (FeedsPostsUsers.crews_id IS NULL OR (FeedsPostsUsersCrews.deleted = '0')))) AND ((Feeds.parents_model = 'ChallengeSubmissions' AND FeedsChallengeSubmissions.challenges_id NOT BETWEEN '10001' AND '10013' AND FeedsChallengeSubmissions.challenge_submission_statuses_id = '3' AND FeedsChallengeSubmissionsCrews.suspended = '0' AND FeedsChallengeSubmissionsCrews.cities_id = '3') OR (Feeds.parents_model = 'Medias' AND FeedsMedias.file IS NOT NULL AND FeedsMedias.approved = '1' AND FeedsMediasCrews.suspended = '0' AND FeedsMediasCrews.cities_id = '3') OR (Feeds.parents_model = 'Posts' AND FeedsPostsCrews.suspended = '0' AND FeedsPostsCrews.cities_id = '3')) ORDER BY Feeds.created DESC LIMIT 0, 1


Bottom:

SELECT COUNT(Feeds.id) FROM `feeds` AS `Feeds` LEFT JOIN `challenge_submissions` AS `FeedsChallengeSubmissions` ON Feeds.parents_id = FeedsChallengeSubmissions.id LEFT JOIN `crews` AS `FeedsChallengeSubmissionsCrews` ON FeedsChallengeSubmissions.crews_id = FeedsChallengeSubmissionsCrews.id LEFT JOIN `medias` AS `FeedsMedias` ON Feeds.parents_id = FeedsMedias.id LEFT JOIN `crews` AS `FeedsMediasCrews` ON FeedsMedias.crews_id = FeedsMediasCrews.id LEFT JOIN `posts` AS `FeedsPosts` ON Feeds.parents_id = FeedsPosts.id LEFT JOIN `crews` AS `FeedsPostsCrews` ON FeedsPosts.crews_id = FeedsPostsCrews.id WHERE Feeds.deleted = '0' AND (Feeds.parents_model != 'ChallengeSubmissions' OR (FeedsChallengeSubmissions.deleted = '0' AND FeedsChallengeSubmissionsCrews.deleted = '0')) AND (Feeds.parents_model != 'Medias' OR (FeedsMedias.deleted = '0' AND FeedsMediasCrews.deleted = '0')) AND (Feeds.parents_model != 'Posts' OR (FeedsPosts.deleted = '0' AND FeedsPostsCrews.deleted = '0')) AND ((Feeds.parents_model = 'ChallengeSubmissions' AND FeedsChallengeSubmissions.challenges_id NOT BETWEEN '10001' AND '10013' AND FeedsChallengeSubmissions.challenge_submission_statuses_id = '3' AND FeedsChallengeSubmissionsCrews.suspended = '0' AND FeedsChallengeSubmissionsCrews.cities_id = '3') OR (Feeds.parents_model = 'Medias' AND FeedsMedias.file IS NOT NULL AND FeedsMedias.approved = '1' AND FeedsMediasCrews.suspended = '0' AND FeedsMediasCrews.cities_id = '3') OR (Feeds.parents_model = 'Posts' AND FeedsPostsCrews.suspended = '0' AND FeedsPostsCrews.cities_id = '3')) ORDER BY Feeds.created DESC