SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE cards (`cardDuedatentime` INTEGER, `timestamp` INTEGER);
✓
INSERT INTO cards (`cardDuedatentime`, `timestamp`) VALUES
  ('-1', '1150'),
  ('-1', '5601'),
  ('1660694400', '1111'),
  ('1671062400', '2222'),
  ('1660176000', '3333'),
  ('-1', '4200');
✓
SELECT *
FROM cards
ORDER BY cardDuedatentime = -1,
         CASE WHEN cardDuedatentime = -1 THEN -timestamp ELSE cardDuedatentime END;


cardDuedatentime
timestamp


1660176000
3333

1660694400
1111

1671062400
2222

-1
5601

-1
4200

-1
1150


SELECT CASE WHEN cardDuedatentime = -1 THEN timestamp ELSE cardDuedatentime END time
FROM cards
ORDER BY cardDuedatentime = -1,
         CASE WHEN cardDuedatentime = -1 THEN -timestamp ELSE cardDuedatentime END;


time


1660176000

1660694400

1671062400

5601

4200

1150

`cardDuedatentime`	`timestamp`
`1660176000`	`3333`
`1660694400`	`1111`
`1671062400`	`2222`
`-1`	`5601`
`-1`	`4200`
`-1`	`1150`