SELECT
u.id AS `userID`,
u.username,
u.password,
u.passReset,
u.securityQ,
u.securityA,

u.homeOrgLevel,

u.lastLogin,
UNIX_TIMESTAMP(u.lastLogin) AS `lastLoginTimestamp`,
u.lastIP,
u.lastUpdated,
UNIX_TIMESTAMP(u.lastUpdated) AS `lastUpdatedTimestamp`,
u.lastUpdatedBy,

u.namePrefix,
u.nameFirst,
u.nameLast,
u.nameSuffix,
u.nameBadge,

u.email,

u.addressStreet,
u.addressStreet2,
u.addressZip,
u.addressZip4,
u.addressCity,
u.addressStateShort,
u.addressStateLong,
u.addressType,

u.preferedPhone,
phone.number AS preferedPhoneNumber,
phoneLabels.name AS preferedPhoneLabel,

u.preferedIM,
im.sn AS preferedImName,
imProviders.provider AS preferedImProvider,

u.gender,
u.birthDate,
u.medicalNeeds,
u.medicalMobility,
u.medicalContactName,
u.medicalContactRelationship,
u.medicalContactPhone,

u.honorLevel,
u.chapter,
u.chapterPending,
orgChapters.id AS chapterID,
orgChapters.name AS chapterName,
orgChapters.url AS chapterURL,

u.lodge AS lodgeNumber,
u.lodgePending,
orgLodges.lodgeName,
orgLodges.lodgeURL,
orgLodges.lodgeSize,
 
orgLodges.councilName,
orgLodges.councilURL,
orgLodges.councilZip,
 
orgSections.id AS sectionID,
orgSections.name AS sectionName,
orgSections.url AS sectionURL,
 
orgAreas.id AS areaID,
orgAreas.name AS areaName,
orgAreas.url AS areaURL,
 
orgRegions.id AS regionID,
orgRegions.name AS regionName,
orgRegions.url AS regionURL
 
FROM
users AS u

LEFT JOIN im ON u.preferedIM = im.id 
LEFT JOIN imProviders ON im.provider = imProviders.id 
LEFT JOIN phone ON u.preferedPhone = phone.id 
LEFT JOIN phoneLabels ON phone.label = phoneLabels.id
LEFT JOIN orgChapters ON orgChapters.id = u.chapter 
LEFT JOIN orgLodges ON orgLodges.id = u.lodge
LEFT JOIN orgSections ON orgSections.id=orgLodges.section 
LEFT JOIN orgAreas ON orgAreas.id=orgSections.area 
LEFT JOIN orgRegions ON orgRegions.id=orgAreas.region;