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.