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