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 PICASSO (LARGO)

¡Precio rebajado! Cabecero tapizado PICASSO (LARGO)
  • Material: Polipiel
  • Fabricamos: Cualquier medida
  • Grosor: 8 cm
  • Altura: 125 cm
Ver colores Cerrar colores

80,10 €

89,00 €

-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
NULL
array ( 1203468 => 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' => 115.7000000000000028421709430404007434844970703125, 'specific_price' => array ( 'id_specific_price' => '69', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '155', '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' => '1203468-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'261\',\'125\'', ), 1203467 => 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' => 103.31000000000000227373675443232059478759765625, 'specific_price' => array ( 'id_specific_price' => '69', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '155', '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' => '1203467-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'261\',\'126\'', ), 1203466 => 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' => 90.909999999999996589394868351519107818603515625, 'specific_price' => array ( 'id_specific_price' => '69', 'id_specific_price_rule' => '0', 'id_cart' => '0', 'id_product' => '155', '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' => 99, 'reference' => '1203466-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'261\',\'123\'', ), 1203144 => a