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=241362 and pl.pl_namespace=0)
AND wdpl.pl_from IS NULL
SQL

Checking query status...
