Welcome Guest, Not a member yet? Register   Sign In
mysql 3 table join
#3

[eluser]krzycho[/eluser]
yes, subqueries are slow.
steve, the query you posted returns wrong values for comments_count and vote_count- both are products of comments_count and vote_count.


Messages In This Thread
mysql 3 table join - by El Forum - 07-15-2008, 08:48 AM
mysql 3 table join - by El Forum - 07-15-2008, 09:23 AM
mysql 3 table join - by El Forum - 07-15-2008, 11:49 AM
mysql 3 table join - by El Forum - 07-15-2008, 11:58 AM



Theme © iAndrew 2016 - Forum software by © MyBB