| use hewiki_p;
select user_name as "משתמש/ת",
count(*) as "עריכות ב90 הימים... |
1 week ago |
| use hewiki_p;
select user_name as "משתמש/ת",
count(*) as "עריכות ב90 הימים... |
1 week ago |
| select user_name, count(rev_id) from revision_userindex
inner join... |
1 week ago |
| select user_name, count(rev_id) from revision_userindex
inner join... |
1 week ago |
| select * from actor_user limit 5; |
1 week ago |
| select * from revision_userindex limit 5; |
1 week ago |
| show tables; |
1 week ago |
| select * from revision_userindex where rev_timestamp > 20240915000000 limit 5; |
1 week ago |
| select * from revision_userindex limit 5; |
1 week ago |
| select user_name, user_registration, format(NOW() - INTERVAL 365... |
1 week ago |
| select user_name, user_registration, format(NOW() - INTERVAL 365... |
1 week ago |
| select user_name, user_registration from user where (user_registration is... |
1 week ago |
| select user_name, user_registration,... |
1 week ago |
| select user_name, user_registration, DATE_FORMAT(CURRENT_TIMESTAMP -... |
1 week ago |
| select user_name, user_registration, DATE_FORMAT(NOW() - INTERVAL 365... |
1 week ago |
| select user_name, user_registration, format(NOW() - INTERVAL 365... |
1 week ago |
| select user_name, user_registration from user where (user_registration is... |
1 week ago |
| select user_name, user_registration from user where (user_registration is... |
1 week ago |
| SELECT format(NOW() - INTERVAL 30 DAY,'yyyyMMddHHmmssffff') |
1 week ago |
| SELECT format(NOW() - INTERVAL 30 days,'yyyyMMddHHmmssffff') |
1 week ago |
| SELECT format(NOW(),'yyyyMMddHHmmssffff') |
1 week ago |
| SELECT format(getdate(),'yyyyMMddHHmmssffff') |
1 week ago |
| select DATE_SUB(TIMESTAMP(), INTERVAL 2 WEEK)
|
1 week ago |
| select DATE_SUB(curdate(), INTERVAL 2 WEEK)
|
1 week ago |
| select user_name, user_registration from user where (user_registration is... |
1 week ago |
| select user_name, user_registration from user where (user_registration is... |
1 week ago |
| select user_name, user_registration from user where (user_registration is... |
1 week ago |
| select user_name, user_registration from user where user_registration is... |
1 week ago |
| select * from user limit 5; |
1 week ago |
