SELECT
`t_user_cert`.`userId` AS `userId`,
max(
(
CASE `t_user_cert`.`type`
WHEN 'IDCARD' THEN
`t_user_cert`.`status`
ELSE
0
END
)
) AS `idcard`,
max(
(
CASE `t_user_cert`.`type`
WHEN 'ZM' THEN
`t_user_cert`.`status`
ELSE
0
END
)
) AS `zm`,
max(
(
CASE `t_user_cert`.`type`
WHEN 'PHONE' THEN
`t_user_cert`.`status`
ELSE
0
END
)
) AS `phone`
FROM
`t_user_cert`
GROUP BY
`t_user_cert`.`userId`
ORDER BY
`t_user_cert`.`userId` DESC
`t_user_cert`.`userId` AS `userId`,
max(
(
CASE `t_user_cert`.`type`
WHEN 'IDCARD' THEN
`t_user_cert`.`status`
ELSE
0
END
)
) AS `idcard`,
max(
(
CASE `t_user_cert`.`type`
WHEN 'ZM' THEN
`t_user_cert`.`status`
ELSE
0
END
)
) AS `zm`,
max(
(
CASE `t_user_cert`.`type`
WHEN 'PHONE' THEN
`t_user_cert`.`status`
ELSE
0
END
)
) AS `phone`
FROM
`t_user_cert`
GROUP BY
`t_user_cert`.`userId`
ORDER BY
`t_user_cert`.`userId` DESC