         robot.logger.info err
       else
         if rows.length > 0
-          robot.logger.info rows
+          # robot.logger.info rows
           for r in rows
             terminschichtid=r.TerminSchichtID # 4
             terminname=r.name                 # Afterwork

mysql = require 'mysql'

module.exports = (robot) ->
  vorlauf="12 23:55:00" # 13d + 45min

  url = process.env.MYSQL_URL
  conn = mysql.createConnection(url)

  room = "C8E616MD5" #roomid
  robot.messageRoom room, 'Der Erinnerungsbot ist gestartet worden.'

  letzteterminschichtid=[]



      setInterval () ->
        remind()
        # robot.logger.info "checke DB"
      , 3*60*1000                        # aller 3min

  remind = ->
    conn.query "select b.TerminSchichtID, tt.`name`, b.genauertermin from Termin as t, TerminTyp as tt, (	select TerminSchicht.TerminSchichtID, TerminSchicht.TerminID, ADDTIME(Termin.Datum, Schicht.Beginn) as genauertermin	FROM TerminSchicht	left join Termin on TerminSchicht.TerminID = Termin.TerminID	left join Schicht on TerminSchicht.SchichtID = Schicht.SchichtID	where ADDTIME(Termin.Datum, Schicht.Beginn) >= ADDTIME(        NOW(), '#{vorlauf}')	and   ADDTIME(Termin.Datum, Schicht.Beginn) <  ADDTIME(ADDTIME(NOW(), '#{vorlauf}'), '00:05:00')	order by genauertermin ASC) as b where b.TerminID = t.TerminID and tt.TerminTypID = t.TerminTypID;", (err, rows) ->
