On 29 August 2011 14:52, Klemen Kocjancic <klemenkocjancic@gmail.com> wrote:
I'm turning to you with request. Is it possible for you to make python script, which would make compitation of articles (from :sl - Slovenian WP):
a) created by me (Username: Klemen Kocjancic) and
b) linked to http://sl.wikipedia.org/wiki/Portal:Vojaštvo

This is hard to do with a script, but I ran a query on the toolserver to do this for you:
mysql> select * from (select rev_page as fr_page, min(rev_id) as fr_rev from pagelinks inner join revision on rev_page=pl_from where pl_namespace=100 and pl_title='Vojaštvo') as firstrevs left join revision on rev_id=fr_rev where rev_user_text='Klemen_Kocjancic' limit 1;
Empty set (0.15 sec)

Essentially, it seems none of the 19081 pages linking to Portal:Vojaštvo:

mysql> select count(*) from pagelinks where pl_namespace=100 and pl_title='Vojaštvo';
+----------+
| count(*) |
+----------+
|    19081 |
+----------+
1 row in set (0.01 sec)

have you as author of the first revision. Essentially - requests of the nature 'could I get a list of articles that conform to the following rules' should be directed to the Toolserver query service: https://jira.toolserver.org/browse/DBQ

Using pywikipedia, it should be possible to use filter options to archieve the same result, but I haven't used pagegenerators.py much lately.
 

The script should combined both search quiries (with removing duplicated articles) and make a list of articles in following form:
yyyy xxxx
'''X'''Y
yyyy xxxx
'''X'''Y
yyyy xxxx

X = article's title
Y = article's text
This is unclear to me. What should xxxx and yyyy be? Is the article text supposed to fit onto the same line as the title? What should be done with line breaks?
 
Best,
Merlijn