Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
(SELECT t1.id, t1.name, t1.email, 'tabelle1' as tabname
FROM t1)
UNION ALL
(SELECT t2.id, t2.name, t2.email, 'tabelle2'
FROM t2)
UNION ALL
(SELECT t3.id, t3.name, t3.email, 'tabelle3'
FROM t3)
ORDER BY id
SELECT id, xp, tabname FROM
(
SELECT id, xp, 'members1' AS tabname
FROM members_t1
UNION ALL
SELECT id, xp, 'members2'
FROM members_t2
UNION ALL
SELECT Id, xp, 'members3'
FROM members_t3
....
) allmembers
WHERE id > 10
ORDER BY xp DESC
LIMIT 5;