Unknown column 'cr.time_entered' in 'field list'SELECT
					c.contestant_id,
					c.contestant_name,
					ei.description,
					c.small_img,
					user.rating,
					friend_users.avg_rating friend_rating,
					all_users.avg_rating avg_rating
				FROM
					episode_info ei 
					INNER JOIN 
					contestant c ON c.contestant_id = ei.contestant_id
					LEFT JOIN
					(SELECT 
						r.episode_contestant_performance_id, 
						r.rating 
					 FROM contestant_rating r 
					 	INNER JOIN (SELECT 
					 					cr.episode_contestant_performance_id, 
					 					max(cr.time_entered) max_time 
					 				FROM contestant_rating cr 
					 					INNER JOIN episode_info ei on cr.episode_contestant_performance_id = ei.episode_contestant_performance_id 
					 				WHERE 
					 					ei.episode_id = 71 and cr.user_id = -1  
					 				GROUP BY
					 					cr.episode_contestant_performance_id) 
					 	t on r.episode_contestant_performance_id = t.episode_contestant_performance_id 
					 WHERE r.user_id = -1 and t.max_time = r.time_entered)
					user ON user.episode_contestant_performance_id = ei.episode_contestant_performance_id
					INNER JOIN
					(SELECT 
						cr.episode_contestant_performance_id, 
						avg(cr.rating) avg_rating 
					 FROM contestant_rating cr 
						INNER JOIN 
						episode_info ei ON cr.episode_contestant_performance_id =  ei.episode_contestant_performance_id 
					 WHERE ei.episode_id = 71 
					 GROUP BY cr.episode_contestant_performance_id)
					all_users ON all_users.episode_contestant_performance_id = ei.episode_contestant_performance_id
					LEFT JOIN
					(SELECT 
						cr.episode_contestant_performance_id, 
						avg(cr.rating) avg_rating 
					 FROM contestant_rating cr 
						INNER JOIN 
						episode_info ei ON cr.episode_contestant_performance_id =  ei.episode_contestant_performance_id 
					 WHERE ei.episode_id = 71 AND cr.user_id IN (-2) 
					 GROUP BY cr.episode_contestant_performance_id)
					friend_users ON friend_users.episode_contestant_performance_id = ei.episode_contestant_performance_id	
				WHERE
					ei.episode_id = 71
				ORDER BY
					all_users.avg_rating DESC, user.rating DESC