First edit dates of people with rotate() in their signatures

SQL

SELECT
	user_name,
    up_value,
	(
      SELECT MIN(rev_timestamp) FROM revision_userindex
      JOIN actor ON actor_id = rev_actor WHERE actor_user = user_id
    ) AS first_edit_date
FROM user_properties
JOIN `user` ON user_id = up_user
AND up_property = 'nickname'
AND up_user IN (
  SELECT up_user
  FROM user_properties
  WHERE up_property = "fancysig" AND up_value = 1
)
AND up_value LIKE '%rotate(%'
ORDER BY first_edit_date ASC

AخA
 
SELECT    user_name,    up_value,    (      SELECT MIN(rev_timestamp) FROM revision_userindex      JOIN actor ON actor_id = rev_actor WHERE actor_user = user_id    ) AS first_edit_dateFROM user_propertiesJOIN `user` ON user_id = up_userAND up_property = 'nickname'AND up_user IN (  SELECT up_user  FROM user_properties  WHERE up_property = "fancysig" AND up_value = 1)AND up_value LIKE '%rotate(%'ORDER BY first_edit_date ASC

SQL

Checking query status...