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 (11058, 18487, 21002, 24931, 28041, 28132, 28133, 29873, 30419, 32464, 33054, 33055, 33131, 33356, 35618, 35682, 35683, 36460, 1687, 8261, 11060, 11070, 18386, 19326, 21008, 21406, 24164, 24324, 24341, 25989, 25990, 26117)) 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 (11058, 18487, 21002, 24931, 28041, 28132, 28133, 29873, 30419, 32464, 33054, 33055, 33131, 33356, 35618, 35682, 35683, 36460, 1687, 8261, 11060, 11070, 18386, 19326, 21008, 21406, 24164, 24324, 24341, 25989, 25990, 26117)) 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 (11058, 18487, 21002, 24931, 28041, 28132, 28133, 29873, 30419, 32464, 33054, 33055, 33131, 33356, 35618, 35682, 35683, 36460, 1687, 8261, 11060, 11070, 18386, 19326, 21008, 21406, 24164, 24324, 24341, 25989, 25990, 26117)) 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 (11058, 18487, 21002, 24931, 28041, 28132, 28133, 29873, 30419, 32464, 33054, 33055, 33131, 33356, 35618, 35682, 35683, 36460, 1687, 8261, 11060, 11070, 18386, 19326, 21008, 21406, 24164, 24324, 24341, 25989, 25990, 26117)) 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))