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';