USE fawiki_p;
SELECT DISTINCT ug_group
FROM user_groups
ORDER BY 1 |
5 years ago |
USE fawiki_p;
SELECT *
FROM user_groups
JOIN user
ON user_id =... |
5 years ago |
USE fawiki_p;
SELECT *
FROM user_groups
JOIN user
ON user_id =... |
5 years ago |
USE fawiki_p;
SELECT *
FROM user_groups
JOIN user
ON user_id =... |
5 years ago |
USE fawiki_p;
SELECT
LEFT(rev_timestamp, 6) AS year_mon,
... |
6 years ago |
USE fawiki_p;
SELECT
LEFT(rev_timestamp, 6) AS year_mon,
... |
6 years ago |
USE fawiki_p;
SELECT
LEFT(rev_timestamp, 6) AS year_mon,
... |
6 years ago |
use fawiki_p;
SELECT
page_title,
COUNT(il_to) cnt,
SUM(
CASE
... |
7 years ago |
use fawiki_p;
SELECT
page_title,
COUNT(il_to) cnt,
SUM(
CASE
... |
7 years ago |
use fawiki_p;
SELECT
page_title,
COUNT(il_to) cnt,
SUM(
CASE
... |
7 years ago |
use fawiki_p;
SELECT
page_title,
COUNT(il_to) cnt,
SUM(
CASE
... |
7 years ago |
use fawiki_p;
SELECT
page_title,
COUNT(il_to) cnt,
SUM(
CASE
... |
7 years ago |
use fawiki_p;
SELECT
page_title,
COUNT(il_to) cnt
FROM page
JOIN... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT log_id, log_timestamp, log_namespace, log_title,... |
7 years ago |
use fawiki_p;
SELECT *
FROM logging
WHERE log_user_text = 'Huji'
AND... |
7 years ago |
use fawiki_p;
SELECT *
FROM logging
WHERE log_user_text = 'Huji'
AND... |
7 years ago |
use fawiki_p;
SELECT *
FROM logging
WHERE log_user_text = 'Huji'
AND... |
7 years ago |
use fawiki_p;
SELECT *
FROM logging
WHERE log_user_text = 'Huji'
AND... |
7 years ago |
use fawiki_p;
SELECT *
FROM logging
WHERE log_user_text = 'Huji'
AND... |
7 years ago |