0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT  
           u.DisplayName AS Jméno_uživatele, 
           p.CreationDate AS Datum_vytvoření
FROM Users u
INNER JOIN Posts p ON u.id = p.OwnerUserID
ORDER BY u.DisplayName ASC, p.CreationDate DESC;

fork query

edited may 27

created may 27 anonymous