select a.Id, a.CreationDate, a.AccountId, b.DeactivationD...

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 a.Id,
a.CreationDate,
a.AccountId,
b.DeactivationDate,
datediff(month,a.CreationDate,'2021-12-06') as MthsSinceCreation
from users a left join CloseAsOffTopicReasonTypes b
on a.Id=b.Id
group by a.Id,a.CreationDate,a.AccountId,b.DeactivationDate
order by a.Id;

Enter Parameters

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