SQLSTATE[HY000]: General error: 20018 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Modern_Spanish_CI_AS" in the equal to operation. [20018] (severity 16) [
SELECT G_Name, CONVERT(varchar(max), G_Mark, 2) as G_Mark, G_Master, CS_Kills, CS_Deaths, CS_Type,
(SELECT COUNT(*) FROM MUCMS_TRIGGER_CHARACTER WHERE G_Name = tg.G_Name AND Date = tg.Date) as Participants,
(SELECT TOP 1 Name FROM MUCMS_TRIGGER_CHARACTER WHERE G_Name = tg.G_Name AND Date = tg.Date ORDER BY CS_BestKillStreak DESC, CS_Kills DESC, CS_Deaths ASC) as TopPlayer
FROM MUCMS_TRIGGER_GUILD tg
WHERE Date = CAST('' AS DATE) AND (
EXISTS (SELECT OWNER_GUILD FROM MUCMS_CS_HISTORY cs WHERE OWNER_GUILD = tg.G_Name OR
(SELECT Number FROM Guild WHERE G_Name = cs.OWNER_GUILD) = (SELECT G_Union FROM Guild WHERE G_Name = tg.G_Name)
)
) AND (CS_Kills > 0 OR CS_Deaths > 0)
ORDER BY CS_Type ASC, CS_Kills DESC, CS_Deaths ASC, Participants ASC]