cleaning stack spanish

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT TOP 16
  p.Id AS [Post Link]
FROM
  Posts AS p
WHERE
  p.PostTypeId = 1
  AND (
  p.Title LIKE '%confuso%'
OR p.Title LIKE '%soy nuevo en'
OR p.Title LIKE '%una pregunta%'
OR p.Title LIKE '%mi problema es%'
OR p.Title LIKE '%por favor%'
OR p.Title LIKE '%ayuda?%'
OR p.Title LIKE '%alguna idea?%'
OR p.Title LIKE '%Quería saber%'
OR p.Title LIKE '%Quiero saber%'
OR p.Title LIKE '%quiero preguntar%'
OR p.Title LIKE '%me pregunto%'
OR p.Title LIKE '%mi duda es%'
OR p.Title LIKE '%no sé cómo%'
  
  )
  AND (
p.Body LIKE '%soy nuevo%'
OR p.Body LIKE '%una pregunta%'
OR p.Body LIKE '%mi problema%'
OR p.Body LIKE '%por favor%'
OR p.Body LIKE '%ayuda?%'
OR p.Body LIKE '%alguna idea?%'
OR p.Body LIKE '%quería saber%'
OR p.Body LIKE '%quiero saber%'
OR p.Body LIKE '%quería preguntar%'
OR p.Body LIKE '%quiero preguntar%'
OR p.Body LIKE '%me pregunto%'
OR p.Body LIKE '%mi duda%'
OR p.Body LIKE '%ni idea%'
)
AND p.CreationDate >= dateadd(day,datediff(day,90,GETDATE()),0)
  AND p.CreationDate < dateadd(day,datediff(day,-1000,GETDATE()),0)
ORDER BY
  p.Id DESC

Enter Parameters

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