RAW question list

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

select
  Posts.Id as [Post Link],
  Posts.Id,
  Posts.Title,
  Posts.Score,
  Posts.Tags,
  Posts.CreationDate,
  Posts.ViewCount,
  Posts.OwnerUserId,
  PostUsers.DisplayName as OwnerAccountDisplayName,
  PostUsers.Reputation as OwnerAccountReputation,
  Posts.OwnerDisplayName as OwnerAnonymousDisplayName,
  Posts.LastEditorUserId,
  EditUsers.DisplayName as LastEditorAccountDisplayName,
  EditUsers.Reputation as LastEditorAccountReputation,
  Posts.LastEditorDisplayName as LastEditorAnonymousDisplayName,
  Posts.LastEditDate,
  Posts.LastActivityDate,
  Posts.AnswerCount,
  Posts.CommentCount,
  Posts.FavoriteCount,
  Posts.ClosedDate
from Posts
left join Users as PostUsers on (Posts.OwnerUserId = PostUsers.Id)
left join Users as EditUsers on (Posts.LastEditorUserId = EditUsers.Id)
where PostTypeId = 1
and Tags like '%rules-as-written%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results