Untitled query #53466

SQL

use commonswiki_p;

SELECT DISTINCT actor_name, img_name, bot FROM (
					(
					  SELECT DISTINCT actor_name, img_name,
						(
						  SELECT 1
						  FROM user_groups
						  WHERE ug_user = user_id
							AND ug_group = 'bot'
						) AS bot
					  FROM
							image
						JOIN actor_image ON actor_id = img_actor
						JOIN user ON user_id = actor_user
					  WHERE
                      img_name like 'First_Men_in_the_Moon%'
					) UNION (
					  SELECT DISTINCT actor_name, oi_name,
						(
						  SELECT 1
						  FROM user_groups
						  WHERE ug_user = user_id
							AND ug_group = 'bot'
						) AS bot
					  FROM
							oldimage
						JOIN actor_oldimage ON actor_id = oi_actor
						JOIN user ON user_id = actor_user
					  WHERE
						oi_name like 'First_Men_in_the_Moon%'
					)
				  ) a;
SQL

Checking query status...
