0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT
COUNT( distinct Posts.OwnerUserId)--, Posts.PostTypeId,Posts.CreationDate ,
   -- Count(Posts.Id) AS Questiones    
FROM
    Posts
INNER JOIN
    Users ON Users.Id = Posts.OwnerUserId
WHERE
     Posts.PostTypeId = 1 AND Posts.CreationDate <'2022-12-05'
  
--GROUP BY  Users.Id , Posts.PostTypeId,Posts.CreationDate 

--ORDER BY Questiones  DESC

fork query

edited jan 27

created jan 22 anonymous