mirror of https://github.com/kacos2000/Queries
You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
457 B
SQL
16 lines
457 B
SQL
-- IOS Home\Library\Calendar\Extras.db
|
|
|
|
Select
|
|
Z_PRIMARYKEY.Z_NAME as 'Name',
|
|
zalarm.ZENTITYID as 'ID',
|
|
datetime('2001-01-01', zalarm.ZACKNOWLEDGEDDATE || ' seconds') as 'AcknowledgedDate',
|
|
datetime('2001-01-01', zalarm.ZENTITYDATE || ' seconds') as 'EntityDate',
|
|
zalarm.ZENTITYTIMEZONE as 'EntityTimezone',
|
|
zalarm.ZENTITYURI,
|
|
zalarm.ZEXTERNALID
|
|
|
|
From zalarm
|
|
join Z_PRIMARYKEY on Z_PRIMARYKEY.Z_ENT = zalarm.Z_ENT
|
|
order by zalarm.Z_PK desc
|
|
|