USE huwiki_p;
SELECT user_name AS 'Név', IF(cnt, cnt, 0) AS... |
6 years ago |
USE huwiki_p;
SELECT user_name AS 'Név', IF(cnt, cnt, 0) AS... |
6 years ago |
USE huwiki_p;
SELECT user_name AS 'Név', IF(cnt, cnt, 0) AS... |
6 years ago |
USE huwiki_p;
SELECT user_name AS 'name', IF(cnt, cnt, 0) AS 'edits',... |
6 years ago |
USE huwiki_p;
SELECT user_name AS 'name', IF(edits, edits, 0) AS 'edits',... |
6 years ago |
USE huwiki_p;
SELECT user_name AS 'name', edits, ug_group AS 'group'
FROM... |
6 years ago |
USE huwiki_p;
SELECT ug_user AS 'name', edits, ug_group AS 'group'
FROM... |
6 years ago |
USE huwiki_p;
SELECT name, edits, ug_group AS 'group' FROM user JOIN... |
6 years ago |
USE huwiki_p;
SELECT name, edits, user_groups AS 'group' FROM user JOIN... |
6 years ago |
USE huwiki_p;
SELECT name, edits FROM user JOIN user_groups ON (ug_group =... |
6 years ago |
USE huwiki_p;
SELECT name, edits FROM user JOIN user_groups ON (ug_group =... |
6 years ago |
USE huwiki_p;
SELECT name, cnt FROM user JOIN user_groups ON (ug_group =... |
6 years ago |
USE huwiki_p;
(SELECT rev_user_text AS name, COUNT(*) AS cnt FROM page... |
6 years ago |
USE huwiki_p;
q1 = SELECT rev_user_text AS name, COUNT(*) AS cnt FROM page... |
6 years ago |