Carrello

Mini Carello

 

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

 

QUESTI PRODOTTI NON POSSONO ESSERE PAGATI USANDO PayPal

 

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 (20382, 21532, 21779, 21780, 25055, 27868, 28111, 28112, 28113, 28122, 28164, 28282, 28598, 28599, 28600, 28836, 28882, 29149, 29629, 30231, 30232, 30446, 30563, 30572, 31838, 31848, 32544, 32603, 32769, 33855, 35230, 35619)) 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 (20382, 21532, 21779, 21780, 25055, 27868, 28111, 28112, 28113, 28122, 28164, 28282, 28598, 28599, 28600, 28836, 28882, 29149, 29629, 30231, 30232, 30446, 30563, 30572, 31838, 31848, 32544, 32603, 32769, 33855, 35230, 35619)) 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 (20382, 21532, 21779, 21780, 25055, 27868, 28111, 28112, 28113, 28122, 28164, 28282, 28598, 28599, 28600, 28836, 28882, 29149, 29629, 30231, 30232, 30446, 30563, 30572, 31838, 31848, 32544, 32603, 32769, 33855, 35230, 35619)) 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 (20382, 21532, 21779, 21780, 25055, 27868, 28111, 28112, 28113, 28122, 28164, 28282, 28598, 28599, 28600, 28836, 28882, 29149, 29629, 30231, 30232, 30446, 30563, 30572, 31838, 31848, 32544, 32603, 32769, 33855, 35230, 35619)) 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))