Diskuse s uživatelem:Edgars2007/Ottův

How to generate

use cswikisource_p;
select concat('* [[',page_title,']]')
from page
where page_namespace=0 and page_is_redirect=0 and page_title LIKE "Ottův%";


use cswikisource_p;
select concat('* [[{{ns:',page_namespace,'}}:',page_title,']]')
from page
where page_namespace<>0 and page_is_redirect=0 and page_title LIKE "Ottův%";

@Wesalius: Should be working (I already deleted the code :D ). Here is the list of available tables, in case you want to play. Don't hesitate to ask if you need some help (but probably at my Latvian Wikipedia talk page, if I may ask). --Edgars2007 (diskuse) 29. 11. 2015, 13:30 (UTC)

Thank you, Edgars! This will be very useful. (I am a "customer" of Wesalius and plan to use the data sometimes in the future.) --Sapfan (diskuse) 29. 11. 2015, 13:57 (UTC)

Linkfix / uncat

I took the liberty of fixing the last link to real link instead of probably unintended categorization. Regards, —Mykhal (diskuse) 2. 6. 2018, 01:39 (UTC)