SELECT t1.userID, t1.firstName, t1.lastName, concat(t1.firstName, ' ' , t1.lastName) AS fullName, t1.username, t1.email, t1.createdDate, t2.dob, t2.gender, t2.about, t2.biography, t3.name AS rank, t4.name AS service, t5.name AS serviceStatus, t6.friendRequest, t6.newMessage, t6.replyMessage, t6.writeWall, t6.commentPhoto, t6.commentDiscussion, t6.commentStory, t7.activated FROM user AS t1 LEFT JOIN userProfile AS t2 ON (t1.userID = t2.userID) LEFT JOIN dicRank AS t3 ON (t1.rankID = t3.id) LEFT JOIN dicService AS t4 ON (t1.serviceID = t4.id) LEFT JOIN dicServiceStatus AS t5 ON (t1.statusID = t5.id) LEFT JOIN userNotification AS t6 ON (t1.userID = t6.userID) LEFT JOIN userActivation AS t7 ON (t1.userID = t7.userID) WHERE t1.userID = '2564' AND t1.userID IN (SELECT userID FROM userActivation WHERE activated = 'Yes') LIMIT 1
Table 'military_militaryauthority.com.legacy.userProfile' doesn't exist