Check Post Id and Date covariance

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

Select low.Id as [Post Link],
       low.Id as LowId,
       low.CreationDate as LowDate,
       hi.Id as [High Link],
       hi.CreationDate as HighDate
from posts low, posts hi
where low.Id > hi.Id
  and low.CreationDate < hi.CreationDate
  and low.CreationDate > '1 jan 2012'
  and hi.CreationDate > '1 jan 2012'

Enter Parameters

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