SELECT * FROM ps_product_attribute pa LEFT JOIN ps_product_attribute_image pai ON (pa.id_product_attribute=pai.id_product_attribute) WHERE pa.id_product_attribute= GROUP BY pa.id_product_attribute

Cabecero tapizado VAN GOGH (CORTO)

¡Oferta! Cabecero tapizado VAN GOGH (CORTO)
  • Material: Polipiel
  • Fabricamos: Cualquier medida
  • Grosor: 8 cm
  • Altura: 61 cm
Ver colores Cerrar colores

79,00 €

87,78 €

-10%

ENTREGA 24/48H

  • Envío Express:

    Compra ahora y en 24 - 48 horas laborables lo recibes en tu casa

  • Envío Estándar:

    Compra ahora y en 2 a 5 días laborables recibirás el pedido en tu domicilio.

Envio gratis
3 años de garantia
100 noches de prueba

Instrucciones de montaje

NULL
array ( 1206552 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '195 cm ancho (para cama 180 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 260, 2 => 123, ), 'price' => 96.3599999999999994315658113919198513031005859375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206552-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'260\',\'123\'', ), 1206446 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '165 cm ancho (para cama 150 ó 165 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 71, 2 => 125, ), 'price' => 114.780000000000001136868377216160297393798828125, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206446-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'71\',\'125\'', ), 1206445 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '165 cm ancho (para cama 150 ó 165 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 71, 2 => 126, ), 'price' => 78.0499999999999971578290569595992565155029296875, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206445-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'71\',\'126\'', ), 1206444 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '165 cm ancho (para cama 150 ó 165 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 71, 2 => 123, ), 'price' => 55.090000000000003410605131648480892181396484375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 98, 'reference' => '1206444-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'71\',\'123\'', ), 1206338 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '135 cm ancho (para cama 120 ó 135 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 69, 2 => 125, ), 'price' => 96.4200000000000017053025658242404460906982421875, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206338-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'69\',\'125\'', ), 1206337 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '135 cm ancho (para cama 120 ó 135 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 69, 2 => 126, ), 'price' => 59.68999999999999772626324556767940521240234375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206337-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'69\',\'126\'', ), 1206122 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '80 cm ancho (para cama 75 ó 80 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 65, 2 => 125, ), 'price' => 59.68999999999999772626324556767940521240234375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206122-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'65\',\'125\'', ), 1206336 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '135 cm ancho (para cama 120 ó 135 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 69, 2 => 123, ), 'price' => 36.72999999999999687361196265555918216705322265625, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 98, 'reference' => '1206336-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'69\',\'123\'', ), 1206284 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '120 cm ancho (para cama 105 ó 120 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 68, 2 => 125, ), 'price' => 87.2399999999999948840923025272786617279052734375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206284-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'68\',\'125\'', ), 1206121 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '80 cm ancho (para cama 75 ó 80 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 65, 2 => 126, ), 'price' => 22.96000000000000085265128291212022304534912109375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206121-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'65\',\'126\'', ), 1206283 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '120 cm ancho (para cama 105 ó 120 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 68, 2 => 126, ), 'price' => 50.50999999999999801048033987171947956085205078125, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206283-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'68\',\'126\'', ), 1206608 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '210 cm ancho (para cama 180 ó 200 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 261, 2 => 125, ), 'price' => 169.8799999999999954525264911353588104248046875, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206608-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'261\',\'125\'', ), 1206282 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '120 cm ancho (para cama 105 ó 120 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 68, 2 => 123, ), 'price' => 27.550000000000000710542735760100185871124267578125, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206282-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'68\',\'123\'', ), 1206607 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '210 cm ancho (para cama 180 ó 200 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 261, 2 => 126, ), 'price' => 133.150000000000005684341886080801486968994140625, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206607-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'261\',\'126\'', ), 1206606 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '210 cm ancho (para cama 180 ó 200 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 261, 2 => 123, ), 'price' => 110.18999999999999772626324556767940521240234375, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206606-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'261\',\'123\'', ), 1206176 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '90 cm de ancho (para cama 80 ó 90 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 66, 2 => 125, ), 'price' => 68.8700000000000045474735088646411895751953125, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206176-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'66\',\'125\'', ), 1206175 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '90 cm de ancho (para cama 80 ó 90 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 66, 2 => 126, ), 'price' => 32.1400000000000005684341886080801486968994140625, 'specific_price' => array ( 'id_specific_price' => '202', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '25', 'id_shop' => '0', 'id_shop_group' => '0', 'id_currency' => '0', 'id_country' => '0', 'id_group' => '0', 'id_customer' => '0', 'id_product_attribute' => '0', 'price' => '-1.000000', 'from_quantity' => '1', 'reduction' => '0.100000', 'reduction_tax' => '1', 'reduction_type' => 'percentage', 'from' => '0000-00-00 00:00:00', 'to' => '0000-00-00 00:00:00', 'score' => '32', ), 'ecotax' => 0.0, 'weight' => 0.0, 'quantity' => 100, 'reference' => '1206175-CABECEROVVG0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 6779, 'list' => '\'3\',\'66\',\'126\'', ), 1206500 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '180 cm ancho (para cama 160 ó 180 cm).', 14 =