Untitled query #6828

SQL

/*USE lvwiki_p;
SELECT p1.page_title, p2.page_title#LOCATE (p1.page_title, p2.page_title)#, p1.page_title, p2.page_title
FROM page as p1
join page as p2 on p1.page_namespace = p2.page_namespace
WHERE p1.page_title="Edgars2007/AWB" and p2.page_title="Edgars2007/AWBs" #and #p1.page_title like "p1.page_title"
and
#LOCATE (p2.page_title, p1.page_title)
ISNULL( LOCATE (p1.page_title, p2.page_title)) = 1

#p2.page_title LIKE CONCAT(p1.page_title,"s")

#exists (p2.page_title from page as p2 where p2.page_title=CONCAT(p1.page_title,"s") and )
and p1.page_namespace=2 and p1.page_is_redirect=0
AND p2.page_namespace=2 and p2.page_is_redirect=0


USE lvwiki_p;
SELECT REPLACE(p.page_title, '_', ' '), iw.iwl_title
from  iwlinks iw
join wbc_entity_usage wb on wb.eu_entity_id=iw.iwl_title
join page p on wb.eu_page_id=p.page_id
where iwl_from=58532
group by iw.iwl_title;



use lvwiki_p;
SELECT enp.page_title, pp_value
FROM page enp, page_props, wikidatawiki_p.page wdp
#where el_to like ""
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P2593' AND wdpl.pl_namespace = 120
JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'Q5' AND wdpl2.pl_namespace = 0
WHERE enp.page_namespace = 0
AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'
AND wdp.page_title = pp_value AND wdp.page_namespace = 0
and enp.page_title in (select pl.pl_title from pagelinks pl
						where pl.pl_from=124988 and pl.pl_namespace=0)
AND wdpl.pl_from IS NULL
*/
use lvwiki_p;
SELECT page_id
from page p
where page_namespace=10 and page_title in ("Latvija_1912_VOS",
"Latvija_1924_VOS",
"Latvija_1924_ZOS",
"Latvija_1928_VOS",
"Latvija_1928_ZOS",
"Latvija_1932_VOS",
"Latvija_1936_VOS",
"Latvija_1936_ZOS",
"Latvija_1952_VOS",
"Latvija_1956_VOS",
"Latvija_1960_VOS",
"Latvija_1960_ZOS",
"Latvija_1964_VOS",
"Latvija_1968_VOS",
"Latvija_1968_ZOS",
"Latvija_1972_VOS",
"Latvija_1972_ZOS",
"Latvija_1976_VOS",
"Latvija_1976_ZOS",
"Latvija_1980_VOS",
"Latvija_1980_ZOS",
"Latvija_1984_VOS",
"Latvija_1988_VOS",
"Latvija_1992_VOS",
"Latvija_1996_VOS",
"Latvija_2000_VOS",
"Latvija_2002_ZOS",
"Latvija_2004_VOS",
"Latvija_2006_ZOS",
"Latvija_2008_VOS",
"Latvija_2010_ZOS",
"Latvija_2012_VOS",
"Latvija_2014_ZOS")
SQL

Checking query status...
