SELECT ur.updater_records_id
  FROM updater_records ur, updater_records ur2
 WHERE ur.created = (SELECT max(ur3.created)
                       FROM updater_records ur3
                      WHERE ur3.sku = ur.sku AND
                            ur3.sku2 = ur.sku2 AND
                            ur3.store_number = ur.store_number AND
                            ur3.status IS NOT NULL) AND
       ur2.created = (SELECT max(ur4.created)
                        FROM updater_records ur4
                       WHERE ur4.sku = ur.sku AND
                             ur4.sku2 = ur.sku2 AND
                             ur4.store_number = ur.store_number AND
                             ur4.created < ur.created AND
                             ur4.status IS NOT NULL) AND
       ur2.sku = ur.sku AND
       ur2.sku2 = ur.sku2 AND
       ur2.store_number = ur.store_number AND
       ur.status = 'instock' AND
       ur2.status = 'outofstock'