Orig: SET NAMES utf8 Now: SET NAMES utf8 Orig: SELECT `store_website`.* FROM `store_website` Now: SELECT `store_website`.* FROM `store_website` Orig: SELECT `store_group`.* FROM `store_group` Now: SELECT `store_group`.* FROM `store_group` Orig: SELECT `store`.* FROM `store` Now: SELECT `store`.* FROM `store` Orig: SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`=) Now: SELECT `flag`.* FROM `flag` WHERE (`flag`.`flag_code`=) Orig: SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN (, )) AND (`store_id` IN ()) Now: SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN (, )) AND (`store_id` IN ()) Orig: SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ()) AND (url_rewrite.store_id IN ()) AND (relation.category_id IS NULL) Now: SELECT `url_rewrite`.*, `relation`.* FROM `url_rewrite` LEFT JOIN `catalog_url_rewrite_product_category` AS `relation` ON url_rewrite.url_rewrite_id = relation.url_rewrite_id WHERE (url_rewrite.request_path IN ()) AND (url_rewrite.store_id IN ()) AND (relation.category_id IS NULL) Orig: SELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`=) AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 Now: SELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`block_id`=) AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 Orig: SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = ) Now: SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = ) Orig: SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) Now: SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) Customer Login

JavaScript seems to be disabled in your browser. For the best experience on our site, be sure to turn on Javascript in your browser.

Toggle Nav

My Cart

Orig: SELECT `main_table`.* FROM `checkout_agreement` AS `main_table` INNER JOIN `checkout_agreement_store` AS `store_table_1` ON main_table.agreement_id = store_table_1.agreement_id WHERE (store_table_1.store_id IN (, 0)) AND ((`is_active` = 1)) GROUP BY `main_table`.`agreement_id` Now: SELECT `main_table`.* FROM `checkout_agreement` AS `main_table` INNER JOIN `checkout_agreement_store` AS `store_table_1` ON main_table.agreement_id = store_table_1.agreement_id WHERE (store_table_1.store_id IN (, 0)) AND ((`is_active` = 1)) GROUP BY `main_table`.`agreement_id`

Orig: SELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`=) AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 Now: SELECT `cms_block`.`block_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`=) AND (is_active = 1) AND (cbs.store_id in (1, 0)) ORDER BY `store_id` DESC LIMIT 1 Orig: SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = ) Now: SELECT `t`.* FROM `cms_block` AS `t` WHERE (block_id = ) Orig: SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id) Now: SELECT `cbs`.`store_id` FROM `cms_block_store` AS `cbs` INNER JOIN `cms_block` AS `cb` ON cbs.block_id = cb.block_id WHERE (cb.block_id = :block_id)

The #1 Online Source for Military Museum Displays • Movie Props • Training Aids • Historical Artifacts

Compare Products

Account

Customer Login

New Customers

Creating an account has many benefits: check out faster, keep more than one address, track orders and more.