| use lvwiki_p;
SELECT concat('Kategorija:',page_title)
from page
where... |
5 years ago |
| use lvwiki_p;
SELECT concat('Kategorija:',page_title)
from page
where... |
5 years ago |
| use lvwiki_p;
SELECT concat('Kategorija:',page_title)
from page
where... |
5 years ago |
| use lvwiki_p;
SELECT *
from page
where page_is_redirect=0 and... |
5 years ago |
| use lvwiki_p;
SELECT *
from page
where page_is_redirect=0 and... |
5 years ago |
| use lvwiki_p;
SELECT * FROM categorylinks
limit 500 |
5 years ago |
| use lvwiki_p;
SELECT * FROM page p
#LEFT JOIN templatelinks t ON p.page_id =... |
5 years ago |
| use lvwiki_p;
SELECT CONCAT('Kategorija:',p.page_title) FROM page p
#LEFT... |
5 years ago |
| use lvwiki_p;
select rc_title
from recentchanges rc
join page p on... |
5 years ago |
| use lvwiki_p;
select *
from recentchanges rc
join page p on... |
5 years ago |
| use lvwiki_p;
select *
from recentchanges rc
join page p on... |
5 years ago |
| use lvwiki_p;
select *
from recentchanges
where rc_type in (1) and... |
5 years ago |
| use lvwiki_p;
select *
from recentchanges
where rc_type in (1)
limit 500 |
5 years ago |
| use lvwiki_p;
select *
from recentchanges
where rc_type not in (0,3,5)
limit 500 |
5 years ago |
| use lvwiki_p;
select *
from recentchanges
limit 500 |
5 years ago |
| use ltgwiki_p;
select *
from recent_changes
limit 500 |
5 years ago |
