Untitled query #21259

SQL

use ruwikisource_p;
#SELECT page_title, SUBSTRING_INDEX(page_title, '/', 1) AS 'base_title' FROM page WHERE page_namespace = 0 LIMIT 1;
#"Ешь_ананасы,_рябчиков_жуй..."_(Маяковский)
#	(SELECT page_title, SUBSTRING_INDEX(page_title, '/', 1) AS 'base_title' FROM page WHERE page_namespace = 0 LIMIT 1) AS A
#SELECT * FROM page AS A WHERE page_title='"Ешь_ананасы,_рябчиков_жуй..."_(Маяковский)';
SELECT A.page_title,B.page_title FROM
	page AS B JOIN
	(SELECT '"Ешь_ананасы,_рябчиков_жуй..."_(Маяковский)' AS 'page_titl', '"Ешь_ананасы,_рябчиков_жуй..."_(Маяковский)' AS 'base_title') AS A
    ON A.base_title = B.page_title AND B.page_namespace = 0
LIMIT 10;
SQL

Checking query status...
