| use fawiki_p;
show indexes from logging_logindex; |
3 years ago |
| use fawiki_p;
show indexes from logging; |
3 years ago |
| use fawiki_p;
explain logging; |
3 years ago |
| use fawiki_p;
SELECT @@version |
4 years ago |
| use fawiki_p;
SELECT
rev_page,
rev_timestamp,
LEAD(rev_timestamp, 1)... |
4 years ago |
| use fawiki_p;
SELECT
rev_page,
rev_timestamp,
LEAD(rev_timestamp, 1)... |
4 years ago |
| use fawiki_p;
SELECT
rev_page,
rev_timestamp,
LEAD(rev_timestamp, 1)... |
4 years ago |
| use fawiki_p;
SELECT
rev_page,
rev_timestamp,
LEAD(rev_timestamp, 1)... |
4 years ago |
| use fawiki_p;
SELECT
rev_page,
rev_timestamp,
LEAD(rev_timestamp)... |
4 years ago |
| use fawiki_p;
SELECT rev_page, rev_timestamp
FROM revision
WHERE rev_page =... |
4 years ago |
| use fawiki_p;
SELECT DISTINCT
concat('کاربر:', page_title) AS title
FROM... |
4 years ago |
| use fawiki_p;
select distinct
concat('کاربر:', page_title),
... |
4 years ago |
| use fawiki_p;
show tables; |
6 years ago |
| use fawiki_p;
show tables; |
6 years ago |
| use fawiki_p;
show tables; |
6 years ago |
| use fawiki_p;
select count(*) from page; |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select
user_name,
count(rev_id) edit_count,
sum(case
... |
6 years ago |
| use fawiki_p;
select rev_id, rev_comment,
case
when length(case
when... |
6 years ago |
| use fawiki_p;
select rev_id, rev_comment,
case
when length(case
when... |
6 years ago |
| use fawiki_p;
select rev_id, rev_comment,
case
when len(case
when... |
6 years ago |
| use fawiki_p;
select rev_id, rev_comment,
case
when locate('/*',... |
6 years ago |
| use fawiki_p;
select rev_id, rev_comment,
case
when locate('/*',... |
6 years ago |
| use fawiki_p;
select rev_id, rev_comment,
locate('/*', rev_comment)
from... |
6 years ago |
| use fawiki_p;
select *
from revision
where rev_user_text = 'Huji'
order by... |
6 years ago |
| use fawiki_p;
select *
from revision
where rev_user_text = 'Huji'
order by... |
6 years ago |
| use fawiki_p;
select *
from logging_userindex
where log_type = 'block'
and... |
6 years ago |
| use fawiki_p;
select log_id, log_timestamp, log_title
from... |
6 years ago |
