Posts that aren't using LaTeX

1

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

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

with Results as (select

  Q.Title,

  case when Q.Body like '%<img%' then
    Concat('https://codegolf.stackexchange.com/q/', Q.Id)
    else null
  end as Question,

  case when A.Body like '%<img%' then
    Concat('https://codegolf.stackexchange.com/q/', A.Id)
    else null
  end as Answer,
  
  case when Q.Body like '%<img%' then
    case when A.Body like '%<img%' then
      'Both' else 'Question' end else 'Answer' end as [Which?],
  
  Q.Tags as Tags,
  
  case when Q.Body like '%<img%' then
    case when Q.LastEditDate is null then Q.CreationDate else Q.LastEditDate end
    else null end
  as [Question Active Date],
  
  case when A.Body like '%<img%' then
    A.LastActivityDate else null
  end as [Answer Active Date],
  
  case when Q.Body like '%<img%' then
    Q.CreationDate
    else A.CreationDate
  end as CreationDate,
  
  case when Q.Body like '%<img%' then
      Q.Id
      else A.Id
  end as Id

from
  Posts A join Posts Q on Q.Id = A.ParentId
  
where
  (A.Body like '%<img%' or Q.Body like '%<img%')
  and (
    Q.Tags like '%<math>%' or
    Q.Tags like '%<abstract-algebra>%' or
    Q.Tags like '%<arithmetic>%' or
    Q.Tags like '%<calculus>%' or
    Q.Tags like '%<combinatorics>%' or
    Q.Tags like '%<cryptography>%' or
    Q.Tags like '%<division>%' or
    Q.Tags like '%<factorial>%' or
    Q.Tags like '%<factoring>%' or
    Q.Tags like '%<fibonacci>%' or
    Q.Tags like '%<floating-point>%' or
    Q.Tags like '%<fractal>%' or
    Q.Tags like '%<geometry>%' or
    Q.Tags like '%<graph-theory>%' or
    Q.Tags like '%<integer>%' or
    Q.Tags like '%<knot-theory>%' or
    Q.Tags like '%<linear-algebra>%' or
    Q.Tags like '%<matrix>%' or
    Q.Tags like '%<number>%' or
    Q.Tags like '%<number-theory>%' or
    Q.Tags like '%<permutations>%' or
    Q.Tags like '%<polynomials>%' or
    Q.Tags like '%<primes>%' or
    Q.Tags like '%<probability-theory>%' or
    Q.Tags like '%<rational-numbers>%' or
    Q.Tags like '%<roman-numerals>%' or
    Q.Tags like '%<set-theory>%' or
    Q.Tags like '%<statistics>%' or
    Q.Tags like '%<topology>%'
  )
)
  
select distinct * from Results
where Id not in (
105,901,985,2957,1931,10741,1938,2497,2509,2528,161496,2543,2544
) order by CreationDate

Enter Parameters

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