use arwiki_p;
SET @rank=0;
SELECT @rank:=@rank+1 AS rank, s.*
FROM (
... |
7 years ago |
use arwiki_p;
SET @rank=0;
SELECT @rank:=@rank+1 AS rank, *
FROM (SELECT
... |
7 years ago |
use arwiki_p;
SET @rank=0;
SELECT @rank:=@rank+1 AS rank,
rev_user_text,
... |
7 years ago |
use arwiki_p;
SELECT
rev_user_text,
COUNT(*)
FROM... |
7 years ago |
use arwiki_p;
SELECT
ROW_NUMBER(),
rev_user_text,
COUNT(*)
FROM... |
7 years ago |
use arwiki_p;
SELECT
rev_user_text,
COUNT(*)
FROM... |
7 years ago |