0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT
  *
FROM
  Posts
WHERE

  -- First interval. The limit date is 2019-06-23
  CreationDate > '2019-04-30'
  AND CreationDate < '2019-06-24'
  
  
  
   -- Questions only:
  AND (ParentID IS NULL)
  AND (
    LOWER(Title) Like LOWER('% ##words## %')
    OR
    LOWER(Title) Like LOWER('% ##words##')
    OR
    LOWER(Title) Like LOWER('##words## %')
    OR
    LOWER(Title) Like LOWER('% ##words##-%')
    OR
    Lower(Title) Like LOWER('%-##words## %')
    OR
    Lower(Title) Like LOWER('%(##words##)%')
    OR
    Lower(Title) Like LOWER('%[##words##]%')
    OR
    Lower(Title) Like LOWER('%{##words##}%')
    
    
    OR
    LOWER(Body) Like LOWER('% ##words## %')
    OR
    LOWER(Body) Like LOWER('% ##words##')
    OR
    LOWER(Body) Like LOWER('##words## %')
    OR
    LOWER(Body) Like LOWER('% ##words##-%')
    OR
    Lower(Body) Like LOWER('%-##words## %')
    OR
    Lower(Body) Like LOWER('%(##words##)%')
    OR
    Lower(Body) Like LOWER('%[##words##]%')
    OR
    Lower(Body) Like LOWER('%{##words##}%')
  )
ORDER BY
  CreationDate

fork query

edited jul 29 19

created mar 12 19 anonymous