| SELECT
LEFT(log_timestamp, 8) as day,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
| SELECT log_timestamp
FROM logging
WHERE log_type="thanks"
LIMIT 100; |
8 years ago |
| SELECT log_timestamp
FROM logging
WHERE log_type="thanks"; |
8 years ago |
| SELECT log_timestamp
FROM logging
WHERE log_type="thanks"
GROUP BY week; |
8 years ago |
| SELECT log_timestamp
FROM logging
WHERE log_type="thanks"
GROUP BY week; |
8 years ago |
| SELECT
LEFT(log_timestamp, 8) as week,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
| SELECT
LEFT(log_timestamp, 6) as week,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
| SELECT
LEFT(log_timestamp, 6) as week,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
| SELECT
LEFT(log_timestamp, 6) as month,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
| SELECT
LEFT(log_timestamp, 6) as month,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
| USE eswiki;
SELECT
LEFT(log_timestamp, 6) as month,
COUNT(*)
FROM... |
8 years ago |
| USE frwiki;
SELECT
LEFT(log_timestamp, 6) as month,
COUNT(*)
FROM... |
8 years ago |
| USE frwiki
SELECT
LEFT(log_timestamp, 6) as month,
COUNT(*)
FROM logging... |
8 years ago |
| SELECT
LEFT(log_timestamp, 6) as month,
COUNT(*)
FROM logging
WHERE... |
8 years ago |
