SELECT P.*, C.Id AS CommentId, C.PostId AS CommentPostId,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT 
P.*,
  C.Id AS CommentId,
  C.PostId AS CommentPostId,
  C.Score AS CommentScore,
  C.Text AS CommentText,
  C.CreationDate AS CommentCreationDate,
  C.UserDisplayName AS CommentUserDisplayName,
  C.UserId AS CommentUserId,
  C.ContentLicense AS CommentContentLicense,
  V.Id AS VoteId,
  V.VoteTypeId AS VoteTypeId,
  V.UserId AS VoteUserId,
  V.CreationDate AS VoteCreationDate,
  V.BountyAmount AS VoteBountyAmount
FROM
  Posts P
LEFT JOIN
  Comments C ON C.PostId = P.Id
LEFT JOIN
  Votes V ON V.PostId = P.Id
WHERE
  (
    P.Tags LIKE '%<ethicsin-ai>%'
  )
ORDER BY
  P.CreationDate DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results