<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.errormessage, li.errormessage, div.errormessage
{mso-style-name:errormessage;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">This arises from an error calculating the LL that corresponds to a given alpha. Thus, a null value is embedded into the SQL query after
“</span>having LogLikelihood >= <span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">”.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I‘m not sure what that error is; it could be with your R installation.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">There may be a PHP warning (or several) in your http server error log that could shed light on the nature of the problem ; if you can
dig up any such warnings, I can probably give a closer diagnosis.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it>
<b>On Behalf Of </b>Thilo Wiertz<br>
<b>Sent:</b> 17 December 2020 20:44<br>
<b>To:</b> cwb@sslmit.unibo.it<br>
<b>Subject:</b> [CWB] CQPweb Collocations SQL error (CQPweb 3.2.42)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Dear Andrew, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I encounter an error trying to create collocations on CQPweb 3.2.42. I haven’t used our CQPweb install in a while and it is possible that the server environment (Mariadb version?) has changed. But this segment of the SQL statement also
looks suspicious to me: "having LogLikelihood >= and observed >= 5“ (missing value after LogLikelihood?). <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks so much for your help!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Thilo<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:#E7ECF7;border-collapse:collapse;caret-color: rgb(34, 34, 34)">
<tbody>
<tr>
<td valign="bottom" style="padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:11.5pt;font-family:"Verdana",sans-serif;color:#222222">CQPweb encountered an error and could not continue.<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td style="padding:3.75pt 3.75pt 3.75pt 3.75pt;background-color:var(--color_bg)">
<p class="errormessage"><span style="font-size:18.0pt;font-family:"Verdana",sans-serif;color:#222222">An SQL query did not run successfully!<o:p></o:p></span></p>
<p class="errormessage"><span style="font-size:18.0pt;font-family:"Verdana",sans-serif;color:#222222">Original query: select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)
as expected, log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5)
/ 12732474) ) as significance , sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * ( IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 *
COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) + IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))
/ (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) + IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq)
- 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) + IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq)
- 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) ) as LogLikelihood, freq_corpus_tagesschau_word.freq,
count(distinct(text_id)) as text_id_count from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item` and dist between -3 and 3 and freq_corpus_tagesschau_word.`freq` >= 5 group by `db_colloc_glri2o63ehp`.`word`
having LogLikelihood >= and observed >= 5 order by significance desc LIMIT 0, 50 /* from User: thilo | Function: require() | 2020-Dec-17 21:35 */<o:p></o:p></span></p>
<p class="errormessage"><span style="font-size:18.0pt;font-family:"Verdana",sans-serif;color:#222222">Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and observed
>= 5 order by significance desc LIMIT 0, 50 /* from Use' at line 16<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="bottom" style="padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:11.5pt;font-family:"Verdana",sans-serif;color:#222222">PHP debugging backtrace<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td style="padding:3.75pt 3.75pt 3.75pt 3.75pt;background-color:var(--color_bg)">
<pre><span style="color:#222222">array(4) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(43) "/var/www/html/diskurs/lib/exiterror-lib.php"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> int(367)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(9) "exiterror"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(3) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(3) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(38) "An SQL query did not run successfully!"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(2291) "Original query: <o:p></o:p></span></pre>
<pre><span style="color:#222222"><o:p> </o:p></span></pre>
<pre><span style="color:#222222">select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance ,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * (<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ) as LogLikelihood,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count<o:p></o:p></span></pre>
<pre><span style="color:#222222"> from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word<o:p></o:p></span></pre>
<pre><span style="color:#222222"> where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item`<o:p></o:p></span></pre>
<pre><span style="color:#222222"> and dist between -3 and 3<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> and freq_corpus_tagesschau_word.`freq` >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> group by `db_colloc_glri2o63ehp`.`word`<o:p></o:p></span></pre>
<pre><span style="color:#222222"> having LogLikelihood >= and observed >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> order by significance desc<o:p></o:p></span></pre>
<pre><span style="color:#222222"> LIMIT 0, 50<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> /* from User: thilo | Function: require() | 2020-Dec-17 21:35 */<o:p></o:p></span></pre>
<pre><span style="color:#222222"><o:p> </o:p></span></pre>
<pre><span style="color:#222222">"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(242) "Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and observed >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> order by significance desc<o:p></o:p></span></pre>
<pre><span style="color:#222222"> LIMIT 0, 50<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> /* from Use' at line 16 "<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> NULL<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> NULL<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(37) "/var/www/html/diskurs/lib/sql-lib.php"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> int(216)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(18) "exiterror_sqlquery"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(3) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> int(1064)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(227) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and observed >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> order by significance desc<o:p></o:p></span></pre>
<pre><span style="color:#222222"> LIMIT 0, 50<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> /* from Use' at line 16"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(2271) "select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance ,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * (<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ) as LogLikelihood,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count<o:p></o:p></span></pre>
<pre><span style="color:#222222"> from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word<o:p></o:p></span></pre>
<pre><span style="color:#222222"> where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item`<o:p></o:p></span></pre>
<pre><span style="color:#222222"> and dist between -3 and 3<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> and freq_corpus_tagesschau_word.`freq` >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> group by `db_colloc_glri2o63ehp`.`word`<o:p></o:p></span></pre>
<pre><span style="color:#222222"> having LogLikelihood >= and observed >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> order by significance desc<o:p></o:p></span></pre>
<pre><span style="color:#222222"> LIMIT 0, 50<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> /* from User: thilo | Function: require() | 2020-Dec-17 21:35 */"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [3]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(44) "/var/www/html/diskurs/lib/collocation-ui.php"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> int(512)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(12) "do_sql_query"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(1) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(2271) "select `db_colloc_glri2o63ehp`.`word`, count(`db_colloc_glri2o63ehp`.`word`) as observed, (22122 * (freq_corpus_tagesschau_word.freq) / 12754596) as expected,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> log2( (1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / 22122) / (IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)), 0.5) / 12732474) ) as significance ,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> sign(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) - (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)) * 2 * (<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) > 0, 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) * log(1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`) / (22122 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, (22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log((22122 - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (22122 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) > 0, ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) * log(((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`)) / (12732474 * (freq_corpus_tagesschau_word.freq) / 12754596)), 0) +<o:p></o:p></span></pre>
<pre><span style="color:#222222"> IF((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) > 0, (12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) * log((12732474 - ((freq_corpus_tagesschau_word.freq) - 1e0 * COUNT(`db_colloc_glri2o63ehp`.`word`))) / (12732474 * (12754596 - (freq_corpus_tagesschau_word.freq)) / 12754596)), 0)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ) as LogLikelihood,<o:p></o:p></span></pre>
<pre><span style="color:#222222"> freq_corpus_tagesschau_word.freq, count(distinct(text_id)) as text_id_count<o:p></o:p></span></pre>
<pre><span style="color:#222222"> from db_colloc_glri2o63ehp, freq_corpus_tagesschau_word<o:p></o:p></span></pre>
<pre><span style="color:#222222"> where `db_colloc_glri2o63ehp`.`word` = freq_corpus_tagesschau_word.`item`<o:p></o:p></span></pre>
<pre><span style="color:#222222"> and dist between -3 and 3<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> and freq_corpus_tagesschau_word.`freq` >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> group by `db_colloc_glri2o63ehp`.`word`<o:p></o:p></span></pre>
<pre><span style="color:#222222"> having LogLikelihood >= and observed >= 5<o:p></o:p></span></pre>
<pre><span style="color:#222222"> order by significance desc<o:p></o:p></span></pre>
<pre><span style="color:#222222"> LIMIT 0, 50<o:p></o:p></span></pre>
<pre><span style="color:#222222"> <o:p></o:p></span></pre>
<pre><span style="color:#222222"> /* from User: thilo | Function: require() | 2020-Dec-17 21:35 */"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [4]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(41) "/var/www/html/diskurs/exe/collocation.php"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> int(1)<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> array(1) {<o:p></o:p></span></pre>
<pre><span style="color:#222222"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(44) "/var/www/html/diskurs/lib/collocation-ui.php"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:#222222"> string(7) "require"<o:p></o:p></span></pre>
<pre><span style="color:#222222"> }<o:p></o:p></span></pre>
<pre><span style="color:#222222">}<o:p></o:p></span></pre>
</td>
</tr>
</tbody>
</table>
<div class="MsoNormal" align="center" style="text-align:center"><span style="color:black">
<hr size="3" width="100%" noshade="" style="color:#222222" align="center">
</span></div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:#E7ECF7;border-collapse:collapse;caret-color: rgb(34, 34, 34)">
<tbody>
<tr>
<td width="33%" style="width:33.0%;padding:3.75pt 3.75pt 3.75pt 3.75pt;background-color:var(--color_bg)">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#222222">CQPweb v3.2.42 © 2008-2020<o:p></o:p></span></p>
</td>
<td width="33%" style="width:33.0%;padding:3.75pt 3.75pt 3.75pt 3.75pt;background-color:var(--color_bg)">
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#222222"><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdiskurs.geographie.uni-freiburg.de%2Ftagesschau%2Fhelp.php%3Fui%3Dhello&data=04%7C01%7Ca.hardie%40lancaster.ac.uk%7C067b6a0feb0d4b64878d08d8a2d038ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637438362501705546%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=AB%2FBYTd5yf8G5LAagBwvBVnUM0Hy3DkN9eMdwwNFlSU%3D&reserved=0" target="cqpweb_help_browser">Help!
on CQPweb</a><o:p></o:p></span></p>
</td>
<td width="33%" style="width:33.0%;padding:3.75pt 3.75pt 3.75pt 3.75pt;background-color:var(--color_bg)">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#222222">You are logged in as user [thilo]<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<div id="templateForToolTip">
<p class="MsoNormal" style="background:#E7ECF7"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#222222;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse;background-color:var(--color_bg)">
<tbody>
<tr>
<td style="padding:3.75pt 3.75pt 3.75pt 3.75pt;background-color:var(--color_bg)">
<p class="MsoNormal"><span style="font-size:10.0pt"> <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>