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 DISTINCT tid FROM topicbeitraege ORDER BY eid DESC
SELECT b.tid, b.eid, tb.fid, tb.tid, tb.topicname, tb.erstellerid, tb.helped, tb.state, us.pseudonym, tb.hits
FROM topicbeitraege b
LEFT JOIN topics tb ON tb.fid = b.fid AND tb.tid = b.tid
LEFT JOIN user us ON tb.erstellerid = us.erstellerid
WHERE b.fid = 4
ORDER BY b.eid DESC
SELECT tb.fid, tb.tid, tb.topicname, tb.erstellerid, tb.helped, tb.state, us.pseudonym, tb.hits, COUNT(b.tid) counted
FROM topics tb
LEFT JOIN user us
ON tb.erstellerid = us.erstellerid
LEFT JOIN topicbeitraege b
ON tb.fid = b.fid
AND tb.tid = b.tid
WHERE tb.fid=4
GROUP BY tb.fid, tb.tid, tb.topicname, tb.erstellerid, tb.helped, tb.state, us.pseudonym, tb.hits
ORDER BY b.eid DESC