| SELECT DISTINCT
cl_to
FROM categorylinks AS cat
JOIN page AS pg1
ON... |
11 months ago |
| SELECT DISTINCT
cl_to
FROM categorylinks AS cat
JOIN page AS pg1
ON... |
11 months ago |
| -- o |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| -- o |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM... |
2 years ago |
| -- o |
2 years ago |
| SELECT page_title
FROM revision
JOIN comment
ON rev_comment_id =... |
3 years ago |
| SELECT page_title
FROM revision
JOIN comment
ON rev_comment_id =... |
3 years ago |
| SELECT COUNT(DISTINCT rev_page)
FROM revision
JOIN comment
ON rev_comment_id... |
3 years ago |
| SELECT COUNT(DISTINCT rev_page)
FROM revision
JOIN comment
ON rev_comment_id... |
3 years ago |
| SELECT COUNT(DISTINCT rev_page)
FROM revision
JOIN comment
ON rev_comment_id... |
3 years ago |
| SELECT COUNT(DISTINCT rev_page)
FROM revision
JOIN comment
ON rev_comment_id... |
3 years ago |
| SELECT COUNT(DISTINCT rev_page)
FROM revision
JOIN comment
ON rev_comment_id... |
3 years ago |
| SELECT COUNT(*)
FROM revision
JOIN comment
ON rev_comment_id =... |
3 years ago |
| -- y |
3 years ago |
| SELECT actor_name AS user,
COUNT(*) AS cnt
FROM `revision`
JOIN `comment`
ON... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
|
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
SELECT actor_name AS user,
COUNT(*) AS... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
SELECT actor_name AS user,
COUNT(*) AS... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
SELECT actor_name AS user,
COUNT(*) AS... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
SELECT actor_name AS user,
COUNT(*) AS... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
SELECT actor_name AS user,
COUNT(*) AS... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
SELECT actor_name AS user,
COUNT(*) AS... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP; |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
select page_namespace, page_title
from... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
select page_namespace, page_title
from... |
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
|
3 years ago |
| -- SELECT CURRENT_TIMESTAMP;
select page_namespace, page_title
from... |
3 years ago |
| SELECT CURRENT_TIMESTAMP; |
3 years ago |
| SELECT DATEDIFF(CURRENT_TIMESTAMP, 20210701000000); |
3 years ago |
| SELECT DATEDIFF(CURRENT_TIMESTAMP, rev_timestamp)
from revision
limit 1; |
3 years ago |
| SELECT CURRENT_TIMESTAMP; |
3 years ago |
| select getdate(); |
3 years ago |
| select datediff(20040628101300, rev_timestamp)
from revision
limit 1; |
3 years ago |
| select datediff(day,20040628101300, rev_timestamp)
from revision
limit 1; |
3 years ago |
| select datediff(day,20040628101300 - rev_timestamp)
from revision
limit 1; |
3 years ago |
| select (20040628101300 - rev_timestamp)
from revision
limit 1; |
3 years ago |
| select rev_timestamp
from revision
limit 1; |
3 years ago |
| select rev_timestamp
from revisions
limit 1; |
3 years ago |
| show tables;
select
el_index_60,
count(el_from) as cnt
from... |
3 years ago |
| show tables;
select
el_index_60,
count(el_from) as cnt
from... |
3 years ago |
| show tables;
select el_index_60, count(el_from)
from externallinks
group by... |
3 years ago |
| show tables;
select *
from externallinks
limit 30;
/* SELECT page_id,... |
3 years ago |
| show tables;
select *
from externallinks
limit 3;
/* SELECT page_id,... |
3 years ago |
| show tables;
/* SELECT page_id, pp_value
FROM page
JOIN page_props
ON... |
3 years ago |
| show tables;
select *
from globaluser
where gu_name = 'Ahmad Kanik'
order... |
3 years ago |
| show tables;
select *
from globaluser
order by gu_id desc
limit 3;
/*... |
3 years ago |
| show tables;
select *
from globaluser
limit 3;
/* SELECT page_id,... |
3 years ago |
| show tables;
select *
from localuser
limit 3;
/* SELECT page_id,... |
3 years ago |
| show tables;
select *
from global_group_restrictions
limit 3;
/* SELECT... |
3 years ago |
| show tables;
select *
from global_preferences
limit 3;
/* SELECT page_id,... |
3 years ago |
| show tables;
select *
from global_user_groups
limit 3;
/* SELECT page_id,... |
3 years ago |
| show tables;
select *
from globaluser
limit 3;
/* SELECT page_id,... |
3 years ago |
| select *
from globaluser
limit 3;
/* SELECT page_id, pp_value
FROM... |
3 years ago |
| select *
from centralauth_p.globaluser
limit 3;
/* SELECT page_id,... |
3 years ago |
| SELECT page_id, pp_value
FROM page
JOIN page_props
ON pp_page =... |
3 years ago |
| SELECT page_id, pp_value
FROM page
JOIN page_props
ON pp_page =... |
3 years ago |
| SELECT page_id, pp_value
FROM page
JOIN page_props
ON pp_page =... |
3 years ago |
| SELECT page_id, pp_value
FROM page
JOIN page_props
ON pp_page =... |
3 years ago |
| SELECT page_id, pp_value
FROM page
JOIN page_props
ON pp_page =... |
3 years ago |
| SELECT *
FROM page
JOIN page_props
ON pp_page = page_id
WHERE page_namespace... |
3 years ago |
| SELECT page_title
FROM page
JOIN page_props
ON pp_page = page_id
WHERE... |
3 years ago |
| SELECT page_title
FROM page
WHERE page_namespace IN (2, 3)
AND... |
3 years ago |
| SELECT page_title
FROM page
WHERE page_namespace IN (2, 3)
AND... |
3 years ago |
| select "test"; |
3 years ago |
| SELECT
user_name user,
COUNT(*) AS cnt
FROM
logging
JOIN actor ON... |
3 years ago |
| SELECT
user_name user,
COUNT(*) AS cnt
FROM
logging
JOIN actor ON... |
3 years ago |
| SELECT
user_name user,
count(*) as patrol_cnt
FROM
logging
JOIN... |
3 years ago |
| SELECT
user_name user,
count(*) as patrol_cnt
FROM
logging
JOIN... |
3 years ago |
| SELECT
user_name user,
count(*) as patrol_cnt
FROM
logging
JOIN... |
3 years ago |
| SELECT
user_name user,
count(*) as patrol_cnt
FROM
logging
JOIN... |
3 years ago |
| SELECT *
FROM change_tag
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
WHERE actor_name =... |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
WHERE actor_name =... |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
WHERE actor_name =... |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
WHERE actor_name =... |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
LIMIT 10 DESC; |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
DESC
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
JOIN actor
ON actor_id = rev_actor
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
LIMIT 10; |
3 years ago |
| SELECT *
FROM page
where page_is_redirect = 1
LIMIT 10; |
3 years ago |
| SELECT *
FROM page
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
/*WHERE rev_actor = 189593*/
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
WHERE rev_actor = 189593
LIMIT 10; |
3 years ago |
| SELECT *
FROM revision
LIMIT 10; |
3 years ago |
| SELECT *
FROM page
LIMIT 10; |
3 years ago |
