Service Client Gratuit : 02 40 58 98 00

Satisfait ou remboursé sous 15 jours

Le matériel médical pour professionnels et particuliers
0 Mon panier Mon compte

Kit d'attelles rigides Spencer Blue Splint

( 0 Commentaire(s) )

Kit d'attelles rigides Spencer Blue Splint - Souplesse et Compacité - 5 attelles - Poignet, avant bras adulte, jambe adulte, jambe enfant - Fourni avec sac de transport

Voir la description complète.

Prix public : 203,64 € TTC

Prix Girodmedical :

162,91 € TTC

Soit une économie de 20 %

Disponibilité : Epuisé

Description
Détails
Avis
Contact

Kit d'attelles rigides Spencer Blue Splint
Ces attelles ont été conçues pour immobiliser les membres de façon efficace, simple et pratique.
Ce kit est constitué de cinq attelles :
- Immobilisation du poignet (302 x 255 mm)
- Immobilisation de l'avant bras de l'adulte ou de la jambe de l'enfant (387 x 300 mm)
- Immobilisation de la cheville, du coude ou utilisable pour perfusions (540 x 305 mm)
- Immobilisaiton du bras de l'adulte ou de la jambe de l'enfant (582 x 290 mm)
- Immobilisation de la jambe de l'adulte (578 x 420 mm)
Toutes les attelles peuvent être modelées selon la forme désirée et une fois obtenu le profil voulu, l'attelle pourra offrir une extraordinaire rigidité.

Pour remettre l'attelle en position initiale de configuration, il suffit de redresser l'armature avec les mains.
Extrêmement légères, elles peuvent se positionner l'une sur l'autre en créant une infinité de configuration et solutions pour l'adulte et l'enfant
La souplesse et la compacité qui les caractérisent permettent au secouriste d'utiliser les attelles dans les situations les plus diverses.
Elles sont idéales pour les ambulances, VSL, secours en montagne, en médecine sportive, secours aquatique, en centre d'orthopédie ou encore en centre d'urgence.
Légèreté du jeu complet et les dimensions réduites rendent ce système le plus complet et compact du marché
Fournies dans un sac dde transport en Ripstop
Dimensions du Kit : 640 x 100 x h3 10 mm
Poids : 1,5 kg

Référence SSATTE01

Détails sur le produit Kit d'attelles rigides Spencer Blue Splint :

Référence ARRET-SSATTE01
Poids 1.50 Kg
Fabricant Spencer

Besoin d'informations complémentaires sur le produit Kit d'attelles rigides Spencer Blue Splint ?






* Champs obligatoires

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`availablestock`, `e`.`ordered_qty`, `e`.`default_supply_delay`, `e`.`supply_date`, `e`.`ugiftcert_amount_config`, `e`.`ranking`, `e`.`is_in_stock_configurable`, `e`.`is_in_stock_configurable_value`, `e`.`before_sold_price`, `e`.`expedition_directe_fournisseur`, `e`.`materiel_rembourse_lpp`, `e`.`materiel_rembourse_lpp_value`, `e`.`links_exist`, `e`.`discount_price`, `e`.`discount_price_from`, `e`.`discount_price_to`, `e`.`sale_price`, `e`.`mea_product_date`, `e`.`marge`, `e`.`length_sale_flash`, `e`.`sales_flash_active`, `e`.`flash_price`, `e`.`stock_max`, `e`.`start_sale_flash`, `e`.`data_sales_flash_order`, `e`.`retour_gratuit`, `e`.`delais_retour`, `e`.`customizable`, `e`.`customizable_value`, `e`.`product_gender`, `e`.`product_gender_value`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `_table_is_in_stock_configurable`.`value` AS `is_in_stock_configurable`, `_table_qty`.`qty`, `_table_ordered_qty`.`stock_ordered_qty` AS `ordered_qty`, `e`.`price` AS `priceNoSolded`, `e`.`tax_class_id` AS `taxClassIdReal`, `e`.`tax_class_id`, IF( IF(sales_flash_active=1,IF(stock_max < `_table_qty`.qty,IF(DATE_ADD(start_sale_flash, INTERVAL length_sale_flash DAY) > NOW(),IF(start_sale_flash < NOW(),1,0),0),0),0) = 1,flash_price,IF(
                     IF(discount_price IS NULL,
                        1, IF(DATE(discount_price_from) <= DATE(NOW()), 1, IF(discount_price_from IS NULL , 1, 0 ))) > 0
                           AND IF(DATE(discount_price_to) IS NULL, 1, IF(DATE(discount_price_to) >= DATE(NOW()), 1, IF(DATE(discount_price_to) = '2001-01-01',1,0) )
                       ) > 0 AND discount_price < e.price AND discount_price != 0 , discount_price, e.price)) AS `final_price`, IF(sales_flash_active=1,IF(stock_max < `_table_qty`.qty,IF(DATE_ADD(start_sale_flash, INTERVAL length_sale_flash DAY) > NOW(),IF(start_sale_flash < NOW(),1,0),0),0),0) AS `girodprice_sales_flash`, e.price AS `price`, e.created_at AS `created_at`,  e.ranking + e.ranking * IF(landingpage_store.landingpage_id IS NOT NULL , 100, 0) + e.ranking * IF( e.manufacturer = 1209, 50 , 0) AS `ranking_calculated`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 LEFT JOIN `catalog_product_entity_int` AS `_table_is_in_stock_configurable` ON (_table_is_in_stock_configurable.entity_id=e.entity_id) AND (_table_is_in_stock_configurable.attribute_id=701)
 LEFT JOIN `cataloginventory_stock_item` AS `_table_qty` ON (_table_qty.product_id=e.entity_id) AND (_table_qty.stock_id=1)
 LEFT JOIN `cataloginventory_stock_item` AS `_table_ordered_qty` ON (_table_ordered_qty.product_id=e.entity_id) AND (_table_ordered_qty.stock_id=1)
 LEFT JOIN `girodlandingpage_item` AS `landingpage_item` ON landingpage_item.product_id = e.entity_id
 LEFT JOIN `girodlandingpage_item` AS `filter_landing` ON filter_landing.landingpage_id = landingpage_item.landingpage_id AND filter_landing.product_id = 11808
 LEFT JOIN `girodlandingpage` AS `landingpage` ON filter_landing.landingpage_id = landingpage.landingpage_id AND landingpage.is_active = 1
 LEFT JOIN `girodlandingpage_store` AS `landingpage_store` ON landingpage_store.landingpage_id = landingpage.landingpage_id AND landingpage_store.store_id = 1
 INNER JOIN `catalog_category_product_index` AS `category_index` ON category_index.`product_id` = e.entity_id AND category_index.category_id IN ( ) 
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id='11' WHERE (e.entity_id != 11808) GROUP BY `e`.`entity_id` ORDER BY `ranking_calculated` DESC LIMIT 10

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.prod' at line 14

