| 20 | SELECT `User`.`id`, `User`.`group_id`, `User`.`facebook_id`, `User`.`host_address`, `User`.`ghost`, `User`.`username`, `User`.`username_clean`, `User`.`pass`, `User`.`password_salt`, `User`.`password`, `User`.`passchg`, `User`.`email`, `User`.`birthday`, `User`.`avatar`, `User`.`image`, `User`.`is_admin`, `User`.`karma`, `User`.`visits`, `User`.`friends`, `User`.`comments`, `User`.`ratings`, `User`.`restaurant_comments`, `User`.`recipe_comments`, `User`.`user_comments`, `User`.`recipes`, `User`.`recipe_box`, `User`.`last_visit`, `User`.`last_mark`, `User`.`last_page`, `User`.`last_confirm_key`, `User`.`last_search`, `User`.`last_feedback`, `User`.`last_comments`, `User`.`last_recipe_reviews`, `User`.`last_restaurant_reviews`, `User`.`login_attempts`, `User`.`inactive_reason`, `User`.`inactive_time`, `User`.`lang_id`, `User`.`timezone`, `User`.`dateformat`, `User`.`rank_id`, `User`.`actkey`, `User`.`regsite`, `User`.`newpasswd`, `User`.`created`, `User`.`modified`, `User`.`published`, `User`.`status`, `User`.`view`, `User`.`name`, `User`.`lastname`, `User`.`gender`, `User`.`email1`, `User`.`email2`, `User`.`email3`, `User`.`im_aim`, `User`.`im_icq`, `User`.`im_msn`, `User`.`im_yahoo`, `User`.`im_google`, `User`.`im_skype`, `User`.`myspace`, `User`.`facebook`, `User`.`fotolog`, `User`.`msnspace`, `User`.`network`, `User`.`member`, `User`.`translator`, `User`.`newsletter`, `User`.`website`, `User`.`occupation`, `User`.`company`, `User`.`position`, `User`.`address`, `User`.`suburb`, `User`.`location`, `User`.`zip`, `User`.`state`, `User`.`region_id`, `User`.`country_id`, `User`.`phone1`, `User`.`phone2`, `User`.`mobile`, `User`.`fax`, `User`.`dni`, `User`.`lifestyle`, `User`.`political`, `User`.`religion`, `User`.`relationship`, `User`.`meeting_sex`, `User`.`meeting_for`, `User`.`about`, `User`.`interests`, `User`.`music`, `User`.`tv`, `User`.`movies`, `User`.`books`, `User`.`skills`, `User`.`languages`, `User`.`notes`, `UserPref`.`id`, `UserPref`.`user_id`, `UserPref`.`show_address`, `UserPref`.`show_email1`, `UserPref`.`show_email2`, `UserPref`.`show_email3`, `UserPref`.`show_im_aim`, `UserPref`.`show_im_icq`, `UserPref`.`show_im_msn`, `UserPref`.`show_im_yahoo`, `UserPref`.`show_im_google`, `UserPref`.`show_im_skype`, `UserPref`.`show_myspace`, `UserPref`.`show_facebook`, `UserPref`.`show_fotolog`, `UserPref`.`show_msnspace`, `UserPref`.`show_mobile`, `UserPref`.`show_phone1`, `UserPref`.`show_website`, `UserPref`.`show_birthday`, `UserPref`.`user_avatar_type`, `UserPref`.`user_avatar_width`, `UserPref`.`user_avatar_height`, `UserFriend`.`id`, `UserFriend`.`user_id`, `UserFriend`.`friends`, `UserFriend`.`created`, `UserFriend`.`modified`, `Contact`.`id`, `Contact`.`name`, `Contact`.`lastname`, `Contact`.`lastname1`, `Contact`.`lastname2`, `Contact`.`alias`, `Contact`.`username`, `Contact`.`show_as`, `Contact`.`gender`, `Contact`.`email1`, `Contact`.`email2`, `Contact`.`email3`, `Contact`.`web1`, `Contact`.`web2`, `Contact`.`web3`, `Contact`.`myspace`, `Contact`.`facebook`, `Contact`.`fotolog`, `Contact`.`msnspace`, `Contact`.`im_skype`, `Contact`.`im_msn`, `Contact`.`im_yahoo`, `Contact`.`im_google`, `Contact`.`im_aim`, `Contact`.`im_icq`, `Contact`.`birthday`, `Contact`.`company`, `Contact`.`position`, `Contact`.`address`, `Contact`.`suburb`, `Contact`.`location`, `Contact`.`zip`, `Contact`.`region_id`, `Contact`.`country_id`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`mobile`, `Contact`.`fax`, `Contact`.`notes`, `Contact`.`host_address`, `Contact`.`image`, `Contact`.`user_id`, `Contact`.`regsite`, `Contact`.`created`, `Contact`.`modified`, `Contact`.`newsletter`, `Contact`.`view`, `Contact`.`status`, `Member`.`id`, `Member`.`user_id`, `Member`.`name`, `Member`.`lastname`, `Member`.`email`, `Member`.`address`, `Member`.`zip`, `Member`.`location`, `Member`.`region`, `Member`.`region_id`, `Member`.`country_id`, `Member`.`phone`, `Member`.`mobile`, `Member`.`birthday`, `Member`.`occupation`, `Member`.`amount`, `Member`.`payment`, `Member`.`account`, `Member`.`host_address`, `Member`.`created`, `Member`.`modified`, `Member`.`status` FROM `users` AS `User` LEFT JOIN `user_prefs` AS `UserPref` ON (`UserPref`.`user_id` = `User`.`id`) LEFT JOIN `user_friends` AS `UserFriend` ON (`UserFriend`.`user_id` = `User`.`id`) LEFT JOIN `contacts` AS `Contact` ON (`Contact`.`user_id` = `User`.`id`) LEFT JOIN `members` AS `Member` ON (`Member`.`user_id` = `User`.`id`) WHERE ( `User`.`id` = "4031" OR `User`.`username_clean` = "4031" ) AND `User`.`status` = 1 LIMIT 1 | | 1 | 1 | 254 |