| # dalībnieki pēc izveidotajiem rakstiem
use etwiki_p;
SELECT concat('*... |
8 years ago |
| # dalībnieki pēc izveidotajiem rakstiem
use lvwiki_p;
SELECT concat('*... |
8 years ago |
| # dalībnieki pēc izveidotajiem rakstiem
use lvwiki_p;
SELECT concat('*... |
8 years ago |
| # dalībnieki pēc izveidotajiem rakstiem
use lvwiki_p;
SELECT concat('*... |
8 years ago |
| USE lvwiki_p;
SELECT log_title, COUNT(*)
FROM logging
WHERE... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use u_kolossos_p;
Show tables; |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Menesis,... |
8 years ago |
| use lvwiki_p;
SELECT page_title as "Lapas nosaukums", page_len as "Lapas... |
8 years ago |
| use lvwiki_p;
SELECT page_title as "Lapas nosaukums", page_len as "Lapas... |
8 years ago |
| USE lvwiki_p;
SELECT log_title, COUNT(*)
FROM logging
WHERE... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT *#concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT *#concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT *#concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use ltwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use etwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| blank query |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| blank query |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT page_title as "Lapas nosaukums", page_len as "Lapas... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT #left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT #left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT #left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT r.rev_user#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
select ug.ug_user from user_groups ug where ug.ug_group='bot'
limit 20 |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT *#left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Diena,... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT *#concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT *#concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',r.rev_user_text,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT *#concat('* [[User:',u.user_name,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',u.user_name,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',u.user_name,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',u.user_name,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT page_title as "Lapas_nosaukums", page_len as... |
8 years ago |
| use lvwiki_p;
SELECT page_title as "Lapas_nosaukums", page_len as... |
8 years ago |
| use lvwiki_p;
SELECT *#page_title as "Lapas_nosaukums", page_len as... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',u.user_name,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT concat('* [[User:',u.user_name,']]'), COUNT(*) AS... |
8 years ago |
| use lvwiki_p;
SELECT left(t4.rev_timestamp,8) as Menesis,... |
8 years ago |
| use lvwiki_p;
SELECT page_title as "Lapas_nosaukums", page_len as... |
8 years ago |
| use lvwiki_p;
SELECT *# page_title as "Lapas_nosaukums", page_len as... |
8 years ago |
| use lvwiki_p;
SELECT *# page_title as "Lapas_nosaukums", page_len as... |
8 years ago |
| USE lvwiki_p;
SELECT LEAST(REPLACE(log_title,'_',' '),log_user_text),... |
8 years ago |
| USE lvwiki_p;
SELECT log_title, COUNT(*)
FROM logging
WHERE... |
8 years ago |
| USE lvwiki_p;
SELECT *#log_title, COUNT(*)
FROM logging
WHERE... |
8 years ago |
| blank query |
8 years ago |
| select #count(*)#
page_namespace, page_title
from page
where page_namespace... |
8 years ago |
| select #count(*)#
page_namespace, page_title
from page
where... |
8 years ago |
| select count(*)# page_namespace, page_title
from page
where... |
8 years ago |
| select page_namespace, page_title
from page
where page_is_redirect=1 and... |
8 years ago |
| select *
from page
where page_title="Wildthing61476/monobook.js" and page_namespace=2 |
8 years ago |
| select *
from page
where page_title="User:Wildthing61476/monobook.js" |
8 years ago |
