Untitled query #56168

SQL

select revision.*, comment.*, actor.*, user.*,
       user_gender.up_value as gender,
       user_disablemail.up_value as disablemail,
       user_fancysig.up_value as fancysig
from revision, comment, actor, user,
     user_properties as user_gender,
     user_properties as user_disablemail,
     user_properties as user_fancysig
where rev_comment_id=comment_id and rev_actor=actor_id and actor_user=user_id
      and user_id=user_gender.up_user and user_gender.up_property='gender'
      and user_id=user_disablemail.up_user and user_disablemail.up_property='disablemail'
      and user_id=user_fancysig.up_user and user_fancysig.up_property='fancysig'
limit 10;
SQL

Checking query status...
