SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
2 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT comment_text
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT *
FROM revision
LEFT JOIN comment on rev_comment_id=comment_id
where... |
3 years ago |
SELECT *
FROM revision
LEFT JOIN comment on rev_comment_id=comment_id
AND... |
3 years ago |
SELECT *
FROM revision
LEFT JOIN comment on rev_comment_id=comment_id
and... |
3 years ago |
SELECT *
FROM revision
where rev_page in... |
3 years ago |
select * from page where page_namespace=4 and page_title Like... |
3 years ago |
select page_id from page where page_namespace=4 and page_title Like... |
3 years ago |
select * from page where page_namespace=4 and page_title Like... |
3 years ago |
select * from page where page_namespace=4 and page_title Like "Correct%"; |
3 years ago |
select * from page where page_namespace=4 and page_title = "Correct typos... |
3 years ago |
select * from page order by page_id where page_namespace=4 and page_title =... |
3 years ago |
select * from page order by page_id desc limit 10 #where page_title =... |
3 years ago |
select * from page order by page_id desc limit 1 #where page_title =... |
3 years ago |
select * from page limit 1#where page_title = "Wikipedia:Correct typos in one click"; |
3 years ago |
select * from page where page_title = "Wikipedia:Correct typos in one click"; |
3 years ago |
select * from page where page_title like "Wikipedia:Correct typos in one click%"; |
3 years ago |
select * from page limit 1 |
3 years ago |
select * from pages limit 1 |
3 years ago |
SELECT *
FROM revision
limit 1; |
3 years ago |
SELECT rev_actor,rev_comment_id
FROM revision
limit 1; |
3 years ago |
SELECT rev_actor,rev_comment_id
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT rev_actor,rev_comment_id
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT actor_name,comment_text,actor_id
FROM recentchanges
LEFT JOIN... |
3 years ago |
SELECT actor_name,comment_text,actor_id
FROM recentchanges
LEFT JOIN... |
3 years ago |
SELECT actor_name,comment_text,actor_id
FROM recentchanges
LEFT JOIN... |
3 years ago |
SELECT actor_name,comment_text,actor_id
FROM recentchanges
LEFT JOIN... |
3 years ago |
SELECT rev_actor,rev_comment_id
FROM revision
LEFT JOIN comment on... |
3 years ago |
SELECT rev_actor,rev_comment
FROM revision
WHERE rev_comment LIKE "% -... |
3 years ago |
SELECT rev_actor,comment_text
FROM revision
WHERE rev_comment LIKE "% -... |
3 years ago |
SELECT rev_user_text,comment_text
FROM revision
WHERE rev_comment LIKE "% -... |
3 years ago |
SELECT actor_name,comment_text
FROM revision
WHERE rev_comment LIKE "% -... |
3 years ago |
SELECT actor_name,comment_text
FROM recentchanges
LEFT JOIN comment on... |
3 years ago |
SELECT actor_name, count(*)
FROM recentchanges
LEFT JOIN comment on... |
3 years ago |
SELECT actor_name, count(*)
FROM recentchanges
LEFT JOIN comment on... |
3 years ago |
SELECT *
FROM comment
LEFT JOIN comment on rc_comment_id =... |
3 years ago |
SELECT *
FROM comment
WHERE comment_text LIKE "% - [[Wikipedia:Correct typos... |
3 years ago |
SELECT *
FROM comment
#WHERE comment_text LIKE "% - [[Wikipedia:Correct... |
3 years ago |
SELECT *
FROM comment
WHERE comment_text LIKE "% - [[Wikipedia:Correct typos... |
3 years ago |
SELECT count(*)
FROM comment
WHERE comment_text LIKE "% -... |
3 years ago |