Untitled query #53521

SQL

SELECT * FROM logging
INNER JOIN (
	SELECT REPLACE(pl_title, "_", " ") AS pl_title, pl_title AS pl_title_underscore FROM pagelinks
	WHERE (pl_namespace = 2 AND pl_from = 262091)
) AS pl1 ON (logging.log_params LIKE "%\"" || pl1.pl_title || "\"%")
WHERE log_type = "gblrename";
SELECT * FROM logging
INNER JOIN (
	SELECT REPLACE(pl_title, "_", " ") AS pl_title, pl_title AS pl_title_underscore FROM pagelinks
	WHERE (pl_namespace = 2 AND pl_from = 262091)
) AS pl2 ON (logging.log_title = pl2.pl_title)
WHERE log_type = "renameuser";
SELECT * FROM logging
INNER JOIN (
	SELECT REPLACE(pl_title, "_", " ") AS pl_title, pl_title AS pl_title_underscore FROM pagelinks
	WHERE (pl_namespace = 2 AND pl_from = 262091)
) AS pl3 ON (logging.log_title = pl3.pl_title_underscore)
WHERE log_type = "renameuser"
SQL

Checking query status...
