Show users aliases

1

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

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

SELECT
  p.OwnerDisplayName as [Posted As],
  u.DisplayName as [Actual Name]
FROM Posts p JOIN Users u on p.OwnerUserId = u.Id
WHERE (p.OwnerDisplayName!=u.DisplayName)
  AND (u.Id=##UserId##)

Enter Parameters

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