EPrints Technical Mailing List Archive

Message: #01225


< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] + attachment (was: Re: Indexer process chokes mysql after repository launch)


Am 23.10.2012 10:33, schrieb Florian Heß:
Hi,


sorry, the attachment ...

I'd be very glad if someone help me, please.

After launching our EPrints repository with a migrated collection of
about 12500 documents, the indexer sent to mysql a monstrous query at a
time I'd already called it a day and didn't leave any processes running
and any succeeding queries would remain locked until the connection
limit of mysql was reached (300 conns). Guess simply setting the limit
to, say, 1000 will not really solve the problem?

The relevant mysql process_list entry is attached. What is wrong? I
think it is unlikely (and I hope it's not this) that it is the number of
eprints as the fulltexts were available for a couple of weeks before
launch. It is more likely that it has to do with EPrints repository
being unlocked for the public, is it?

Additional by-problem: We consider it a major security risk that EPrints
sends sensible information to the client. How to deactivate that one for
all? (notwithstanding appropriate logging)

EPrints System Error

Error connecting to MySQL server: Too many connections. To fix this
increase max_connections in my.cnf:

[mysqld]
max_connections=300


Kind regards,
Florian Heß




--
UB Heidelberg (Altstadt)
Plöck 107-109, 69117 HD
- Informationstechnik
- WWW-Redaktion
Tel. 06221 / 54 3550
http://www.ub.uni-heidelberg.de/
Id	User	Host	db	Command	Time	State	Info
283619	heidok	localhost	heidok_ep	Query	49491	statistics	INSERT INTO `cache915`(`pos`, `eprintid`) SELECT @i:=@i+1, `eprintid` FROM (SELECT `eprint`.`eprintid` FROM `eprint` LEFT JOIN `eprint__ordervalues_de` ON `eprint`.`eprintid`=`eprint__ordervalues_de`.`eprintid`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='philosophische' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='philosophische' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='philosophische' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='philosophische') AS `or_80898096` WHERE `eprint`.`eprintid`=`or_80898096`.`eprintid`) AS `and_126413200_0`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='fakultaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='fakultaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='fakultaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='fakultaet') AS `or_139827358530136` WHERE `eprint`.`eprintid`=`or_139827358530136`.`eprintid`) AS `and_126413200_1`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='der') AS `or_139827358515520` WHERE `eprint`.`eprintid`=`or_139827358515520`.`eprintid`) AS `and_126413200_2`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='ruprecht' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='ruprecht' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='ruprecht' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='ruprecht') AS `or_80903864` WHERE `eprint`.`eprintid`=`or_80903864`.`eprintid`) AS `and_126413200_3`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='karl' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='karl' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='karl' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='karls') AS `or_139827358529272` WHERE `eprint`.`eprintid`=`or_139827358529272`.`eprintid`) AS `and_126413200_4`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='universitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='universitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='universitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='universitaet') AS `or_86399488` WHERE `eprint`.`eprintid`=`or_86399488`.`eprintid`) AS `and_126413200_5`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='heidelberg' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='heidelberg' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='heidelberg' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='heidelberg') AS `or_111029784` WHERE `eprint`.`eprintid`=`or_111029784`.`eprintid`) AS `and_126413200_6`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='prof' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='prof' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='prof' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='prof') AS `or_111030744` WHERE `eprint`.`eprintid`=`or_111030744`.`eprintid`) AS `and_126413200_7`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='detlef' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='detlef' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='detlef' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='detlef') AS `or_126330992` WHERE `eprint`.`eprintid`=`or_126330992`.`eprintid`) AS `and_126413200_8`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='junker' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='junker' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='junker' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='junker') AS `or_126331952` WHERE `eprint`.`eprintid`=`or_126331952`.`eprintid`) AS `and_126413200_9`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='zur' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='zur' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='zur' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='zur') AS `or_126359952` WHERE `eprint`.`eprintid`=`or_126359952`.`eprintid`) AS `and_126413200_10`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='erlangung' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='erlangung' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='erlangung' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='erlangung') AS `or_126360912` WHERE `eprint`.`eprintid`=`or_126360912`.`eprintid`) AS `and_126413200_11`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='der') AS `or_126361872` WHERE `eprint`.`eprintid`=`or_126361872`.`eprintid`) AS `and_126413200_12`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='wuerde' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='wuerde' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='wuerde' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='wuerde') AS `or_126362832` WHERE `eprint`.`eprintid`=`or_126362832`.`eprintid`) AS `and_126413200_13`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='eine' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='eine' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='eine' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='eines') AS `or_126363792` WHERE `eprint`.`eprintid`=`or_126363792`.`eprintid`) AS `and_126413200_14`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='doktor' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='doktor' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='doktor' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='doktors') AS `or_126365336` WHERE `eprint`.`eprintid`=`or_126365336`.`eprintid`) AS `and_126413200_15`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='der') AS `or_126366296` WHERE `eprint`.`eprintid`=`or_126366296`.`eprintid`) AS `and_126413200_16`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='philosophie' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='philosophie' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='philosophie' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='philosophie') AS `or_126367256` WHERE `eprint`.`eprintid`=`or_126367256`.`eprintid`) AS `and_126413200_17`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='phil' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='phil' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='phil' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='phil') AS `or_126373456` WHERE `eprint`.`eprintid`=`or_126373456`.`eprintid`) AS `and_126413200_18`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='von' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='von' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='von' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='von') AS `or_126374416` WHERE `eprint`.`eprintid`=`or_126374416`.`eprintid`) AS `and_126413200_19`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='der') AS `or_126375376` WHERE `eprint`.`eprintid`=`or_126375376`.`eprintid`) AS `and_126413200_20`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='wehrmacht' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='wehrmacht' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='wehrmacht' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='wehrmacht') AS `or_126376336` WHERE `eprint`.`eprintid`=`or_126376336`.`eprintid`) AS `and_126413200_21`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='zur' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='zur' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='zur' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='zur') AS `or_126377296` WHERE `eprint`.`eprintid`=`or_126377296`.`eprintid`) AS `and_126413200_22`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='bundeswehr' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='bundeswehr' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='bundeswehr' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='bundeswehr') AS `or_126382488` WHERE `eprint`.`eprintid`=`or_126382488`.`eprintid`) AS `and_126413200_23`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='personelle' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='personelle' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='personelle' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='personelle') AS `or_126383448` WHERE `eprint`.`eprintid`=`or_126383448`.`eprintid`) AS `and_126413200_24`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='kontinuitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='kontinuitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='kontinuitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='kontinuitaet') AS `or_126384408` WHERE `eprint`.`eprintid`=`or_126384408`.`eprintid`) AS `and_126413200_25`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='und' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='und' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='und' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='und') AS `or_126385368` WHERE `eprint`.`eprintid`=`or_126385368`.`eprintid`) AS `and_126413200_26`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='diskontinuitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='diskontinuitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='diskontinuitaet' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='diskontinuitaet') AS `or_126390720` WHERE `eprint`.`eprintid`=`or_126390720`.`eprintid`) AS `and_126413200_27`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='beim' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='beim' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='beim' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='beim') AS `or_126391680` WHERE `eprint`.`eprintid`=`or_126391680`.`eprintid`) AS `and_126413200_28`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='aufbau' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='aufbau' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='aufbau' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='aufbau') AS `or_126392640` WHERE `eprint`.`eprintid`=`or_126392640`.`eprintid`) AS `and_126413200_29`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='der' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='der') AS `or_126393600` WHERE `eprint`.`eprintid`=`or_126393600`.`eprintid`) AS `and_126413200_30`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='deutschen' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='deutschen' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='deutschen' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='deutschen') AS `or_126399304` WHERE `eprint`.`eprintid`=`or_126399304`.`eprintid`) AS `and_126413200_31`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='streitkraefte' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='streitkraefte' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='streitkraefte' UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='streitkraefte') AS `or_126400264` WHERE `eprint`.`eprintid`=`or_126400264`.`eprintid`) AS `and_126413200_32`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint` WHERE ((( `eprint`.`date_year` = 1955 ))) UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND (`eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='1955' OR `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='1955' OR `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='1955' OR `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='1955')) AS `or_126401368` WHERE `eprint`.`eprintid`=`or_126401368`.`eprintid`) AS `and_126413200_33`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint` WHERE ((( `eprint`.`date_year` = 1966 ))) UNION SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND (`eprint__rindex`.`field`='documents' AND `eprint__rindex`.`word`='1966' OR `eprint__rindex`.`field`='title' AND `eprint__rindex`.`word`='1966' OR `eprint__rindex`.`field`='abstract' AND `eprint__rindex`.`word`='1966' OR `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='1966')) AS `or_126402448` WHERE `eprint`.`eprintid`=`or_126402448`.`eprintid`) AS `and_126413200_34`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='dr') AS `and_139827358528456_0`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='dr') AS `and_139827358528456_1`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='h') AS `and_139827358528456_2`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='c') AS `and_139827358528456_3`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='d') AS `and_139827358528456_4`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='i') AS `and_139827358528456_5`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='s') AS `and_139827358528456_6`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='s') AS `and_139827358528456_7`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='e') AS `and_139827358528456_8`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='r') AS `and_139827358528456_9` WHERE `eprint`.`eprintid`=`and_139827358528456_0`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_1`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_2`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_3`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_4`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_5`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_6`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_7`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_8`.`eprintid` AND `eprint`.`eprintid`=`and_139827358528456_9`.`eprintid`) AS `or_126400336` WHERE `eprint`.`eprintid`=`or_126400336`.`eprintid`) AS `and_126413200_35`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='t') AS `and_126322288_0`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='a') AS `and_126322288_1`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='t') AS `and_126322288_2`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='i') AS `and_126322288_3`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='o') AS `and_126322288_4`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='n') AS `and_126322288_5`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`='creators_name' AND `eprint__rindex`.`word`='dr') AS `and_126322288_6` WHERE `eprint`.`eprintid`=`and_126322288_0`.`eprintid` AND `eprint`.`eprintid`=`and_126322288_1`.`eprintid` AND `eprint`.`eprintid`=`and_126322288_2`.`eprintid` AND `eprint`.`eprintid`=`and_126322288_3`.`eprintid` AND `eprint`.`eprintid`=`and_126322288_4`.`eprintid` AND `eprint`.`eprintid`=`and_126322288_5`.`eprintid` AND `eprint`.`eprintid`=`and_126322288_6`.`eprintid`) AS `or_126401272` WHERE `eprint`.`eprintid`=`or_126401272`.`eprintid`) AS `and_126413200_36` WHERE `eprint`.`eprintid`=`and_126413200_0`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_1`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_2`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_3`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_4`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_5`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_6`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_7`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_8`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_9`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_10`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_11`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_12`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_13`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_14`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_15`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_16`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_17`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_18`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_19`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_20`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_21`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_22`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_23`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_24`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_25`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_26`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_27`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_28`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_29`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_30`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_31`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_32`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_33`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_34`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_35`.`eprintid` AND `eprint`.`eprintid`=`and_126413200_36`.`eprintid` AND `eprint`.`metadata_visibility` = 'show' AND `eprint`.`eprint_status` = 'archive' GROUP BY `eprint`.`eprintid`, `eprint__ordervalues_de`.`date`, `eprint__ordervalues_de`.`creators_name`, `eprint__ordervalues_de`.`title` ORDER BY `eprint__ordervalues_de`.`date` DESC, `eprint__ordervalues_de`.`creators_name` ASC, `eprint__ordervalues_de`.`title` ASC) `S`