#deletion nominations by patrollers
SELECT log_r.log_user_text,
COUNT(CASE... |
6 years ago |
#deletion nominations
SELECT log_r.log_user_text,
COUNT(CASE... |
6 years ago |
#deletion nominations
SELECT log_r.log_user_text,
COUNT(CASE... |
6 years ago |
#deletion nominations
SELECT log_r.log_user_text,
COUNT(CASE... |
6 years ago |
#deletion nominations
SELECT log_r.log_user_text,
COUNT(CASE... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
COUNT(CASE log_r.log_action WHEN 'reviewed'... |
6 years ago |
SELECT log_r.log_user_text,
SUM(CASE log_r.log_action WHEN 'reviewed' THEN... |
6 years ago |
SELECT log_r.log_user_text,
CASE log_r.log_action WHEN 'reviewed' THEN 1... |
6 years ago |
SELECT log_r.log_user_text,
CASE log_r.log_action WHEN 'reviewed' THEN 1... |
6 years ago |
SELECT log_r.log_user_text, CASE log_r.log_action WHEN 'reviewed' THEN 1 END... |
6 years ago |
SELECT log_r.log_user_text, CASE log_r.log_action WHEN 'reviewed' THEN 1... |
6 years ago |
SELECT log_r.log_user_text, SUM(CASE log_r.log_action WHEN 'reviewed' THEN... |
6 years ago |
SELECT log_r.log_user_text, SUM(CASE log_r.log_action WHEN 'reviewed' THEN... |
6 years ago |
SELECT log_r.log_user_text, SUM(log_r.log_action = 'reviewed') AS reviews,
#... |
6 years ago |
SELECT log_r.log_user_text
# SUM(log_r.log_action = 'reviewed') AS... |
6 years ago |
SELECT log_r.log_user_text,
SUM(log_r.log_action = 'reviewed') AS... |
6 years ago |
SELECT log_r.log_user_text,
SUM(log_r.log_action = 'reviewed') AS... |
6 years ago |
SELECT log_r_log_user_text,
SUM(log_r.log_action = 'reviewed') AS... |
6 years ago |
SELECT log_r.*, COUNT (log_r.log_action)
FROM logging_userindex log_r... |
6 years ago |
SELECT log_r.*, COUNT (DECODE (log_action, 'reviewed', 1)) AS reviewed,... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.* #, log_d.*
FROM logging_userindex log_r
#JOIN... |
6 years ago |
SELECT log_r.*, log_d.*
FROM logging_userindex log_r JOIN... |
6 years ago |
SELECT log_r.* log_d.*
FROM logging_userindex log_r JOIN logging_userindex... |
6 years ago |
SELECT log_r.* log_d.*
FROM logging_userindex log_r JOIN logging_userindex... |
6 years ago |
SELECT log_r.*
FROM logging_userindex log_r
WHERE... |
6 years ago |
SELECT log_r.*
FROM logging_userindex log_r
WHERE... |
6 years ago |
SELECT log_r.*
FROM logging_userindex log_r
LEFT JOIN... |
6 years ago |
DESCRIBE logging
|
6 years ago |