Transac de MsSql a MySql

[The_Pretorian]

Buenas Tardes:
Haciendo varias pruebas llegu a esta traduccion pero por alguna razon me sale error. Espero me puedan ayudar puesto y gracias de antemano.

Error consulta SQL:

SELECT A.FecReg, A.CodTra,
MAX( IF( A.CodMar = '1', convert( A.HorReg AS UNSIGNED ) , 0 ) AS 'IngTra',
MAX( IF( A.CodMar = '2', convert( A.HorReg AS UNSIGNED ) , 0 ) AS 'SalRef',
MAX( IF( A.CodMar = '3', convert( A.HorReg AS UNSIGNED ) , 0 ) AS 'RetRef',
MAX( IF( A.CodMar = '4', convert( A.HorReg AS UNSIGNED ) , 0 ) AS 'SalTra'
FROM Horario H
INNER JOIN Trabajador T ON H.CodHor = T.CodHor
INNER JOIN Asistencia A ON T.CodTra = A.CodTra
GROUP BY A.FecReg, A.CodTra
LIMIT 0 , 30

MySQL ha dicho:

#1064 - 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 'AS UNSIGNED), 0 ) AS 'IngTra', MAX(
IF(A.CodMar = '2', conver

Atte
The Pretorian