SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='c7e66e12414e4a4dee3850e23a583903' AND cache_id="blockcms|0|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='06ca4441a3e1f3abaf14a3ad6aab9fa0' AND cache_id="blocktags|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2629ca8d3916ddd1e595e8af85877786' AND cache_id="blocktopmenu|1|1|17|index" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1

CREATE TABLE IF NOT EXISTS `ps_revolut_cards` (
`id` INT NOT NULL AUTO_INCREMENT,
`customer_id` INT NOT NULL ,
`card_number` VARCHAR(25) NOT NULL,
`expire_month` INT NOT NULL ,
`expire_year` INT NOT NULL ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='c7210658f7b3ba2be4ecbea66e55464b' AND cache_id="blockcategories|1|1|17|2|3" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='04ea7e7a4a9deeb490f69f3c0ae1c47d' AND cache_id="wpcopylogo|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 17
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='fb2ff280ef39b7381f40618daa1780e5' AND cache_id="wpbxslider|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='976b1b98a397884229fb728eaf9917f0' AND cache_id="blockbestsellers-col|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='97fb26615db2a2a1baee760ebe137d56' AND cache_id="wphomefeatured|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='bae0b905d9f052c3f4c72d1aea34d250' AND cache_id="blockcontact|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f5ec0030019718e634a38ab3f73e1d78' AND cache_id="wpblockspecials|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5e593a38bbb1f55007b6f0fe7cdd1847' AND cache_id="blocksearch-top|1|1|17" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1

SELECT SQL_NO_CACHE * FROM ps_memcached_servers

CREATE TABLE IF NOT EXISTS `ps_revolut_payment_orders` (
`id` INT NOT NULL AUTO_INCREMENT,
`id_order` INT NULL ,
`id_cart` INT NULL ,
`id_revolut_order` VARCHAR(250) NOT NULL ,
`payment_method` VARCHAR(250) NULL ,
`public_id` VARCHAR(250) NOT NULL ,
`save_card` TINYINT NOT NULL DEFAULT "0" ,
PRIMARY KEY (`id`),
UNIQUE (`id_revolut_order`),
UNIQUE (`id_order`)
) ENGINE = InnoDB;