Problema con SELECT MAX

[Chmlls]

Iniciado por jurena

Insisto: ¿qué error te da esta consulta?

SELECT logins.time, logins.userid, clientes.Name, clientes.Money, clientes.ConnectedTime FROM logins INNER JOIN clientes ON logins.userid = clientes.id INNER JOIN (select max(time) maximo, userid USER FROM logins GROUP BY userid)t1 ON t1.USER = logins.userid AND t1.maximo = logins.time

Disculpa no publicar con anteriodad el error que me da esa consulta.

Código:

Error en la consulta de conteo de registros: SELECT COUNT(*) FROM logins GROUP BY userid)t1 ON t1.USER = logins.userid AND t1.maximo = logins.time. Mysql dijo: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')t1 ON t1.USER = logins.userid AND t1.maximo = logins.time' at line 2

La consulta es la siguiente en ese caso:

Código:

	$_pagi_sql = "SELECT logins.time, 
					logins.time, 
					logins.userid, 
					clientes.Name, 
					clientes.Money, 
					clientes.Bank, 
					clientes.DonateRank, 
					clientes.Locked, 
					clientes.ConnectedTime, 
					clientes.Linked	
				FROM logins 
				INNER JOIN clientes
				ON logins.userid = clientes.id 
				INNER JOIN (select max(time) maximo, userid 
				USER FROM logins 
				GROUP BY userid)t1 
				ON t1.USER = logins.userid AND t1.maximo = logins.time";