Show all values in known tables that map a type id to a type name.
Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam
-- Show types
-- Show all values in known tables that map a type id to a type name.
--SELECT year(creationdate),count(*) from posts group by year(creationdate);
select q.id as QID,q.CreationDate,q.tags as QCreationDate
from posts q
join posts a on q.id = a.parentid and a.posttypeid=2
where q.posttypeid= 1
and q.creationdate between '01/01/2020 00:00:00' and '1/3/2020 23:59:59'
order by q.id