Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `List`.`id`,
- `List`.`title`,
- `List`.`createdAt`,
- `List`.`updatedAt`,
- `List`.`FK_UserOwner_Id`,
- `Users`.`id` AS `Users.id`,
- `Users`.`lastName` AS `Users.lastName`,
- `Users`.`firstName` AS `Users.firstName`,
- `Users`.`userName` AS `Users.userName`,
- `Users`.`email` AS `Users.email`,
- `Users->EditorsLists`.`FK_EditorsLists_Lists_Id` AS `Users.EditorsLists.FK_EditorsLists_Lists_Id`,
- `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