Occurrence of console methods in answers - 2014 onward

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT  SUM(IIF(Body LIKE '%console.log[( ]%', 1, 0)) AS [console.log],
        SUM(IIF(Body LIKE '%console.info[( ]%', 1, 0)) AS [console.info],
        SUM(IIF(Body LIKE '%console.error[( ]%', 1, 0)) AS [console.error],
        SUM(IIF(Body LIKE '%console.warn[( ]%', 1, 0)) AS [console.warn],
        SUM(IIF(Body LIKE '%console.clear[( ]%', 1, 0)) AS [console.clear],
        SUM(IIF(Body LIKE '%console.time[( ]%', 1, 0)) AS [console.time],
        SUM(IIF(Body LIKE '%console.timeEnd[( ]%', 1, 0)) AS [console.timeEnd],
        SUM(IIF(Body LIKE '%console.assert[( ]%', 1, 0)) AS [console.assert],
        SUM(IIF(Body LIKE '%console.count[( ]%', 1, 0)) AS [console.count],
        SUM(IIF(Body LIKE '%console.dir[( ]%', 1, 0)) AS [console.dir],
        SUM(IIF(Body LIKE '%console.dirxml[( ]%', 1, 0)) AS [console.dirxml]
FROM    Posts
WHERE   PostTypeId = 2
        AND CreationDate >= '2014-01-01'
        AND ParentId IN (
            SELECT    PostId
            FROM      PostTags
            WHERE     TagId IN (3, 820) -- javascript, jquery
        )
        AND Body LIKE '%console%';

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results