| SELECT LEFT(rev_timestamp,6) ym, up_value, count(1) edits, count(distinct... |
2 years ago |
| SELECT LEFT(rev_timestamp,6) ym, up_value, count(1) edits, count(distinct... |
2 years ago |
| SELECT LEFT(rev_timestamp,6) as year_month, up_value, count(1) edits,... |
2 years ago |
| SELECT LEFT(rev_timestamp,6) year_month, up_value, count(1) edits,... |
2 years ago |
| SELECT up_value, count(1) edits, count(distinct actor_user) users
FROM... |
3 years ago |
| SELECT IFNULL(up_value,'unknown') as gender, count(1)
FROM `user` as u
LEFT... |
3 years ago |
| SELECT IFNULL(up_value,'unknown') as gender, count(1)
FROM `user` as u
LEFT... |
3 years ago |
| SELECT up_value as gender, count(1)
FROM `user` as u
LEFT JOIN... |
3 years ago |
| SELECT up_property as gender, count(1)
FROM `user` as u
LEFT JOIN... |
3 years ago |
| SELECT user_id, up_property as gender
FROM `user` as u
LEFT JOIN... |
3 years ago |
| SELECT *
FROM `user` as u
LEFT JOIN user_properties up ON up.up_user =... |
3 years ago |
| SELECT *
FROM `user` as u
LEFT JOIN user_properties as up
WHERE... |
3 years ago |
| SELECT *
FROM `user` as u
LEFT JOIN user_properties as up
WHERE... |
3 years ago |
| SELECT *
FROM `user` u
LEFT JOIN user_properties up
WHERE up.up_property =... |
3 years ago |
| SELECT * FROM user_properties WHERE up_property = 'gender' LIMIT 10 |
3 years ago |
| SELECT * FROM user_properties WHERE up_property = 'gender' |
3 years ago |
| SELECT up_user FROM user_properties WHERE up_property = 'gender' GROUP BY 1... |
3 years ago |
| SELECT up_value, count(1) FROM user_properties WHERE up_property = 'gender'... |
3 years ago |
| SELECT up_property, count(1) FROM user_properties GROUP BY 1 order by 2 desc |
3 years ago |
| SELECT * FROM user_properties LIMIT 20 |
3 years ago |
| SELECT * FROM user_properties LIMIT 20 |
3 years ago |
| SELECT * FROM user_properties WHERE up_user = 'Yi7cuGhe' LIMIT 20 |
3 years ago |
| SELECT * FROM user_properties WHERE up_user = 3720893 LIMIT 20 |
3 years ago |
| SELECT * FROM `user` WHERE user_name = 'Yi7cuGhe' LIMIT 20 |
3 years ago |
| SELECT * FROM `user` LIMIT 20 |
3 years ago |
| SHOW TABLES FROM dewiki_p; |
3 years ago |
| select *
from `user`
LIMIT 1 |
3 years ago |
| select... |
3 years ago |
| SELECT * FROM revisions LIMIT 5 |
3 years ago |
