SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT
YEAR(user_registration) AS RegistrationYear,
COUNT(DISTINCT... |
11 months ago |
SELECT YEAR(user_registration) AS Year_Joined, user_name, actor_id,... |
11 months ago |
SELECT YEAR(user_registration) AS Year_Joined, user_name, actor_id,... |
11 months ago |
SELECT YEAR(user_registration) AS Year_Joined, user_name, actor_id,... |
11 months ago |
SELECT YEAR(user_registration) AS Year_Joined, user_name, actor_id
... |
11 months ago |
SELECT YEAR(user_registration) AS Year_Joined, user_name
COUNT(DISTINCT... |
11 months ago |
SELECT YEAR(user_registration) AS Year_Joined, COUNT(DISTINCT actor_id) AS... |
11 months ago |
SELECT
YEAR(user_registration) AS reg_year,
COUNT(DISTINCT user_id) AS... |
11 months ago |
SELECT *
FROM user
WHERE user_name = "Pranayraj1985"
LIMIT 50 |
11 months ago |
SELECT *
FROM user
WHERE user_name = "Pranayraj1985" AND user_editcount... |
11 months ago |
SELECT *
FROM user
WHERE YEAR(user_registration) = 2010 and user_editcount... |
11 months ago |
SELECT *
FROM user
WHERE YEAR(user_registration) = 2010 and user_editcount >... |
11 months ago |
SELECT *
FROM user
WHERE YEAR(user_registration) = 2010
LIMIT 50 |
11 months ago |
SELECT *
FROM user
LIMIT 50 |
11 months ago |
SELECT *
FROM user
LIMIT 50 |
11 months ago |
SELECT *
FROM user
LIMIT 50 |
11 months ago |
SELECT *
FROM user
LIMIT 50 |
11 months ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)) AS edits, EXTRACT(YEAR_MONTH FROM... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT SUM(COUNT(rev_timestamp)), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
create table pivex
engine=connect table_type=pivot tabname=revision; |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT rev_actor, IF(EXTRACT(YEAR_MONTH FROM rev_timestamp) AS yearmonth =... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT *
#COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT *
#COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT *
#COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT *
#COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp), EXTRACT(YEAR_MONTH FROM rev_timestamp) AS... |
2 years ago |
SELECT COUNT(rev_timestamp)#, YEAR_MONTH(rev_timestamp), rev_actor
FROM... |
2 years ago |
SELECT COUNT(rev_timestamp), YEAR_MONTH(rev_timestamp), rev_actor
FROM... |
2 years ago |
SELECT COUNT(rev_timestamp), YEAR_MONTH(rev_timstamp), rev_actor
FROM... |
2 years ago |
SELECT rev_timestamp, WHERE MONTH(rev_timestamp) = 2;
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE MONTH(rev_timestamp) = 2;
FROM revision
#GROUP BY... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT rev_timestamp WHERE (MONTH(rev_timestamp) = 2);
FROM revision
#GROUP... |
2 years ago |
SELECT COUNT(rev_timestamp) WHERE (MONTH(rev_timestamp) = 2);
FROM... |
2 years ago |
SELECT YEAR_MONTH(rev_timestamp) AS yearmonth, COUNT(rev_timestamp) WHERE... |
2 years ago |
SELECT YEAR_MONTH(rev_timestamp) AS yearmonth, COUNT(rev_timestamp) WHERE... |
2 years ago |
SELECT YEAR_MONTH(rev_timestamp) AS yearmonth, COUNT(rev_timestamp) WHERE... |
2 years ago |
SELECT YEAR_MONTH(rev_timestamp) AS yearmonth, COUNT(rev_timestamp) WHERE... |
2 years ago |
SELECT YEAR_MONTH(rev_timestamp) AS yearmonth, rev_actor,... |
2 years ago |
SELECT YEAR_MONTH(rev_timestamp) AS yearmonth, rev_actor,... |
2 years ago |
SELECT COUNT((rev_timestamp) WHERE (MONTH(rev_timestamp) = 2)) AS EditCount,... |
2 years ago |
SELECT COUNT((rev_tiimestamp) WHERE (MONTH(rev_timestamp) = 2)) AS... |
2 years ago |
SELECT COUNT(rev_tiimestamp) WHERE (MONTH(rev_timestamp) = 2) AS EditCount,... |
2 years ago |
SELECT COUNT(rev_tiimestamp) WHERE (MONTH(rev_timestamp) = 2) AS EditCount,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp)) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, (MONTH(EXTRACT(YEAR_MONTH FROM rev_timestamp))) AS... |
2 years ago |
SELECT rev_timestamp, (MONTH(EXTRACT(YEAR_MONTH FROM rev_timestamp)) = 2) AS... |
2 years ago |
SELECT rev_timestamp, (EXTRACT(YEAR_MONTH FROM rev_timestamp) = 2) AS... |
2 years ago |
SELECT rev_timestamp, EXTRACT(YEAR_MONTH FROM rev_timestamp) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, EXTRACT(YEAR_MONTH FROM rev_timestamp) AS yearmonth,... |
2 years ago |
SELECT rev_timestamp, EXTRACT(YEAR_MONTH FROM rev_timestamp) AS year&month,... |
2 years ago |
WITH
cat_filter AS (
SELECT rev_id, rev_actor
FROM categorylinks
INNER... |
2 years ago |
SELECT actor_user
FROM revision
JOIN categorylinks ON rev_page =... |
2 years ago |
WITH cat_filter AS (
SELECT actor_user
FROM revision
JOIN categorylinks ON... |
2 years ago |
WITH cat_filter AS (
SELECT actor_user
FROM revision
JOIN categorylinks ON... |
2 years ago |
WITH cat_filter AS (
SELECT actor_user
FROM revision
JOIN categorylinks ON... |
2 years ago |
WITH cat_filter AS (
SELECT actor_user
FROM revision
JOIN categorylinks ON... |
2 years ago |
SELECT actor_user
FROM revision
JOIN categorylinks ON rev_page =... |
2 years ago |
SELECT actor_user
FROM revision
JOIN categorylinks ON rev_page =... |
2 years ago |
WITH actor_uploaders_tocat AS (
SELECT actor_user
FROM revision
JOIN... |
2 years ago |
WITH actor_uploaders_tocat AS (
SELECT actor_user
FROM revision
JOIN... |
2 years ago |
WITH actor_uploaders_tocat AS (
SELECT actor_user
FROM revision
JOIN... |
2 years ago |
SELECT *
FROM wikilove_log
LIMIT 10 |
2 years ago |
DESCRIBE wikilove_log |
2 years ago |
SHOW tables |
2 years ago |
WITH
WLM2018_USERS AS(
SELECT DISTINCT actor_user, user_name,... |
2 years ago |