dump.sql

SELECT
    `user`.`id`,
    `user`.`firstName`,
    `user`.`lastName`,
    `user`.`phoneNumber`,
    `user`.`phoneNumberVerified`,
    `user`.`email`,
    `user`.`emailVerified`,
    `user`.`inviteCode`,
    `user`.`inviteCodeUsed`,
    `user`.`createdAt`,
    `user`.`updatedAt`,
    `schedule`.`id` AS `schedule.id`,
    `schedule`.`userId` AS `schedule.userId`,
    `schedule`.`createdAt` AS `schedule.createdAt`,
    `schedule`.`updatedAt` AS `schedule.updatedAt`,
    `schedule->Monday`.`id` AS `schedule.Monday.id`,
    `schedule->Monday`.`scheduleId` AS `schedule.Monday.scheduleId`,
    `schedule->Monday`.`startHour` AS `schedule.Monday.startHour`,
    `schedule->Monday`.`endHour` AS `schedule.Monday.endHour`,
    `schedule->Monday`.`isAvailable` AS `schedule.Monday.isAvailable`,
    `schedule->Monday`.`createdAt` AS `schedule.Monday.createdAt`,
    `schedule->Monday`.`updatedAt` AS `schedule.Monday.updatedAt`,
    `schedule->Tuesday`.`id` AS `schedule.Tuesday.id`,
    `schedule->Tuesday`.`scheduleId` AS `schedule.Tuesday.scheduleId`,
    `schedule->Tuesday`.`startHour` AS `schedule.Tuesday.startHour`,
    `schedule->Tuesday`.`endHour` AS `schedule.Tuesday.endHour`,
    `schedule->Tuesday`.`isAvailable` AS `schedule.Tuesday.isAvailable`,
    `schedule->Tuesday`.`createdAt` AS `schedule.Tuesday.createdAt`,
    `schedule->Tuesday`.`updatedAt` AS `schedule.Tuesday.updatedAt`,
    `schedule->Wednesday`.`id` AS `schedule.Wednesday.id`,
    `schedule->Wednesday`.`scheduleId` AS `schedule.Wednesday.scheduleId`,
    `schedule->Wednesday`.`startHour` AS `schedule.Wednesday.startHour`,
    `schedule->Wednesday`.`endHour` AS `schedule.Wednesday.endHour`,
    `schedule->Wednesday`.`isAvailable` AS `schedule.Wednesday.isAvailable`,
    `schedule->Wednesday`.`createdAt` AS `schedule.Wednesday.createdAt`,
    `schedule->Wednesday`.`updatedAt` AS `schedule.Wednesday.updatedAt`,
    `schedule->Thursday`.`id` AS `schedule.Thursday.id`,
    `schedule->Thursday`.`scheduleId` AS `schedule.Thursday.scheduleId`,
    `schedule->Thursday`.`startHour` AS `schedule.Thursday.startHour`,
    `schedule->Thursday`.`endHour` AS `schedule.Thursday.endHour`,
    `schedule->Thursday`.`isAvailable` AS `schedule.Thursday.isAvailable`,
    `schedule->Thursday`.`createdAt` AS `schedule.Thursday.createdAt`,
    `schedule->Thursday`.`updatedAt` AS `schedule.Thursday.updatedAt`,
    `schedule->Friday`.`id` AS `schedule.Friday.id`,
    `schedule->Friday`.`scheduleId` AS `schedule.Friday.scheduleId`,
    `schedule->Friday`.`startHour` AS `schedule.Friday.startHour`,
    `schedule->Friday`.`endHour` AS `schedule.Friday.endHour`,
    `schedule->Friday`.`isAvailable` AS `schedule.Friday.isAvailable`,
    `schedule->Friday`.`createdAt` AS `schedule.Friday.createdAt`,
    `schedule->Friday`.`updatedAt` AS `schedule.Friday.updatedAt`,
    `schedule->Saturday`.`id` AS `schedule.Saturday.id`,
    `schedule->Saturday`.`scheduleId` AS `schedule.Saturday.scheduleId`,
    `schedule->Saturday`.`startHour` AS `schedule.Saturday.startHour`,
    `schedule->Saturday`.`endHour` AS `schedule.Saturday.endHour`,
    `schedule->Saturday`.`isAvailable` AS `schedule.Saturday.isAvailable`,
    `schedule->Saturday`.`createdAt` AS `schedule.Saturday.createdAt`,
    `schedule->Saturday`.`updatedAt` AS `schedule.Saturday.updatedAt`,
    `schedule->Sunday`.`id` AS `schedule.Sunday.id`,
    `schedule->Sunday`.`scheduleId` AS `schedule.Sunday.scheduleId`,
    `schedule->Sunday`.`startHour` AS `schedule.Sunday.startHour`,
    `schedule->Sunday`.`endHour` AS `schedule.Sunday.endHour`,
    `schedule->Sunday`.`isAvailable` AS `schedule.Sunday.isAvailable`,
    `schedule->Sunday`.`createdAt` AS `schedule.Sunday.createdAt`,
    `schedule->Sunday`.`updatedAt` AS `schedule.Sunday.updatedAt`
FROM
    `users` AS `user`
    LEFT OUTER JOIN `schedules` AS `schedule` ON `user`.`id` = `schedule`.`userId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Monday` ON `schedule`.`id` = `schedule->Monday`.`scheduleId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Tuesday` ON `schedule`.`id` = `schedule->Tuesday`.`scheduleId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Wednesday` ON `schedule`.`id` = `schedule->Wednesday`.`scheduleId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Thursday` ON `schedule`.`id` = `schedule->Thursday`.`scheduleId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Friday` ON `schedule`.`id` = `schedule->Friday`.`scheduleId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Saturday` ON `schedule`.`id` = `schedule->Saturday`.`scheduleId`
    LEFT OUTER JOIN `day_availabilities` AS `schedule->Sunday` ON `schedule`.`id` = `schedule->Sunday`.`scheduleId`
WHERE
    `user`.`id` = 'ca46fc11-5342-4e99-a18c-fd37d4b04a52';