Self Join Outer JOIN not working as expected

Hi,

I am trying to do Outer Join on the same table. However I am not getting the result that is expected.

I have the following dataset:

I am trying to do a SELF JOIN OUTER join to get the date range for which the Item is Out of Stock or In Stock.

Ideally this is the desired O/P:

This is my code to achieve the desired o/p above:

SELECT a.`Item`,
a.`Country`,
a.`Event Order`,
a.`Event` as 'Status',
a.`Event Date` as 'Start Date',
b.`Event Date` as 'End Date'

FROM `input_table` a 
LEFT JOIN `input_table` b

ON b.`Event Order` = a.`Event Order` + 1 and a.`Item` = b.`Item` and a.`Country` = b.`Country` 

However, this is the o/p i am getting:

Since this is a LEFT OUTER join, it should fetch all rows from the LEFT TABLE even if it does not find matching rows in the RIGHT TABLE. In this example, Event Order = 3 exists in the LEFT TABLE but Event Order = 4 does not exist in the RIGHT TABLE.

 Are my conditions in the joins right? Am I missing out on anything?

Thanks in advance.