Revision: 50173
Author: daniel
Date: 2009-05-04 12:54:49 +0000 (Mon, 04 May 2009)
Log Message:
-----------
use LEFT join for definitions
Modified Paths:
--------------
trunk/WikiWord/WikiWord/src/main/php/wwutils.php
Modified: trunk/WikiWord/WikiWord/src/main/php/wwutils.php
===================================================================
--- trunk/WikiWord/WikiWord/src/main/php/wwutils.php 2009-05-04 10:21:04 UTC
(rev 50172)
+++ trunk/WikiWord/WikiWord/src/main/php/wwutils.php 2009-05-04 12:54:49 UTC
(rev 50173)
@@ -47,7 +47,7 @@
$term = trim($term);
$sql = "SELECT M.*, O.*, definition FROM
{$wwTablePrefix}_{$lang}_meaning as M"
- . " JOIN {$wwTablePrefix}_{$lang}_definition as D ON M.concept =
D.concept "
+ . " LEFT JOIN {$wwTablePrefix}_{$lang}_definition as D ON
M.concept = D.concept "
. " JOIN {$wwTablePrefix}_{$wwThesaurusDataset}_origin as O ON
O.lang = \"" . mysql_real_escape_string($lang) . "\" AND M.concept =
O.local_concept "
. " WHERE term_text = \"" . mysql_real_escape_string($term) . "\""
. " ORDER BY freq DESC "
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
