How many unanswered EOL questions are there?

0

Please login or register to vote for this query.

(click on this box to dismiss)

This is a rough estimate

Joomla Meta

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

SELECT Id as [Post Link], Score, CreationDate, ViewCount, Tags 
FROM Posts 
WHERE Id NOT IN
(
     SELECT ParentId
     FROM Posts
     WHERE PostTypeId = 2
     AND Score >= 1 AND ClosedDate IS NULL
)
AND (
  Tags LIKE '%10.%' 
  OR Tags Like '%9.%' 
  OR Tags LIKE '%8.%' 
  OR Tags LIKE '%11.04%'
  OR Tags LIKE '%7.%'
  OR Tags LIKE '%6.%'
)
AND ClosedDate IS NULL
AND AcceptedAnswerId IS NULL
ORDER BY ViewCount DESC

Enter Parameters

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