all coach data:
by Mattaaronperper@ · 21 things on Twos
- select
- u.id as "user_id" ,
- u.email as "email",
- u.source as "source",
- p."name" as "name",
- p."cellphone" as "phone",
- u."createdAt" as "created",
- s."name" as "sport",
- p."hometown" as "location",
- rs."name" as "ReferralSource",
- "u".id, "u".username, "u".password, "u".email, "u".token, "u".source, "u"."userType", "u"."createdAt"as "User Created At", "u"."updatedAt"as "User Updated At", "u".guest, "u".admin, "u"."termsOfService", "u"."privacyPolicy", "u"."sSocialId", "u"."sSocialType",
- "p".id, "p".name, "p"."userType", "p"."sportId", "p"."universityId", "p".city, "p".state, "p".zip, "p"."primaryPositionId", "p"."secondaryPositionId", "p".skill, "p"."createdAt"as "Profile Created At", "p"."updatedAt"as "Profile Updated At", "p"."userId", "p".rating, "p"."skill1Id", "p"."skill2Id", "p"."skill3Id", "p"."skill4Id", "p".height, "p".weight, "p".hometown, "p".bio, "p".cellphone, "p"."bannerImage", "p"."profileImage", "p".class, "p".gender, "p".verified, "p".hidden, "p".premium, "p"."isPhoneVerified", "p".inflcr, "p"."referralSourceId"
- from users u
- LEFT OUTER JOIN profiles as p
- on u.id = p."userId"
- LEFT OUTER JOIN sports as s
- on p."sportId" = s.id
- LEFT OUTER JOIN referral_sources as rs
- on p."referralSourceId" = rs.id
- WHERE "p"."userType" = '1'
- ORDER BY u."createdAt" desc