| SELECT day, MAX(unreviewed), MAX(reviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(unreviewed), MAX(reviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(unreviewed), MAX(reviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day, num
#IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
#IF... |
2 years ago |
| SELECT day, num
IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
IF... |
2 years ago |
| SELECT day,
IF (ptrp_reviewed = 0, num, 0) AS unreviewed,
IF (ptrp_reviewed... |
2 years ago |
| #SELECT day,
#IF (ptrp_reviewed = 0, COUNT(*), 0) AS unreviewed,
#IF... |
2 years ago |
| #SELECT day,
#IF (ptrp_reviewed = 0, COUNT(*), 0) AS unreviewed,
#IF... |
2 years ago |
| SELECT day,
IF (ptrp_reviewed = 0, COUNT(*), 0) AS unreviewed,
IF... |
2 years ago |
| SELECT day,
IF (ptrp_reviewed = 0, COUNT(*), 0) AS unreviewed,
IF... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| #SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT day, MAX(reviewed), MAX(unreviewed), MAX(patrolled),... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day, ptrp_reviewed,
IF... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day, ptrp_reviewed,
IF... |
2 years ago |
| SELECT ptrp_created, ptrp_reviewed,
IF ((ptrp_reviewed = 1), COUNT(*), 0)... |
2 years ago |
| SELECT ptrp_created, ptrp_reviewed,
IF ((ptrp_reviewed = 1), COUNT(*), 0)... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed,
IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed,
IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day, ptrp_reviewed,
IF... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed,
IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT
DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
MAX(reviewed),
... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed,
IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed, IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed, IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed IF ((ptrp_reviewed = 1),... |
2 years ago |
| SELECT ptrp_page_id, ptrp_created, ptrp_reviewed
#IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT ptrp_page_id, ptrp_reviewed
#IF (ptrp_reviewed = 1, COUNT(*), 0) AS... |
2 years ago |
| SELECT ptrp_reviewed
#IF (ptrp_reviewed = 1, COUNT(*), 0) AS reviewed ,
#IF... |
2 years ago |
| SELECT ptrp_reviewed
#IF (ptrp_reviewed = 1, COUNT(*), 0) AS reviewed ,
#IF... |
2 years ago |
| SELECT ptrp_reviewed
IF (ptrp_reviewed = 1, COUNT(*), 0) AS reviewed ,
IF... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day, ptrp_reviewed,
IF... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT DATE_FORMAT(ptrp_created,'%Y-%m-%d') as day,
IF (ptrp_reviewed = 1,... |
2 years ago |
| SELECT
IF (ptrp_reviewed = 1, COUNT(page.page_id), 0) AS reviewed ,
IF... |
2 years ago |
| SELECT
IF (ptrp_reviewed = 1, COUNT(page.page_id), 0) AS reviewed ,
IF... |
2 years ago |
| SELECT
IF (ptrp_reviewed = 1, COUNT(page.page_id), 0) AS reviewed ,
IF... |
2 years ago |
| SELECT IF (ptrp_reviewed, COUNT(page.page_id), 0) AS reviewed
,IF... |
2 years ago |
| SELECT page_title
,IF (ptrp_reviewed, COUNT(page.page_id), 0) AS reviewed... |
2 years ago |
| SELECT page_title
,IF (reviewed, COUNT(page.page_id), 0) AS reviewed
,IF... |
2 years ago |
| SELECT page_title
#,IF (reviewed, COUNT(page.page_id), 0) AS reviewed
#,IF... |
2 years ago |
| SELECT page_title
#,IF (reviewed, COUNT(page.page_id), 0) AS reviewed
#,IF... |
2 years ago |
| SELECT page_title,
#IF (reviewed, COUNT(page.page_id), 0) AS reviewed
#,IF... |
2 years ago |
| SELECT page_title,
IF (log_action = "reviewed", COUNT(page.page_id), 0) AS... |
2 years ago |
| SELECT page_title,
IF (log_action = "reviewed", COUNT(page.page_id), 0) AS... |
2 years ago |
| SELECT page_title,
IF (log_action = "reviewed", COUNT(page.page_id), 0) AS... |
2 years ago |
| SELECT page_title,
IF (log_action = "reviewed", COUNT(page.page_id), 0) AS... |
2 years ago |
| SELECT page_title,
IF (log_action = "reviewed", COUNT(page.page_id), 0) AS... |
2 years ago |
| SELECT page_title, log_action
#,IF( page_is_redirect,... |
2 years ago |
| SELECT page_title, log_action,
IF( page_is_redirect,... |
2 years ago |
| SELECT page_title, log_action,
IF( page_is_redirect,... |
2 years ago |
| SELECT page_title,
IF( page_is_redirect, COUNT(page.page_namespace), 0) AS... |
2 years ago |
| SELECT page_title,
IF( page_is_redirect, COUNT(page.page_namespace), 0) AS... |
2 years ago |
| SELECT page_title,
IF(
page_is_redirect,
COUNT(page.page_namespace),... |
2 years ago |
| SELECT page_title,
IF(
page_is_redirect,
COUNT(page.page_namespace),... |
2 years ago |
| SELECT
IF(
page_is_redirect,
COUNT(page.page_namespace),
0
) AS... |
2 years ago |
| SELECT IF( page_is_redirect, COUNT(page.page_namespace), 0 ) AS redir, IF(... |
2 years ago |
| SELECT page_namespace, MAX(notredir), MAX(redir)
FROM (
SELECT... |
2 years ago |
