MathJax in titles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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

SELECT
  *
FROM
  Posts
WHERE

  -- First interval. The limit date is 2019-06-23
  --CreationDate > '2019-03-31'
  --AND CreationDate < '2019-06-24'
  
  -- Second interval
  --CreationDate > '2019-01-31'
  --AND CreationDate < '2019-04-01'
  
  -- Third interval
  CreationDate > '2018-11-30'
  AND CreationDate < '2019-02-01'
  
  
  -- Questions only:
  -- AND (ParentID IS NULL)
  AND (
    LOWER(Title) LIKE LOWER('%[ -$§_§[({]##words##[ -$§_§])}]%') ESCAPE '§'
    OR
    LOWER(Title) LIKE LOWER('%[ -$§_§[({]##words##') ESCAPE '§'
    OR
    LOWER(Title) LIKE LOWER('##words##[ -$_$])}]%') ESCAPE '§'
    
    OR
    LOWER(Body) LIKE LOWER('%[ -$§_§[({]##words##[ -$§_§])}]%') ESCAPE '§'
    OR
    LOWER(Body) LIKE LOWER('%[ -$§_§[({]##words##') ESCAPE '§'
    OR
    LOWER(Body) LIKE LOWER('##words##[ -$§_§])}]%') ESCAPE '§'
  )
ORDER BY
  CreationDate

Enter Parameters

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