Questions without a top-level tag (by month of CreationDate)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT 
  eomonth(q.CreationDate) [month],
  COUNT(q.Id) AS countall,
  SUM(case when 
  ((q.PostTypeId = 1)
  AND NOT(q.Tags LIKE '%<ag.algebraic-geometry>%')
  AND NOT(q.Tags LIKE '%<nt.number-theory>%')
  AND NOT(q.Tags LIKE '%<co.combinatorics>%')
  AND NOT(q.Tags LIKE '%<at.algebraic-topology>%')
  AND NOT(q.Tags LIKE '%<gr.group-theory>%')
  AND NOT(q.Tags LIKE '%<dg.differential-geometry>%')
  AND NOT(q.Tags LIKE '%<pr.probability>%')
  AND NOT(q.Tags LIKE '%<rt.representation-theory>%')
  AND NOT(q.Tags LIKE '%<ct.category-theory>%')
  AND NOT(q.Tags LIKE '%<fa.functional-analysis>%')
  AND NOT(q.Tags LIKE '%<ac.commutative-algebra>%')
  AND NOT(q.Tags LIKE '%<lo.logic>%')
  AND NOT(q.Tags LIKE '%<gt.geometric-topology>%')
  AND NOT(q.Tags LIKE '%<ca.classical-analysis-and-odes>%')
  AND NOT(q.Tags LIKE '%<gn.general-topology>%')
  AND NOT(q.Tags LIKE '%<ra.rings-and-algebras>%')
  AND NOT(q.Tags LIKE '%<mg.metric-geometry>%')
  AND NOT(q.Tags LIKE '%<ap.analysis-of-pdes>%')
  AND NOT(q.Tags LIKE '%<mp.mathematical-physics>%')
  AND NOT(q.Tags LIKE '%<st.statistics>%')
  AND NOT(q.Tags LIKE '%<ds.dynamical-systems>%')
  AND NOT(q.Tags LIKE '%<cv.complex-variables>%')
  AND NOT(q.Tags LIKE '%<ho.history-overview>%')
  AND NOT(q.Tags LIKE '%<oa.operator-algebras>%')
  AND NOT(q.Tags LIKE '%<na.numerical-analysis>%')
  AND NOT(q.Tags LIKE '%<sg.symplectic-geometry>%')
  AND NOT(q.Tags LIKE '%<oc.optimization-and-control>%')
  AND NOT(q.Tags LIKE '%<qa.quantum-algebra>%')
  AND NOT(q.Tags LIKE '%<kt.k-theory-and-homology>%')
  AND NOT(q.Tags LIKE '%<sp.spectral-theory>%')
  AND NOT(q.Tags LIKE '%<it.information-theory>%')
  AND NOT(q.Tags LIKE '%<gm.general-mathematics>%'))
  then 1 else 0 end) AS countnotl
FROM Posts q
WHERE (q.PostTypeId=1)
GROUP BY eomonth(q.CreationDate)
ORDER BY eomonth(q.CreationDate)

Enter Parameters

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