LE ARMI E LE ARMI AD ARIA COMPRESSA DI LIBERA VENDITA
POSSONO ESSERE SPEDITE SOLO AD ALTRE ARMERIE PREVIO ACCORDO
OPPURE SI POSSONO RITIRARE NELLA NOSTRA SEDE
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
CONTATTARE PER L'EFFETTIVA DISPONIBILITA' 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))