http://www.mediawiki.org/wiki/Special:Code/MediaWiki/93558
Revision: 93558
Author: kipcool
Date: 2011-07-30 19:52:35 +0000 (Sat, 30 Jul 2011)
Log Message:
-----------
an other attempt at optimized query...
Modified Paths:
--------------
trunk/extensions/Wikidata/OmegaWiki/SpecialSuggest.php
Modified: trunk/extensions/Wikidata/OmegaWiki/SpecialSuggest.php
===================================================================
--- trunk/extensions/Wikidata/OmegaWiki/SpecialSuggest.php 2011-07-30
19:37:19 UTC (rev 93557)
+++ trunk/extensions/Wikidata/OmegaWiki/SpecialSuggest.php 2011-07-30
19:52:35 UTC (rev 93558)
@@ -247,10 +247,10 @@
// find the language of the syntrans and add attributes
of that language by adding the language DM to the list of default classes
// this first query returns the language_id
$sql = 'SELECT language_id' .
- " FROM {$dc}_syntrans, {$dc}_expression" .
- " WHERE {$dc}_syntrans.syntrans_sid = " .
$syntransId .
- " AND {$dc}_expression.expression_id =
{$dc}_syntrans.expression_id " .
+ " FROM {$dc}_expression" .
+ " WHERE {$dc}_expression.expression_id =
(SELECT expression_id FROM {$dc}_syntrans WHERE {$dc}_syntrans.syntrans_sid =
{$syntransId} LIMIT 1) " .
" LIMIT 1 " ;
+
$lang_res = $dbr->query( $sql );
$language_id = $dbr->fetchObject( $lang_res
)->language_id;
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
