This query is marked as a draft This query has been published by Evolutionoftheuniverse.

SQL

x
 
/*SELECT if(right(soundex('intéresser'),3) = right(soundex('enterese'),3),1,0), soundex('intéresser'), soundex('enterese');
SELECT if(right(soundex('water'),3) = right(soundex('wasser'),3),1,0), soundex('water'), soundex('wasser');*/
/*SELECT iapage.page_title, iepage.page_title from iawiktionary_p.page as iapage join iewiktionary_p.page as iepage on iepage.page_namespace=0 join (SELECT SOUNDEX(page_title) as soundex, page_title from iawiktionary_p.page WHERE iawiktionary_p.page.page_namespace=0) AS iasoundex ON iapage.page_title=iasoundex.page_title join (SELECT SOUNDEX(page_title) as soundex, page_title from iewiktionary_p.page WHERE iewiktionary_p.page.page_namespace=0) as iesoundex ON iepage.page_title=iesoundex.page_title where iapage.page_namespace=0 and iepage.page_namespace=0 and iasoundex.soundex=iesoundex.soundex limit 10*/
/*SELECT page_title as iapage_title, soundex(page_title) as iasoundex 
from iawiki_p.page
/*JOIN (
  SELECT page_title as iepage_title, soundex(page_title) as iesoundex 
  from iewiktionary_p.page WHERE page_namespace=0) as iepage
  ON iawiktionary_p.page.iasoundex=iepage.iesoundex AND iesoundex is not null
 */
/* WHERE page_namespace=0 AND soundex(page_title) not like '';*/
 
SELECT ia.page_title, ie.page_title FROM iawiki_p.page AS ia
JOIN iewiki_p.page as ie ON ia.page_id NOT IN (SELECT DISTINCT ll_from FROM iawiki_p.langlinks WHERE ll_lang='ie') 
WHERE 
ia.page_namespace=0
AND ie.page_title="Lindsey_Vonn"
GROUP BY ia.page_title
LIMIT 5;.
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...