If you want to restore canceled order, rollback order cancellation and undo order cancel action in Magento and Magento 2 use the following SQL query...

SELECT `p`.`sku` FROM `catalog_product_entity` AS `p`...

Reindex category products index at first and then execute following sql-script