LOCK TABLES CGLOBAL AS g WRITE, CDATA AS d WRITE; delete g, d from CGLOBAL g, CDATA d where g.cfid=d.cfid and DATE_ADD(g.lvisit, INTERVAL 45 MINUTE) < now(); UNLOCK TABLES;