SELECT R1.sendDate, R1.openedDate, O0.sLabel AS campaignName FROM (
                           SELECT S1.iDeliveryId AS delivery1, S2.iDeliveryId, S1.IOPERATIONID, S1.tsLastModified AS sendDate, S2.tsLog AS openedDate
                             FROM (
                                        SELECT B0.iDeliveryId, D2.IOPERATIONID, B0.tsLastModified
                                        FROM campaign.NmsBroadLogRcp B0 JOIN campaign.NmsBroadLogMsg B1 ON (B1.iBroadLogMsgId = B0.iMsgId) JOIN campaign.NmsDelivery D2 ON (D2.iDeliveryId = B0.iDeliveryId)
                                        WHERE (B1.sText IS NOT NULL) ORDER BY B0.tsLastModified DESC, B0.iBroadLogId
                                  ) S1
                                  LEFT JOIN (
                                  SELECT T0.iDeliveryId , T0.tsLog
                                       FROM campaign.NmsTrackingLogRcp T0 JOIN campaign.NmsTrackingUrl T1 ON (T1.iTrackingUrlId = T0.iUrlId) JOIN campaign.NmsDelivery D2 ON (D2.iDeliveryId = T0.iDeliveryId)
                                       WHERE T1.sLabel='Open'  ORDER BY T0.tsLog DESC, T0.iTrackingLogId
                                  ) S2
                                  ON S1.iDeliveryId = S2.iDeliveryId)
                         R1 JOIN  campaign.NMSOPERATION O0 ON O0.IOPERATIONID=R1.IOPERATIONID