Conquistas actuales
Error al conectar con la base de datos: SQLSTATE[HY000]: General error: 20018 Invalid object name 'MuOnline.dbo.IGC_ARCA_BATTLE_WIN_GUILD_INFO'. [20018] (severity 16) [
SELECT TOP (1000)
[G_Name] AS Guild,
[OuccupyObelisk],
[WinDate]
FROM
[MuOnline].[dbo].[IGC_ARCA_BATTLE_WIN_GUILD_INFO]
]
Mayores asesinatos
Error al conectar con la base de datos: SQLSTATE[HY000]: General error: 20018 Invalid object name 'MuOnline.dbo.C_PlayerKiller_Info'. [20018] (severity 16) [
SELECT
k.[Killer],
COUNT(k.[Killer]) AS Asesinatos,
COALESCE(v.Muertes, 0) AS Muertes
FROM
[MuOnline].[dbo].[C_PlayerKiller_Info] k
LEFT JOIN (
SELECT
[Victim],
COUNT([Victim]) AS Muertes
FROM
[MuOnline].[dbo].[C_PlayerKiller_Info]
WHERE
[ServerCode] = 13
GROUP BY
[Victim]
) v
ON k.[Killer] = v.[Victim]
WHERE
k.[ServerCode] = 13
GROUP BY
k.[Killer],
v.Muertes
ORDER BY
Asesinatos DESC
]