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
data.position
FROM
(
SELECT
@rownum:=@rownum+1 AS position,
statistic.*
FROM
(
SELECT
COUNT(votingpoints) AS anzahl,
USERID
FROM
".V4M_PRODUKTTOUSER."
GROUP BY
USERID
) AS statistic,
(
SELECT
@rownum:=0
) AS vars
ORDER BY
statistic.anzahl DESC
) AS data
WHERE
USERID = '".$USERID."'
SELECT
data.position
FROM
(
SELECT
@rownum:=@rownum+1 AS position,
statistic.*
FROM
(
SELECT *
FROM (
SELECT
COUNT(votingpoints) AS anzahl,
USERID
FROM
".V4M_PRODUKTTOUSER."
GROUP BY
USERID
) X
ORDER BY anzahl DESC)AS statistic,
(
SELECT
@rownum:=0
) AS vars
) AS data
WHERE
USERID = '".$USERID."'