projects
/
squeep-indie-auther
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
63a3f2c948f6dd24076fdbdd7c06f66173b4dbbf
[squeep-indie-auther]
/
tokens-get-by-identifier.sql
1
--
2
SELECT
3
t.code_id
,
4
p.profile
,
5
t.created
,
6
t.expires
,
7
t.refresh_expires
,
8
t.refreshed
,
9
t.duration
,
10
t.refresh_duration
,
11
t.refresh_count
,
12
t.is_revoked
,
13
t.is_token
,
14
t.client_id
,
15
t.profile_data
,
16
a.identifier
17
FROM token
t
18
INNER JOIN
profile p
USING
(
profile_id
)
19
INNER JOIN
authentication a
USING
(
identifier_id
)
20
WHERE
a.identifier
=
:identifier
21
ORDER BY max
(
t.created
,
COALESCE
(
t.refreshed
,
0
))
DESC