title: SQL Date_Sub syntax error
body: <p>I have been looking at this statement for ages and simply cannot find the error can you guys help?</p>
  
  <pre><code>        SELECT XD.*, UhED.row_class,
              (SELECT id
                  FROM Comment C
                  WHERE C.Excel_Data_Excel_Lists_id = XD.Excel_Lists_id
                      AND C.Excel_Data_row = XD.row
                  LIMIT 1
              ) AS has_activity
          FROM User_has_Excel_Lists UhXL
          JOIN Excel_Lists XL
              ON XL.id = UhXL.Excel_Lists_id
          JOIN Excel_Data XD
              ON XD.Excel_Lists_id = XL.id
          LEFT JOIN User_has_Excel_Data UhED
              ON UhED.Excel_Data_Excel_Lists_id = XL.id
                  AND UhED.Excel_Data_row = XD.row
                  AND UhED.User_id = 1
          WHERE UhXL.User_id = 1
              AND XL.created &gt; DATE_SUB(DATE(now()), INTERVAL 2)&lt;-- it says that the error is here
          GROUP BY XD.telephone 
          ORDER BY last_name ASC, first_name ASC
  </code></pre>