$data = DB::select("SELECT * FROM (
								SELECT U.id as user_id, C.id as message_id, C.user_id1, C.user_id2, C.message, C.is_read, C.created_at, U.name,
									CONCAT('$img_path', U.image) as image,
									IF(length(C.image)=0, '', CONCAT('$img_path', C.image)) as c_image,
									DATE_FORMAT(C.created_at, '%e %b %Y') as formatted_date,
									(SELECT COUNT(*) FROM chat WHERE chat.is_read!=2 AND chat.user_id2 = '$user_id' AND chat.user_id1 = U.id) AS unread_count,
									CASE
										WHEN DATEDIFF(UTC_TIMESTAMP, C.created_at) != 0 THEN
										    CASE
										    	WHEN DATEDIFF(UTC_TIMESTAMP, C.created_at) > 1 THEN CONCAT(DATEDIFF(UTC_TIMESTAMP, C.created_at) ,' days ago') ELSE CONCAT(DATEDIFF(UTC_TIMESTAMP, C.created_at) ,' day ago') END
										WHEN HOUR(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) != 0 THEN
											CASE
												WHEN HOUR(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) > 1 THEN CONCAT(HOUR(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) ,' hours ago') ELSE CONCAT(HOUR(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) ,' hour ago') END
										WHEN MINUTE(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) != 0 THEN
											CASE
												WHEN MINUTE(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) > 1 THEN CONCAT(MINUTE(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) ,' minutes ago') ELSE CONCAT(MINUTE(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) ,' minute ago') END
										ELSE
											CASE
												WHEN SECOND(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) > 1 THEN CONCAT(SECOND(TIMEDIFF(UTC_TIMESTAMP, C.created_at)) ,' seconds ago') ELSE 'now' END
									END as time_since
					   			FROM chat C
					   			JOIN user U ON CASE WHEN C.user_id1 = $user_id THEN C.user_id2 = U.id ELSE C.user_id1 = U.id END
					        	WHERE (C.user_id1 = $user_id OR C.user_id2 = $user_id )
								ORDER BY message_id DESC) temp
							GROUP BY temp.user_id
							ORDER BY message_id DESC");