20 lines
316 B
Go
20 lines
316 B
Go
package player
|
|
|
|
const getPLayerWithRolesQuery = `
|
|
SELECT
|
|
u.uuid,
|
|
u.email,
|
|
u.username,
|
|
u.firstname,
|
|
u.lastname,
|
|
u.birthday,
|
|
u.is_active,
|
|
u.created_at,
|
|
ur.role
|
|
FROM public.users u
|
|
LEFT JOIN roles ur ON u.uuid = ur.player_id::uuid
|
|
`
|
|
|
|
// GROUP BY u.uuid
|
|
// ORDER BY u.uuid ASC;
|