Untitled query #56170

SQL

select actor.*, user.*#,
       #user_gender.up_value as gender,
       #user_disablemail.up_value as disablemail,
       #user_fancysig.up_value as fancysig
from actor, user#,
     #user_properties as user_gender,
     #user_properties as user_disablemail,
     #user_properties as user_fancysig
where 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'
SQL

Checking query status...
