INSERT INTO rep_kw_osrcevents2 (sessid, eventdate, reventdataid, mdata2, sdata2, rdata2) SELECT distinct base.sessid AS sessid, base.eventdate AS eventdate, MAX(rev.eventdataid) AS reventdataid, MAX(mev.data2) AS mdata2, MAX(sev.data2) AS sdata2, MAX(rev.data2) AS rdata2 FROM temp_kw_ofirstevents AS base LEFT JOIN rep_kw_oreferevents AS rev force index (sessid) ON base.sessid=rev.sessid AND ABS(base.eventdate-rev.eventdate)<4 LEFT JOIN rep_kw_omarketingevents AS mev ON base.sessid=mev.sessid AND ABS(base.eventdate-mev.eventdate)<4 LEFT JOIN rep_kw_osubmcevents AS sev ON base.sessid=sev.sessid AND ABS(base.eventdate-sev.eventdate)<4 GROUP BY sessid,eventdate ORDER BY sessid,eventdate;