Danyboy · May 18, 2016 00:00
diff --git a/compatibility.sql b/compatibility.sql
 SELECT id, link, name, hours_together, coef
 FROM (
 	SELECT my_users.user_id, COUNT (*)::float / 12 AS hours_together, COUNT(*)::float / user_coef.their_hours AS coef
 		FROM online{$current_user} LEFT JOIN online{$current_user} AS my_users
 		ON my_users.status = online{$current_user}.status
 			INNER JOIN (SELECT user_id, COUNT(*) AS their_hours
 			FROM online{$current_user}
 			GROUP BY user_id) AS user_coef
 		ON user_coef.user_id = my_users.user_id
 		WHERE online{$current_user}.user_id = {$user}
 		GROUP BY online{$current_user}.user_id, my_users.user_id, user_coef.their_hours
 		ORDER BY hours_together DESC
 ) AS my_comp
 JOIN users{$current_user} ON (my_comp.user_id = id);
	SELECT id, link, name, hours_together, coef
	FROM (
	SELECT my_users.user_id, COUNT ()::float / 12 AS hours_together, COUNT()::float / user_coef.their_hours AS coef
	FROM online{$current_user} LEFT JOIN online{$current_user} AS my_users
	ON my_users.status = online{$current_user}.status
	INNER JOIN (SELECT user_id, COUNT(*) AS their_hours
	FROM online{$current_user}
	GROUP BY user_id) AS user_coef
	ON user_coef.user_id = my_users.user_id
	WHERE online{$current_user}.user_id = {$user}
	GROUP BY online{$current_user}.user_id, my_users.user_id, user_coef.their_hours
	ORDER BY hours_together DESC
	) AS my_comp
	JOIN users{$current_user} ON (my_comp.user_id = id);
No results found