1

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT *
FROM Comments c
INNER JOIN Users u ON u.Id = c.UserId
WHERE convert(date, u.CreationDate) = convert(date, ##regDate:string##) 
AND convert(date, c.CreationDate) >= convert(date, ##Start:string##)
AND convert(date, c.CreationDate) <= convert(date, ##End:string##)
ORDER BY u.Id, convert(date, c.CreationDate)

fork query

edited jun 24 Alice CHING

created jun 16 anonymous