#0 /var/www/magento-1.4/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/magento-1.4/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/magento-1.4/lib/Zend/Db/Adapter/Pdo/Abstract.php(241): Zend_Db_Adapter_Abstract->query('SELECT 1 AS `st...', Array)
#3 /var/www/magento-1.4/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `st...', Array)
#4 /var/www/magento-1.4/lib/Zend/Db/Adapter/Abstract.php(707): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /var/www/magento-1.4/lib/Varien/Data/Collection/Db.php(704): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /var/www/magento-1.4/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(953): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /var/www/magento-1.4/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(793): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#8 /var/www/magento-1.4/lib/Varien/Data/Collection.php(264): Mage_Eav_Model_Entity_Collection_Abstract->load()
#9 /var/www/magento-1.4/app/code/local/Girodmedical/Girodrefnat/Block/Crossselling.php(76): Varien_Data_Collection->getItems()
#10 /var/www/magento-1.4/app/design/frontend/default/girodmedical/template/girodrefnat/crossselling.phtml(1): Girodmedical_Girodrefnat_Block_Crossselling->getCrosssellProduct()
#11 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/var/www/magent...')
#12 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#13 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#14 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#15 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(520): Mage_Core_Block_Abstract->toHtml()
#16 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(471): Mage_Core_Block_Abstract->_getChildHtml('girodrefnat_cro...', true)
#17 /var/www/magento-1.4/app/design/frontend/default/girodmedical/template/catalog/product/view.phtml(181): Mage_Core_Block_Abstract->getChildHtml('girodrefnat_cro...')
#18 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/var/www/magent...')
#19 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#20 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#21 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#22 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#23 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Text_List->_toHtml()
#24 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(520): Mage_Core_Block_Abstract->toHtml()
#25 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(471): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#26 /var/www/magento-1.4/app/design/frontend/default/girodmedical/template/page/1column.phtml(49): Mage_Core_Block_Abstract->getChildHtml('content')
#27 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/var/www/magent...')
#28 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#29 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#30 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#31 /var/www/magento-1.4/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#32 /var/www/magento-1.4/app/code/local/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#33 /var/www/magento-1.4/app/code/local/Girodmedical/Productredirection/controllers/Catalog/ProductController.php(57): Mage_Core_Controller_Varien_Action->renderLayout()
#34 /var/www/magento-1.4/app/code/local/Mage/Core/Controller/Varien/Action.php(418): Girodmedical_Productredirection_Catalog_ProductController->viewAction()
#35 /var/www/magento-1.4/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#36 /var/www/magento-1.4/app/code/core/Mage/Core/Controller/Varien/Front.php(184): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#37 /var/www/magento-1.4/app/code/local/Mage/Core/Model/App.php(298): Mage_Core_Controller_Varien_Front->dispatch()
#38 /var/www/magento-1.4/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#39 /var/www/magento-1.4/index.php(110): Mage::run('fr_fr', 'store')
#40 {main}