Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. SELECT `List`.`id`,
  2. `List`.`title`,
  3. `List`.`createdAt`,
  4. `List`.`updatedAt`,
  5. `List`.`FK_UserOwner_Id`,
  6. `Users`.`id` AS `Users.id`,
  7. `Users`.`lastName` AS `Users.lastName`,
  8. `Users`.`firstName` AS `Users.firstName`,
  9. `Users`.`userName` AS `Users.userName`,
  10. `Users`.`email` AS `Users.email`,
  11. `Users->EditorsLists`.`FK_EditorsLists_Lists_Id` AS `Users.EditorsLists.FK_EditorsLists_Lists_Id`,
  12. `Users->EditorsLists`.`FK_EditorsLists_Users_Id` AS `Users.EditorsLists.FK_EditorsLists_Users_Id` FROM `Lists` AS `List` INNER JOIN ( `EditorsLists` AS `Users->EditorsLists` INNER JOIN `Users` AS `Users` ON `Users`.`id` = `Users->EditorsLists`.`FK_EditorsLists_Users_Id` AND `Users->EditorsLists`.`FK_EditorsLists_Users_Id` = 2) ON `List`.`id` = `Users->EditorsLists`.`FK_EditorsLists_Lists_Id`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement