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 ( 1203090 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '105 cm ancho (para cama 105 ó 90 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 67, 2 => 125, ), 'price' => 41.32000000000000028421709430404007434844970703125, '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' => '1203090-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'67\',\'125\'', ), 1202980 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '80 cm ancho (para cama 75 ó 80 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 65, 2 => 123, ), 'price' => 0.0, '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' => '1202980-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'65\',\'123\'', ), 1202982 => 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' => 24.78999999999999914734871708787977695465087890625, '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' => '1202982-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'65\',\'125\'', ), 1202981 => 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' => 12.4000000000000003552713678800500929355621337890625, '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' => '1202981-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'65\',\'126\'', ), 1203089 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '105 cm ancho (para cama 105 ó 90 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 67, 2 => 126, ), 'price' => 28.92999999999999971578290569595992565155029296875, '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' => '1203089-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'67\',\'126\'', ), 1203414 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '195 cm ancho (para cama 180 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 260, 2 => 125, ), 'price' => 103.2999999999999971578290569595992565155029296875, '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' => '1203414-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'260\',\'125\'', ), 1203088 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '105 cm ancho (para cama 105 ó 90 cm).', 14 => 'Sin Botones', ), 'attributes' => array ( 0 => 3, 1 => 67, 2 => 123, ), 'price' => 16.530000000000001136868377216160297393798828125, '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' => '1203088-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'67\',\'123\'', ), 1203413 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '195 cm ancho (para cama 180 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 260, 2 => 126, ), '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' => 100, 'reference' => '1203413-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'260\',\'126\'', ), 1203412 => 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' => 78.5100000000000051159076974727213382720947265625, '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' => '1203412-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'260\',\'123\'', ), 1203252 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '150 cm ancho (para cama 135 ó 150 cm).', 14 => 'Con Cristales de Swarovski', ), 'attributes' => array ( 0 => 3, 1 => 70, 2 => 125, ), 'price' => 66.1099999999999994315658113919198513031005859375, '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' => 96, 'reference' => '1203252-CABECEROTSS0001', 'unit_impact' => 0.0, 'minimal_quantity' => '1', 'date_formatted' => '', 'available_date' => '', 'id_image' => 18187, 'list' => '\'3\',\'70\',\'125\'', ), 1203251 => array ( 'attributes_values' => array ( 2 => ' Polipiel - Nilo 1 Negro', 7 => '150 cm ancho (para cama 135 ó 150 cm).', 14 => 'Botón tapizado igual que color principal', ), 'attributes' => array ( 0 => 3, 1 => 70, 2 => 126, ), 'price' => 53.719999999999998863131622783839702606201171875, 'specific_price' => array ( 'id_specific_price' => '69', 'id_specific_price_rule' => '0', 'id_c