| use fawiki_p;
select user_name, page_title, count(rev_id) cnt from page
join... |
9 years ago |
| use fawiki_p;
select user_name, page_title, count(rev_id) cnt from page
join... |
9 years ago |
| use fawiki_p;
select user_name, page_title, count(rev_id) from page
join... |
9 years ago |
| use fawiki_p;
select distinct user_name, page_title from page
join... |
9 years ago |
| use fawiki_p;
select distinct user_name, page_title from page
join... |
9 years ago |
| use fawiki_p;
select distinct rev_user, page_title from page
join... |
9 years ago |
| use fawiki_p;
select page_title from page
join categorylinks
where cl_from =... |
9 years ago |
| use fawiki_p;
select page_title from page
join categorylinks
where cl_from =... |
9 years ago |
| use fawiki_p;
explain categorylinks;
/*select page_title from page
join... |
9 years ago |
| use fawiki_p;
select page_title from page
join categorylinks
where ct_from =... |
9 years ago |
| use fawiki_p;
select page_title from page where page_title like '%نظارت%'... |
9 years ago |
| select user_id, (now() - str_to_date(user_registration,... |
9 years ago |
| select user_id, (now() - str_to_date(user_registration,... |
9 years ago |
| select user_id, user_registration
from user; |
9 years ago |
