UPDATE `qs_Page` AS `p`
JOIN `qs_PageOption` AS `po` ON `p`.`id` = `po`.`idPage` AND `po`.`name` = 'showInDropdowns'
SET `p`.`showInDropdowns` = 'n', `po`.`value` = 'n'
WHERE `p`.`id` = 18
AND `p`.`alias` = 'thanks.html';

-- --------

UPDATE `qs_Page` AS `p`
JOIN `qs_PageOption` AS `po` ON `p`.`id` = `po`.`idPage` AND `po`.`name` = 'showInDropdowns'
SET `p`.`showInDropdowns` = 'n', `po`.`value` = 'n'
WHERE `p`.`id` = 276
AND `p`.`alias` = 'account';

-- --------

UPDATE `qs_Page` AS `p`
JOIN `qs_PageOption` AS `po` ON `p`.`id` = `po`.`idPage` AND `po`.`name` = 'showInDropdowns'
SET `p`.`showInDropdowns` = 'n', `po`.`value` = 'n'
WHERE `p`.`id` = 300
AND `p`.`alias` = 'order-view';

-- --------

UPDATE `qs_Page` AS `p`
JOIN `qs_PageOption` AS `po` ON `p`.`id` = `po`.`idPage` AND `po`.`name` = 'showInDropdowns'
SET `p`.`showInDropdowns` = 'n', `po`.`value` = 'n'
WHERE `p`.`id` = 285
AND `p`.`alias` = 'checkout';

-- --------

UPDATE `qs_Page` AS `p`
JOIN `qs_PageOption` AS `po` ON `p`.`id` = `po`.`idPage` AND `po`.`name` = 'showInDropdowns'
SET `p`.`showInDropdowns` = 'n', `po`.`value` = 'n'
WHERE `p`.`id` = 15
AND `p`.`alias` = 'site-map.html';

-- --------

UPDATE `qs_Page` AS `p`
JOIN `qs_PageOption` AS `po` ON `p`.`id` = `po`.`idPage` AND `po`.`name` = 'showInDropdowns'
SET `p`.`showInDropdowns` = 'n', `po`.`value` = 'n'
WHERE `p`.`id` = 301
AND `p`.`alias` = 'search';
