| SELECT DATE_FORMAT(rc_timestamp, '%Y%m%d') AS rc_date, COUNT(*)
FROM... |
1 year ago |
| SELECT DATE_FORMAT(rc_timestamp, '%Y%m%d') AS rc_date, COUNT(*)
FROM... |
1 year ago |
| SELECT rc_timestamp, DATE_FORMAT(rc_timestamp, '%Y%m%d')
FROM... |
1 year ago |
| SELECT NOW()
/*
SELECT COUNT(*)
FROM recentchanges
WHERE rc_namespace = 0... |
1 year ago |
| SELECT COUNT(*)
FROM recentchanges
WHERE rc_type IN (0, 1)
#... |
1 year ago |
| SELECT DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 0 DAY), '%Y%m%d000000') |
1 year ago |
| SELECT DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 DAY), '%Y%m%d000000') |
1 year ago |
