XMDS: Player has empty scheduled event when a scheduled layout has a draft

[dasgarner]

The error is harmless and doesn't impact playback, but the query responsible for returning currently scheduled events could be improved to avoid considering the draft.

In the query we join on layouts via their campaign, and exclude drafts (parentId is null):

         LEFT OUTER JOIN `campaign`
                         ON `schedule`.CampaignID = campaign.CampaignID
         LEFT OUTER JOIN `lkcampaignlayout`
                         ON lkcampaignlayout.CampaignID = campaign.CampaignID
         LEFT OUTER JOIN `layout`
                         ON lkcampaignlayout.LayoutID = layout.LayoutID
                             AND layout.retired = 0
                             AND layout.parentId IS NULL

However, because this is an OUTER join, we do still get the lkcampaignlayout record, including the link to the draft.