SELECT `modUser`.`id`, `modUser`.`username`, `modUser`.`password`, `modUser`.`cachepwd`, `modUser`.`class_key`, `modUser`.`active`, `modUser`.`remote_key`, `modUser`.`remote_data`, `modUser`.`hash_class`, `modUser`.`salt`, `modUser`.`primary_group`, `modUser`.`session_stale`, `modUser`.`sudo`, `modUser`.`createdon`, `userData`.`id` AS `userData_id`, `userData`.`userdata_id` AS `userData_userdata_id`, `userData`.`firstName` AS `userData_firstName`, `userData`.`lastName` AS `userData_lastName`, `userData`.`title` AS `userData_title`, `userData`.`company` AS `userData_company`, `userData`.`registrationDate` AS `userData_registrationDate`, `userData`.`category1` AS `userData_category1`, `userData`.`category2` AS `userData_category2`, `userData`.`category3` AS `userData_category3`, `Profile`.`id` AS `Profile_id`, `Profile`.`internalKey` AS `Profile_internalKey`, `Profile`.`fullname` AS `Profile_fullname`, `Profile`.`email` AS `Profile_email`, `Profile`.`phone` AS `Profile_phone`, `Profile`.`mobilephone` AS `Profile_mobilephone`, `Profile`.`blocked` AS `Profile_blocked`, `Profile`.`blockeduntil` AS `Profile_blockeduntil`, `Profile`.`blockedafter` AS `Profile_blockedafter`, `Profile`.`logincount` AS `Profile_logincount`, `Profile`.`lastlogin` AS `Profile_lastlogin`, `Profile`.`thislogin` AS `Profile_thislogin`, `Profile`.`failedlogincount` AS `Profile_failedlogincount`, `Profile`.`sessionid` AS `Profile_sessionid`, `Profile`.`dob` AS `Profile_dob`, `Profile`.`gender` AS `Profile_gender`, `Profile`.`address` AS `Profile_address`, `Profile`.`country` AS `Profile_country`, `Profile`.`city` AS `Profile_city`, `Profile`.`state` AS `Profile_state`, `Profile`.`zip` AS `Profile_zip`, `Profile`.`fax` AS `Profile_fax`, `Profile`.`photo` AS `Profile_photo`, `Profile`.`comment` AS `Profile_comment`, `Profile`.`website` AS `Profile_website`, `Profile`.`extended` AS `Profile_extended` FROM `modx_users` AS `modUser` JOIN `modx_user_data` `userData` ON modUser.id = userData.userdata_id LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` WHERE `userData`.`firstName` = 'Bob' ORDER BY username ASC Array
(
[id] => 3
[username] => testuser
[password] => m16SLY3A33Fdcr4JlO9wDPMNlTDz364eBwfeNzE6NeE=
[cachepwd] =>
[class_key] => modUser
[active] => 1
[remote_key] =>
[remote_data] =>
[hash_class] => hashing.modPBKDF2
[salt] => 92554fb3c7b75d356f4556b43c77526e
[primary_group] => 0
[session_stale] => Array
(
[0] => mgr
[1] => test
[2] => web
)
[sudo] =>
[createdon] => 0
[userData_id] => 1
[userData_userdata_id] => 3
[userData_firstName] => Bob
[userData_lastName] =>
[userData_title] =>
[userData_company] =>
[userData_registrationDate] =>
[userData_category1] =>
[userData_category2] =>
[userData_category3] =>
[Profile_id] => 3
[Profile_internalKey] => 3
[Profile_fullname] => testuser
[Profile_email] => b.perner@gmx.de
[Profile_phone] =>
[Profile_mobilephone] =>
[Profile_blocked] => 0
[Profile_blockeduntil] => 0
[Profile_blockedafter] => 0
[Profile_logincount] => 17
[Profile_lastlogin] => 1383119358
[Profile_thislogin] => 1388267641
[Profile_failedlogincount] => 0
[Profile_sessionid] => 864fa1a01d4aabd35d09afa40f1ade8c
[Profile_dob] => 0
[Profile_gender] => 0
[Profile_address] =>
[Profile_country] =>
[Profile_city] => Marktheidenfeld
[Profile_state] =>
[Profile_zip] =>
[Profile_fax] =>
[Profile_photo] =>
[Profile_comment] =>
[Profile_website] =>
[Profile_extended] => []
)
Array
(
[id] => 3
[username] => testuser
[password] => m16SLY3A33Fdcr4JlO9wDPMNlTDz364eBwfeNzE6NeE=
[cachepwd] =>
[class_key] => modUser
[active] => 1
[remote_key] =>
[remote_data] =>
[hash_class] => hashing.modPBKDF2
[salt] => 92554fb3c7b75d356f4556b43c77526e
[primary_group] => 0
[session_stale] => a:3:{i:0;s:3:"mgr";i:1;s:4:"test";i:2;s:3:"web";}
[sudo] => 0
[createdon] => 0
[userData_id] => 1
[userData_userdata_id] => 3
[userData_firstName] => Bob
[userData_lastName] =>
[userData_title] =>
[userData_company] =>
[userData_registrationDate] =>
[userData_category1] =>
[userData_category2] =>
[userData_category3] =>
[Profile_id] => 3
[Profile_internalKey] => 3
[Profile_fullname] => testuser
[Profile_email] => b.perner@gmx.de
[Profile_phone] =>
[Profile_mobilephone] =>
[Profile_blocked] => 0
[Profile_blockeduntil] => 0
[Profile_blockedafter] => 0
[Profile_logincount] => 17
[Profile_lastlogin] => 1383119358
[Profile_thislogin] => 1388267641
[Profile_failedlogincount] => 0
[Profile_sessionid] => 864fa1a01d4aabd35d09afa40f1ade8c
[Profile_dob] => 0
[Profile_gender] => 0
[Profile_address] =>
[Profile_country] =>
[Profile_city] => Marktheidenfeld
[Profile_state] =>
[Profile_zip] =>
[Profile_fax] =>
[Profile_photo] =>
[Profile_comment] =>
[Profile_website] =>
[Profile_extended] => []
[_alt] => 0
[_first] => 1
[_last] => 1
[_idx] => 1
[idx] => 1
[property.packageName] => extendeduser
[property.classname] => modUser
[property.joins] => [
{"alias":"userData","classname":"userData","on":"modUser.id = userData.userdata_id"},
{"alias":"Profile"}
]
[property.where] => {"userData.firstName":"Bob"}
[_count] => 1
[_total] => 1
)