I prodotti di questa categoria non possono essere acquistati pagando con carta di credito - Pay Pal . Prima di procedere all'acquisto leggere attentamente le condizioni di vendita delle armi

SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (28790, 32627, 32629, 34462, 34573, 34782, 34783, 23290, 23511, 25445, 19055, 19057, 21051, 21054, 21112, 27514, 27515, 27516, 27802, 27803, 28514, 28515, 28655, 28656, 34461)) AND (t_d.attribute_id IN (71, 85, 86, 87, 97, 112, 113, 114, 119, 296)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (28790, 32627, 32629, 34462, 34573, 34782, 34783, 23290, 23511, 25445, 19055, 19057, 21051, 21054, 21112, 27514, 27515, 27516, 27802, 27803, 28514, 28515, 28655, 28656, 34461)) AND (t_d.attribute_id IN (76, 120)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (28790, 32627, 32629, 34462, 34573, 34782, 34783, 23290, 23511, 25445, 19055, 19057, 21051, 21054, 21112, 27514, 27515, 27516, 27802, 27803, 28514, 28515, 28655, 28656, 34461)) AND (t_d.attribute_id IN (77, 78, 93, 94)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 2 WHERE (e.entity_id IN (28790, 32627, 32629, 34462, 34573, 34782, 34783, 23290, 23511, 25445, 19055, 19057, 21051, 21054, 21112, 27514, 27515, 27516, 27802, 27803, 28514, 28515, 28655, 28656, 34461)) AND (t_d.attribute_id IN (81, 96, 121, 123, 125, 126, 127, 128, 131, 255, 306, 308, 309, 310)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))