Q&A about the site for practitioners of the art and science of signal, image and video processing
select q.Id, q.PostTypeId, q.AcceptedAnswerId, q.CreationDate, q.Score, q.Body, q.Title, q.Tags, a.Id, a.PostTypeId, a.ParentID, a.CreationDate, a.Body from Posts a inner join Posts q on a.Id = q.acceptedAnswerId where q.CreationDate >= '2015-01-01'AND q.Tags LIKE '%test%'