Show users aliases


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

  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

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