<div dir="ltr"><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">Hi All/Hi John,</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">I thought my email went through but it was bounced.</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">I think the additional line is working perfectly to solved this problem. I did not see the long script since last week.</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">For record we are using 3.3.15.</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">Thank You very much for your help.</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">Zemy </div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif">IIUM Library</div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 4, 2017 at 8:54 AM, <span dir="ltr"><<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.<wbr>soton.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">The results of your email command are provided below. Attached is your<br>
original message.<br>
<br>
- Results:<br>
Ignoring non-text/plain MIME parts<br>
<br>
- Unprocessed:<br>
Thank you for your reply.<br>
We are using 3.3.15=20<br>
I will test adding the line in our file.<br>
For this information=20<br>
If not, when you have a slow query running, what does the 'State' show for =<br>
the query when you run (on the mysql server):<br>
>SHOW FULL PROCESS LIST;<br>
The state is STATISTIC.<br>
I will update when I test adding the line. TQ<br>
Zemy<br>
Sent from Mail for Windows 10<br>
From: <a href="mailto:eprints-tech-request@ecs.soton.ac.uk" target="_blank">eprints-tech-request@ecs.soton<wbr>.ac.uk</a><br>
Sent: Monday, April 3, 2017 4:43 PM<br>
To: <a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a><br>
Subject: Eprints-tech Digest, Vol 103, Issue 4<br>
<br>
- Ignored:<br>
Send Eprints-tech mailing list submissions to<br>
<a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk<wbr>/mailman/listinfo/eprints-tech</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:eprints-tech-request@ecs.soton.ac.uk" target="_blank">eprints-tech-request@ecs.soton<wbr>.ac.uk</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:eprints-tech-owner@ecs.soton.ac.uk" target="_blank">eprints-tech-owner@ecs.soton.a<wbr>c.uk</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Eprints-tech digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Long Query Lock (John Salter)<br>
<br>
<br>
------------------------------<wbr>------------------------------<wbr>----------<br>
<br>
Message: 1<br>
Date: Mon, 3 Apr 2017 08:39:58 +0000<br>
From: John Salter <<a href="mailto:J.Salter@leeds.ac.uk" target="_blank">J.Salter@leeds.ac.uk</a>><br>
Subject: Re: [EP-tech] Long Query Lock<br>
To: "<a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a>" <<a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a>><br>
Message-ID:<br>
<DB6PR0301MB2311F9504FB5D8EAD3<wbr>D89A5FC4080@DB6PR0301MB2311.eu<wbr>rprd03.prod.ou=<br>
<a href="http://tlook.com" rel="noreferrer" target="_blank">tlook.com</a>><br>
=09<br>
Content-Type: text/plain; charset=3D"utf-8"<br>
<br>
Hi Zemy Azmira,<br>
<br>
Which version of EPrints are you using? Does it look like you have the 'opt=<br>
imizer_search_depth' setting described here:<br>
<a href="https://github.com/eprints/eprints/issues/120" rel="noreferrer" target="_blank">https://github.com/eprints/epr<wbr>ints/issues/120</a><br>
<a href="http://www.eprints.org/tech.php/18677.html" rel="noreferrer" target="_blank">http://www.eprints.org/tech.ph<wbr>p/18677.html</a><br>
<br>
If not, does adding this help?<br>
If not, when you have a slow query running, what does the 'State' show for =<br>
the query when you run (on the mysql server):<br>
>SHOW FULL PROCESS LIST;<br>
<br>
Cheers,<br>
John<br>
<br>
From: <a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.soton<wbr>.ac.uk</a> [mailto:<a href="mailto:eprints-tech-bounces@ecs" target="_blank">eprints-tech-bounces@e<wbr>cs</a>=<br>
.<a href="http://soton.ac.uk" rel="noreferrer" target="_blank">soton.ac.uk</a>] On Behalf Of ZEMY AZMIRA IIUM<br>
Sent: 31 March 2017 16:45<br>
To: <a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a><br>
Subject: [EP-tech] Long Query Lock<br>
<br>
??Hi All,<br>
<br>
We have a problem with slow database connection due to long query. Somethin=<br>
g it locks out the system...my finding the query is something like below. I=<br>
think it is indexing. We did customized the repository with new fields, qu=<br>
ite a lot ...<br>
<br>
How to handle this problem? When this query is in the connection, it will s=<br>
low down eprints and sometimes, I will need to kill this process.<br>
<br>
Hope to get advise from everybody who might faced the same problem.<br>
<br>
Thank you in advance for your help. Have a nice weekend.<br>
<br>
Zemy Azmira<br>
IIUM Library, Malaysia<br>
<br>
INSERT INTO `cache15972759`(`pos`, `eprintid`) SELECT @i:=3D@i+1,=<br>
`eprintid` FROM (SELECT `eprint`.`eprintid` FROM `eprint` LEFT JOIN `eprin=<br>
t__ordervalues_en` ON `eprint`.`eprintid`=3D`eprint_<wbr>_ordervalues_en`.`eprin=<br>
tid`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rin=<br>
dex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=3D`eprint_<wbr>_rindex`.`epri=<br>
ntid` AND `eprint__rindex`.`field`=3D'ti<wbr>tle' AND `eprint__rindex`.`word`=3D=<br>
'evaluation') AS `and_139772665284464_0`, (SELECT `eprint`.`eprintid` AS `e=<br>
printid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`=<br>
.`eprintid`=3D`eprint__rindex`<wbr>.`eprintid` AND `eprint__rindex`.`field`=3D't=<br>
itle' AND `eprint__rindex`.`word`=3D'eff<wbr>ect') AS `and_139772665284464_1`, (=<br>
SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS=<br>
`eprint__rindex` WHERE `eprint`.`eprintid`=3D`eprint_<wbr>_rindex`.`eprintid` A=<br>
ND `eprint__rindex`.`field`=3D'ti<wbr>tle' AND `eprint__rindex`.`word`=3D'cop<wbr>per=<br>
') AS `and_139772665284464_2`, (SELE!<br>
CT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `e=<br>
print__rindex` WHERE `eprint`.`eprintid`=3D`eprint_<wbr>_rindex`.`eprintid` AND =<br>
`eprint__rindex`.`field`=3D'ti<wbr>tle' AND `eprint__rindex`.`word`=3D'ele<wbr>ctropl=<br>
ating') AS `and_139772665284464_3`, (SELECT `eprint`.`eprintid` AS `eprinti=<br>
d` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`epri=<br>
ntid`=3D`eprint__rindex`.`epri<wbr>ntid` AND `eprint__rindex`.`field`=3D'ti<wbr>tle' =<br>
AND `eprint__rindex`.`word`=3D'par<wbr>ameter') AS `and_139772665284464_4`, (SEL=<br>
ECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `e=<br>
print__rindex` WHERE `eprint`.`eprintid`=3D`eprint_<wbr>_rindex`.`eprintid` AND =<br>
`eprint__rindex`.`field`=3D'ti<wbr>tle' AND `eprint__rindex`.`word`=3D'adh<wbr>esion'=<br>
) AS `and_139772665284464_5`, (SELECT `eprint`.`eprintid` AS `eprintid` FRO=<br>
M `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=<br>
=3D`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`=3D'ti<wbr>tle' AND `=<br>
eprint__rindex`.`word`=3D'usin<wbr>g') AS `a!<br>
nd_139772665284464_6`, (SELECT `eprint`.`eprintid` AS `eprinti!<br>
d` FROM=20<br>
`eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=3D=<br>
`eprint__rindex`.`eprintid` AND `eprint__rindex`.`field`=3D'ti<wbr>tle' AND `epr=<br>
int__rindex`.`word`=3D'respons<wbr>e') AS `and_139772665284464_7`, (SELECT `epri=<br>
nt`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__ri=<br>
ndex` WHERE `eprint`.`eprintid`=3D`eprint_<wbr>_rindex`.`eprintid` AND `eprint__=<br>
rindex`.`field`=3D'title' AND `eprint__rindex`.`word`=3D'sur<wbr>face') AS `and_=<br>
139772665284464_8`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`=<br>
, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=3D`eprint_<wbr>=<br>
_rindex`.`eprintid` AND `eprint__rindex`.`field`=3D'ti<wbr>tle' AND `eprint__rin=<br>
dex`.`word`=3D'methodology') AS `and_139772665284464_9` WHERE `eprint`.`epr=<br>
intid`=3D`and_139772665284464_<wbr>0`.`eprintid` AND `eprint`.`eprintid`=3D`and_=<br>
139772665284464_1`.`eprintid` AND `eprint`.`eprintid`=3D`and_139<wbr>77266528446=<br>
4_2`.`eprintid` AND `eprint`.`eprintid`=3D`and_139<wbr>772665284464_3`.`eprintid=<br>
` AND `eprint`.`eprintid`=3D`and_139<wbr>772665!<br>
284464_4`.`eprintid` AND `eprint`.`eprintid`=3D`and_139<wbr>772665284464_5`.`ep=<br>
rintid` AND `eprint`.`eprintid`=3D`and_139<wbr>772665284464_6`.`eprintid` AND `e=<br>
print`.`eprintid`=3D`and_13977<wbr>2665284464_7`.`eprintid` AND `eprint`.`eprint=<br>
id`=3D`and_139772665284464_8`.<wbr>`eprintid` AND `eprint`.`eprintid`=3D`and_139<wbr>=<br>
772665284464_9`.`eprintid` AND (`eprint`.`metadata_visibility<wbr>` =3D 'show' A=<br>
ND (`eprint`.`eprint_status` =3D 'buffer' OR `eprint`.`eprint_status` =3D '=<br>
archive')) GROUP BY `eprint`.`eprintid`, `eprint__ordervalues_en`.`date<wbr>`, `=<br>
eprint__ordervalues_en`.`creat<wbr>ors_name`, `eprint__ordervalues_en`.`titl<wbr>e` O=<br>
RDER BY `eprint__ordervalues_en`.`date<wbr>` DESC, `eprint__ordervalues_en`.`cre=<br>
ators_name` ASC, `eprint__ordervalues_en`.`titl<wbr>e` ASC LIMIT 2147483647) `S`<br>
Select all. | Invert selection.<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/2017=" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk<wbr>/pipermail/eprints-tech/attach<wbr>ments/2017=</a><br>
0403/39013dae/attachment.html=<wbr>20<br>
<br>
------------------------------<br>
<br>
______________________________<wbr>_________________<br>
Eprints-tech mailing list<br>
<a href="mailto:Eprints-tech@ecs.soton.ac.uk" target="_blank">Eprints-tech@ecs.soton.ac.uk</a><br>
<a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk<wbr>/mailman/listinfo/eprints-tech</a><br>
<br>
<br>
End of Eprints-tech Digest, Vol 103, Issue 4<br>
******************************<wbr>**************<br>
<br>
<br>
- Done.<br>
<br>
<br><br>---------- Forwarded message ----------<br>From: <<a href="mailto:azmira@iium.edu.my" target="_blank">azmira@iium.edu.my</a>><br>To: "<a href="mailto:eprints-tech-request@ecs.soton.ac.uk" target="_blank">eprints-tech-request@ecs.<wbr>soton.ac.uk</a>" <<a href="mailto:eprints-tech-request@ecs.soton.ac.uk" target="_blank">eprints-tech-request@ecs.<wbr>soton.ac.uk</a>><br>Cc: <br>Bcc: <br>Date: Tue, 4 Apr 2017 08:54:07 +0800<br>Subject: RE: Eprints-tech Digest, Vol 103, Issue 4 -Long Query Lock<br><div lang="EN-US"><div class="m_-7995201573678742185gmail-m_-5232563672513865909WordSection1"><p class="MsoNormal">Hi John,</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Thank you for your reply.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">We are using 3.3.15 </p><p class="MsoNormal">I will test adding the line in our file.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">For this information </p><p class="MsoNormal">If not, when you have a slow query running, what does the 'State' show for the query when you run (on the mysql server):<u></u><u></u></p><p class="MsoNormal">>SHOW FULL PROCESS LIST;<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">The state is STATISTIC.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I will update when I test adding the line. TQ</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Zemy</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986" target="_blank">Mail</a> for Windows 10</p><p class="MsoNormal"><u></u> <u></u></p><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal" style="border:none;padding:0in"><b>From: </b><a href="mailto:eprints-tech-request@ecs.soton.ac.uk" target="_blank">eprints-tech-request@ecs.soton<wbr>.ac.uk</a><br><b>Sent: </b>Monday, April 3, 2017 4:43 PM<br><b>To: </b><a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a><br><b>Subject: </b>Eprints-tech Digest, Vol 103, Issue 4</p></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Send Eprints-tech mailing list submissions to</p><p class="MsoNormal"> <a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">To subscribe or unsubscribe via the World Wide Web, visit</p><p class="MsoNormal"> <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk<wbr>/mailman/listinfo/eprints-tech</a></p><p class="MsoNormal">or, via email, send a message with subject or body 'help' to</p><p class="MsoNormal"> <a href="mailto:eprints-tech-request@ecs.soton.ac.uk" target="_blank">eprints-tech-request@ecs.soton<wbr>.ac.uk</a></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">You can reach the person managing the list at</p><p class="MsoNormal"> <a href="mailto:eprints-tech-owner@ecs.soton.ac.uk" target="_blank">eprints-tech-owner@ecs.soton.a<wbr>c.uk</a></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">When replying, please edit your Subject line so it is more specific</p><p class="MsoNormal">than "Re: Contents of Eprints-tech digest..."</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Today's Topics:</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"> 1. Re: Long Query Lock (John Salter)</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">------------------------------<wbr>------------------------------<wbr>----------</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Message: 1</p><p class="MsoNormal">Date: Mon, 3 Apr 2017 08:39:58 +0000</p><p class="MsoNormal">From: John Salter <<a href="mailto:J.Salter@leeds.ac.uk" target="_blank">J.Salter@leeds.ac.uk</a>></p><p class="MsoNormal">Subject: Re: [EP-tech] Long Query Lock</p><p class="MsoNormal">To: "<a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a>" <<a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a>></p><p class="MsoNormal">Message-ID:</p><p class="MsoNormal"> <<a href="mailto:DB6PR0301MB2311F9504FB5D8EAD3D89A5FC4080@DB6PR0301MB2311.eurprd03.prod.outlook.com" target="_blank">DB6PR0301MB2311F9504FB5D8EAD3<wbr>D89A5FC4080@DB6PR0301MB2311.eu<wbr>rprd03.prod.outlook.com</a>></p><p class="MsoNormal"> </p><p class="MsoNormal">Content-Type: text/plain; charset="utf-8"</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Hi Zemy Azmira,</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Which version of EPrints are you using? Does it look like you have the 'optimizer_search_depth' setting described here:</p><p class="MsoNormal"><a href="https://github.com/eprints/eprints/issues/120" target="_blank">https://github.com/eprints/epr<wbr>ints/issues/120</a></p><p class="MsoNormal"><a href="http://www.eprints.org/tech.php/18677.html" target="_blank">http://www.eprints.org/tech.ph<wbr>p/18677.html</a></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">If not, does adding this help?</p><p class="MsoNormal">If not, when you have a slow query running, what does the 'State' show for the query when you run (on the mysql server):</p><p class="MsoNormal">>SHOW FULL PROCESS LIST;</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Cheers,</p><p class="MsoNormal">John</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">From: <a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@ecs.soton<wbr>.ac.uk</a> [mailto:<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" target="_blank">eprints-tech-bounces@e<wbr>cs.soton.ac.uk</a>] On Behalf Of ZEMY AZMIRA IIUM</p><p class="MsoNormal">Sent: 31 March 2017 16:45</p><p class="MsoNormal">To: <a href="mailto:eprints-tech@ecs.soton.ac.uk" target="_blank">eprints-tech@ecs.soton.ac.uk</a></p><p class="MsoNormal">Subject: [EP-tech] Long Query Lock</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">??Hi All,</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">We have a problem with slow database connection due to long query. Something it locks out the system...my finding the query is something like below. I think it is indexing. We did customized the repository with new fields, quite a lot ...</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">How to handle this problem? When this query is in the connection, it will slow down eprints and sometimes, I will need to kill this process.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Hope to get advise from everybody who might faced the same problem.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Thank you in advance for your help. Have a nice weekend.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Zemy Azmira</p><p class="MsoNormal">IIUM Library, Malaysia</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"> INSERT INTO `cache15972759`(`pos`, `eprintid`) SELECT @i:=@i+1, `eprintid` FROM (SELECT `eprint`.`eprintid` FROM `eprint` LEFT JOIN `eprint__ordervalues_en` ON `eprint`.`eprintid`=`eprint__o<wbr>rdervalues_en`.`eprintid`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='evalu<wbr>ation') AS `and_139772665284464_0`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='effec<wbr>t') AS `and_139772665284464_1`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='coppe<wbr>r') AS `and_139772665284464_2`, (SELE!</p><p class="MsoNormal"> CT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='elect<wbr>roplating') AS `and_139772665284464_3`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='param<wbr>eter') AS `and_139772665284464_4`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='adhes<wbr>ion') AS `and_139772665284464_5`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='using<wbr>') AS `a!</p><p class="MsoNormal"> nd_139772665284464_6`, (SELECT `eprint`.`eprintid` AS `eprinti!</p><p class="MsoNormal"> d` FROM </p><p class="MsoNormal">`eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='respo<wbr>nse') AS `and_139772665284464_7`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='surfa<wbr>ce') AS `and_139772665284464_8`, (SELECT `eprint`.`eprintid` AS `eprintid` FROM `eprint`, `eprint__rindex` AS `eprint__rindex` WHERE `eprint`.`eprintid`=`eprint__r<wbr>index`.`eprintid` AND `eprint__rindex`.`field`='titl<wbr>e' AND `eprint__rindex`.`word`='metho<wbr>dology') AS `and_139772665284464_9` WHERE `eprint`.`eprintid`=`and_13977<wbr>2665284464_0`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_1`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_2`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_3`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665!</p><p class="MsoNormal"> 284464_4`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_5`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_6`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_7`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_8`.`eprintid` AND `eprint`.`eprintid`=`and_13977<wbr>2665284464_9`.`eprintid` AND (`eprint`.`metadata_visibility<wbr>` = 'show' AND (`eprint`.`eprint_status` = 'buffer' OR `eprint`.`eprint_status` = 'archive')) GROUP BY `eprint`.`eprintid`, `eprint__ordervalues_en`.`date<wbr>`, `eprint__ordervalues_en`.`crea<wbr>tors_name`, `eprint__ordervalues_en`.`titl<wbr>e` ORDER BY `eprint__ordervalues_en`.`date<wbr>` DESC, `eprint__ordervalues_en`.`crea<wbr>tors_name` ASC, `eprint__ordervalues_en`.`titl<wbr>e` ASC LIMIT 2147483647) `S`</p><p class="MsoNormal">Select all. | Invert selection.</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">-------------- next part --------------</p><p class="MsoNormal">An HTML attachment was scrubbed...</p><p class="MsoNormal">URL: <a href="http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20170403/39013dae/attachment.html" target="_blank">http://mailman.ecs.soton.ac.uk<wbr>/pipermail/eprints-tech/attach<wbr>ments/20170403/39013dae/attach<wbr>ment.html</a> </p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">------------------------------</p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">______________________________<wbr>_________________</p><p class="MsoNormal">Eprints-tech mailing list</p><p class="MsoNormal"><a href="mailto:Eprints-tech@ecs.soton.ac.uk" target="_blank">Eprints-tech@ecs.soton.ac.uk</a></p><p class="MsoNormal"><a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk<wbr>/mailman/listinfo/eprints-tech</a></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">End of Eprints-tech Digest, Vol 103, Issue 4</p><p class="MsoNormal">******************************<wbr>**************</p><p class="MsoNormal"><u></u> <u></u></p></div></div><br></blockquote></div><br></div></div>