Ver originalSELECT DISTINCT usrID, Date FROM connectionhistory WHERE usrID not in (select usrID from connectionhistory where DATE(Date) < DATE('2013-04-21 23:31:23')) AND DATE(Date) >= DATE('2013-04-21 23:31:23') AND DATE(Date) <= DATE('2013-05-29 12:26:50')group by usrID ORDER BY `Date` ASC ;