Advertisement
Guest User

Untitled

a guest
Jan 4th, 2021
23
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.81 KB | None | 0 0
  1. [SQL: SELECT `Channel`.id AS `Channel_id`, `Channel`.`owningUser` AS `Channel_owningUser`, `Channel`.`streamKey` AS `Channel_streamKey`, `Channel`.`channelName` AS `Channel_channelName`, `Channel`.`channelLoc
  2. ` AS `Channel_channelLoc`, `Channel`.topic AS `Channel_topic`, `Channel`.views AS `Channel_views`, `Channel`.`currentViewers` AS `Channel_currentViewers`, `Channel`.record AS `Channel_record`, `Channel`.`chat
  3. Enabled` AS `Channel_chatEnabled`, `Channel`.`chatBG` AS `Channel_chatBG`, `Channel`.`chatTextColor` AS `Channel_chatTextColor`, `Channel`.`chatAnimation` AS `Channel_chatAnimation`, `Channel`.`imageLocation`
  4. AS `Channel_imageLocation`, `Channel`.`offlineImageLocation` AS `Channel_offlineImageLocation`, `Channel`.description AS `Channel_description`, `Channel`.`allowComments` AS `Channel_allowComments`, `Channel`
  5. .protected AS `Channel_protected`, `Channel`.`channelMuted` AS `Channel_channelMuted`, `Channel`.`showChatJoinLeaveNotification` AS `Channel_showChatJoinLeaveNotification`, `Channel`.`defaultStreamName` AS `C
  6. hannel_defaultStreamName`, `Channel`.`autoPublish` AS `Channel_autoPublish`, `Channel`.`rtmpRestream` AS `Channel_rtmpRestream`, `Channel`.`rtmpRestreamDestination` AS `Channel_rtmpRestreamDestination`, `Chan
  7. nel`.`xmppToken` AS `Channel_xmppToken`, `Channel`.`vanityURL` AS `Channel_vanityURL`, stream_upvotes_1.id AS stream_upvotes_1_id, stream_upvotes_1.`userID` AS `stream_upvotes_1_userID`, stream_upvotes_1.`str
  8. eamID` AS `stream_upvotes_1_streamID`, `Stream_1`.id AS `Stream_1_id`, `Stream_1`.uuid AS `Stream_1_uuid`, `Stream_1`.`startTimestamp` AS `Stream_1_startTimestamp`, `Stream_1`.`linkedChannel` AS `Stream_1_lin
  9. kedChannel`, `Stream_1`.`streamKey` AS `Stream_1_streamKey`, `Stream_1`.`streamName` AS `Stream_1_streamName`, `Stream_1`.topic AS `Stream_1_topic`, `Stream_1`.`currentViewers` AS `Stream_1_currentViewers`, `
  10. Stream_1`.`totalViewers` AS `Stream_1_totalViewers`, video_upvotes_1.id AS video_upvotes_1_id, video_upvotes_1.`userID` AS `video_upvotes_1_userID`, video_upvotes_1.`videoID` AS `video_upvotes_1_videoID`, com
  11. ment_upvotes_1.id AS comment_upvotes_1_id, comment_upvotes_1.`userID` AS `comment_upvotes_1_userID`, comment_upvotes_1.`commentID` AS `comment_upvotes_1_commentID`, `videoComments_1`.id AS `videoComments_1_id
  12. `, `videoComments_1`.`userID` AS `videoComments_1_userID`, `videoComments_1`.timestamp AS `videoComments_1_timestamp`, `videoComments_1`.comment AS `videoComments_1_comment`, `videoComments_1`.`videoID` AS `v
  13. ideoComments_1_videoID`, clip_upvotes_1.id AS clip_upvotes_1_id, clip_upvotes_1.`userID` AS `clip_upvotes_1_userID`, clip_upvotes_1.`clipID` AS `clip_upvotes_1_clipID`, `Clips_1`.id AS `Clips_1_id`, `Clips_1`
  14. .uuid AS `Clips_1_uuid`, `Clips_1`.`parentVideo` AS `Clips_1_parentVideo`, `Clips_1`.`startTime` AS `Clips_1_startTime`, `Clips_1`.`endTime` AS `Clips_1_endTime`, `Clips_1`.length AS `Clips_1_length`, `Clips_
  15. 1`.views AS `Clips_1_views`, `Clips_1`.`clipName` AS `Clips_1_clipName`, `Clips_1`.`videoLocation` AS `Clips_1_videoLocation`, `Clips_1`.description AS `Clips_1_description`, `Clips_1`.`thumbnailLocation` AS
  16. `Clips_1_thumbnailLocation`, `Clips_1`.`gifLocation` AS `Clips_1_gifLocation`, `Clips_1`.published AS `Clips_1_published`, `RecordedVideo_1`.id AS `RecordedVideo_1_id`, `RecordedVideo_1`.uuid AS `RecordedVide
  17. o_1_uuid`, `RecordedVideo_1`.`videoDate` AS `RecordedVideo_1_videoDate`, `RecordedVideo_1`.`owningUser` AS `RecordedVideo_1_owningUser`, `RecordedVideo_1`.`channelName` AS `RecordedVideo_1_channelName`, `Reco
  18. rdedVideo_1`.`channelID` AS `RecordedVideo_1_channelID`, `RecordedVideo_1`.description AS `RecordedVideo_1_description`, `RecordedVideo_1`.topic AS `RecordedVideo_1_topic`, `RecordedVideo_1`.views AS `Recorde
  19. dVideo_1_views`, `RecordedVideo_1`.length AS `RecordedVideo_1_length`, `RecordedVideo_1`.`videoLocation` AS `RecordedVideo_1_videoLocation`, `RecordedVideo_1`.`thumbnailLocation` AS `RecordedVideo_1_thumbnail
  20. Location`, `RecordedVideo_1`.`gifLocation` AS `RecordedVideo_1_gifLocation`, `RecordedVideo_1`.pending AS `RecordedVideo_1_pending`, `RecordedVideo_1`.`allowComments` AS `RecordedVideo_1_allowComments`, `Reco
  21. rdedVideo_1`.published AS `RecordedVideo_1_published`, `RecordedVideo_1`.`originalStreamID` AS `RecordedVideo_1_originalStreamID`, channel_upvotes_1.id AS channel_upvotes_1_id, channel_upvotes_1.`userID` AS `
  22. channel_upvotes_1_userID`, channel_upvotes_1.`channelID` AS `channel_upvotes_1_channelID`, `invitedViewer_1`.id AS `invitedViewer_1_id`, `invitedViewer_1`.`userID` AS `invitedViewer_1_userID`, `invitedViewer_
  23. 1`.`channelID` AS `invitedViewer_1_channelID`, `invitedViewer_1`.`addedDate` AS `invitedViewer_1_addedDate`, `invitedViewer_1`.expiration AS `invitedViewer_1_expiration`, `invitedViewer_1`.`inviteCode` AS `in
  24. vitedViewer_1_inviteCode`, `inviteCode_1`.id AS `inviteCode_1_id`, `inviteCode_1`.code AS `inviteCode_1_code`, `inviteCode_1`.expiration AS `inviteCode_1_expiration`, `inviteCode_1`.`channelID` AS `inviteCode
  25. _1_channelID`, `inviteCode_1`.uses AS `inviteCode_1_uses`, `invitedViewer_2`.id AS `invitedViewer_2_id`, `invitedViewer_2`.`userID` AS `invitedViewer_2_userID`, `invitedViewer_2`.`channelID` AS `invitedViewer
  26. _2_channelID`, `invitedViewer_2`.`addedDate` AS `invitedViewer_2_addedDate`, `invitedViewer_2`.expiration AS `invitedViewer_2_expiration`, `invitedViewer_2`.`inviteCode` AS `invitedViewer_2_inviteCode`, chann
  27. el_subs_1.id AS channel_subs_1_id, channel_subs_1.`channelID` AS `channel_subs_1_channelID`, channel_subs_1.`userID` AS `channel_subs_1_userID`, webhook_1.id AS webhook_1_id, webhook_1.name AS webhook_1_name,
  28. webhook_1.`channelID` AS `webhook_1_channelID`, webhook_1.`endpointURL` AS `webhook_1_endpointURL`, webhook_1.`requestHeader` AS `webhook_1_requestHeader`, webhook_1.`requestPayload` AS `webhook_1_requestPay
  29. load`, webhook_1.`requestType` AS `webhook_1_requestType`, webhook_1.`requestTrigger` AS `webhook_1_requestTrigger`, `restreamDestinations_1`.id AS `restreamDestinations_1_id`, `restreamDestinations_1`.name A
  30. S `restreamDestinations_1_name`, `restreamDestinations_1`.channel AS `restreamDestinations_1_channel`, `restreamDestinations_1`.enabled AS `restreamDestinations_1_enabled`, `restreamDestinations_1`.url AS `re
  31. streamDestinations_1_url`
  32. FROM `Channel` LEFT OUTER JOIN `Stream` AS `Stream_1` ON `Channel`.id = `Stream_1`.`linkedChannel` LEFT OUTER JOIN stream_upvotes AS stream_upvotes_1 ON `Stream_1`.id = stream_upvotes_1.`streamID` LEFT OUTER
  33. JOIN `RecordedVideo` AS `RecordedVideo_1` ON `Channel`.id = `RecordedVideo_1`.`channelID` LEFT OUTER JOIN video_upvotes AS video_upvotes_1 ON `RecordedVideo_1`.id = video_upvotes_1.`videoID` LEFT OUTER JOIN `
  34. videoComments` AS `videoComments_1` ON `RecordedVideo_1`.id = `videoComments_1`.`videoID` LEFT OUTER JOIN comment_upvotes AS comment_upvotes_1 ON `videoComments_1`.id = comment_upvotes_1.`commentID` LEFT OUTE
  35. R JOIN `Clips` AS `Clips_1` ON `RecordedVideo_1`.id = `Clips_1`.`parentVideo` LEFT OUTER JOIN clip_upvotes AS clip_upvotes_1 ON `Clips_1`.id = clip_upvotes_1.`clipID` LEFT OUTER JOIN channel_upvotes AS channe
  36. l_upvotes_1 ON `Channel`.id = channel_upvotes_1.`channelID` LEFT OUTER JOIN `inviteCode` AS `inviteCode_1` ON `Channel`.id = `inviteCode_1`.`channelID` LEFT OUTER JOIN `invitedViewer` AS `invitedViewer_1` ON
  37. `inviteCode_1`.id = `invitedViewer_1`.`inviteCode` LEFT OUTER JOIN `invitedViewer` AS `invitedViewer_2` ON `Channel`.id = `invitedViewer_2`.`channelID` LEFT OUTER JOIN channel_subs AS channel_subs_1 ON `Chann
  38. el`.id = channel_subs_1.`channelID` LEFT OUTER JOIN webhook AS webhook_1 ON `Channel`.id = webhook_1.`channelID` LEFT OUTER JOIN `restreamDestinations` AS `restreamDestinations_1` ON `Channel`.id = `restreamD
  39. estinations_1`.channel
  40. WHERE `Channel`.`channelLoc` = %(channelLoc_1)s]
  41. [parameters: {'channelLoc_1': '7c140332-c59a-433e-b194-e2dbd3bb58de'}]
  42. (Background on this error at: http://sqlalche.me/e/2j85)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement