cerca
Richmond JR
Piumino Richmond JR
[RCB0282BJ]
Codice prodotto: C0110992B16D
Prezzo:  
Variante prodotto

Descrizione

MADE IN ITALY: tessuto tecnico, trapuntato, tinta unita, collo alto, monopetto, zip e automatici, multitasche, maniche lunghe, interno in piuma d'oca, lavare a 30°, non asciugare meccanicamente, cappuccio, contiene parti non tessili di origine animale.

Collezione

AUTUNNO/INVERNO

Composizione

Tessuto1: 100%POLYESTER. Tessuto 2: 100%POLYESTER. Inserti: 100% FUR. Imbottitura: 100% FEATHER GOOSE.

ALTRI PRODOTTI DELLO STESSO BRAND

ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  
ABSOLUT JOY  

NEWSLETTER

RICEVI SCONTI E PROMOZIONI ESCLUSIVE ISCRIVENDOTI
ALLA NOSTRA NEWSLETTER

 
Vesto Italiano S.R.L. Unipersonale - C.F./P.Iva 04050650409 - Reg. imprese FC 327669 - Cap. Soc. EUR 10.000 i.v.
Current Parse Time: 1.308 s with 72 queries
QUERY DEBUG:
Array
(
    [QUERIES] => Array
        (
            [0] => select distinct c.categories_id, c.parent_id, cd.categories_name from categories c inner join categories_description cd on c.categories_id=cd.categories_id inner join products_to_categories p2c on c.categories_id=p2c.categories_id   
    inner join products p ON (p.products_id=p2c.products_id)
        inner join products_description pd ON (p.products_id=pd.products_id)
        left join manufacturers m using(manufacturers_id) where cd.language_id=4 and 1=1  and p.products_status = '1'
            [1] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
            [2] => select languages_id, name, code, image, directory from languages order by sort_order
            [3] => select banners_id, date_scheduled from banners where date_scheduled != ''
            [4] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id
            [5] => select specials_id from specials where status = '0' and now() >= date_inizio and date_inizio > 0 and now() < expires_date and expires_date > 0
            [6] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
            [7] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0
            [8] => select p2c.categories_id from products p, products_to_categories p2c where p.products_id = '237923' and p.products_status = '1' and p.products_id = p2c.products_id limit 1
            [9] => select parent_id from categories where categories_id = '162'
            [10] => select parent_id from categories where categories_id = '158'
            [11] => select parent_id from categories where categories_id = '155'
            [12] => select parent_id from categories where categories_id = '154'
            [13] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '154' and language_id = '4'
            [14] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '155' and language_id = '4'
            [15] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '158' and language_id = '4'
            [16] => select categories_name,categories_description,meta_title,meta_description,meta_keyword from categories_description where categories_id = '162' and language_id = '4'
            [17] => select products_model,products_name,products_page_title,products_page_description 
    from products inner join products_description 
    on products.products_id=products_description.products_id where products.products_id = '237923' and language_id = '4'
            [18] => select count(*) as total from products_to_categories where categories_id = '162'
            [19] => select * from traduzioni
            [20] => select distinct taglia from products_to_categories p2c inner join categories c ON (p2c.categories_id = c.categories_id)
    inner join products p ON (p.products_id=p2c.products_id) inner join products_description pd on (p.products_id=pd.products_id) inner join categories_description cd on (cd.categories_id=c.categories_id) inner join manufacturers m on (m.manufacturers_id=p.manufacturers_id) where p.products_status = '1' and p.products_id = pd.products_id and cd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '4' and c.categories_tree like '%;162;%'  order by taglia
            [21] => select distinct colore1 from products_to_categories p2c inner join categories c ON (p2c.categories_id = c.categories_id)
    inner join products p ON (p.products_id=p2c.products_id) inner join products_description pd on (p.products_id=pd.products_id) inner join categories_description cd on (cd.categories_id=c.categories_id)  inner join manufacturers m on (m.manufacturers_id=p.manufacturers_id) where p.products_status = '1' and p.products_id = pd.products_id and cd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '4' and c.categories_tree like '%;162;%'  order by colore1
            [22] => select distinct season_code, season_id from products p left join season s ON(s.season_id = p.stagione) order by season_id
            [23] => select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id=4 and c.parent_id = 0 and c.visibile = 1 and cd.categories_id>0 order by sort_order, cd.categories_name
            [24] => select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id=4 and c.parent_id = 0 and c.visibile = 1 and cd.categories_id>0 order by sort_order, cd.categories_name
            [25] => select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and c.visibile = 1 and cd.language_id=4 and c.parent_id = 0 and cd.categories_id>0 order by sort_order, cd.categories_name
            [26] => SELECT c.categories_tree, c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                      FROM categories c, categories_description cd
                      WHERE 
                        c.categories_id = cd.categories_id
                        and c.visibile = 1 
                        AND cd.language_id=4 
                        AND (c.parent_id in (select categories_id from  categories where parent_id=38) or c.parent_id=38)
                        AND (c.categories_id=39 or c.categories_id=108 or c.categories_id=139)       
                        and c.parent_id = 38
                        AND cd.categories_id>0
            [27] => SELECT c.categories_tree, c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                      FROM categories c, categories_description cd
                      WHERE 
                        c.categories_id = cd.categories_id
                        and c.visibile = 1 
                        AND cd.language_id=4 
                        AND (c.parent_id in (select categories_id from  categories where parent_id=1) or c.parent_id=1)
                        AND (c.categories_id=2 or c.categories_id=94 or c.categories_id=98 or c.categories_id=100 or c.categories_id=138)       
                        and c.parent_id = 1
                        AND cd.categories_id>0
            [28] => SELECT c.categories_tree, c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                      FROM categories c, categories_description cd
                      WHERE 
                        c.categories_id = cd.categories_id
                        and c.visibile = 1 
                        AND cd.language_id=4 
                        AND (c.parent_id in (select categories_id from  categories where parent_id=154) or c.parent_id=154)
                        AND (c.categories_id=155 or c.categories_id=156)       
                        and c.parent_id = 154
                        AND cd.categories_id>0
            [29] => select p.products_id,p.listino, p.consel, p.MPN,p.trasportogratis, pd.products_name,p.products_sconto,p.products_sconto_rivenditore,p.products_forsale,
        pd.products_description,pd.products_cartec,pd.products_note,pd.products_materiale,p.products_submodel, p.products_model, p.products_quantity,p.colore1 as color,
        p.products_image,pd.products_submodel_desc,p.articolo,p.modello,ad.nome as colore1,p.stagione,products_barcode, pi.products_image1, pi.products_image2, pi.products_image3, pi.products_image4, pi.products_image5,p.arrivo,p.produttore,
        pi.products_image6, pi.products_image7, pi.products_image8, pi.products_image9,  pd.products_url, p.products_price_listino, p.products_price_gross, p.products_price, p.products_tax_class_id,p.products_price_rivenditore,
        p.products_date_added, p.products_date_available, p.manufacturers_id, tm.manufacturers_name,c.tipocat,c.categories_id,c.categories_tree,p.products_weight_im, 
        p.products_lotto, p.products_stock, tax_class_title,p.video, multivar,
        IF(s.status, s.specials_new_products_price_gross, NULL) as specials_new_products_price_gross,
        IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price , products_submodel
        FROM products p inner join products_description pd on pd.products_id = p.products_id
        inner join products_to_categories p2c on p.products_id=p2c.products_id
        inner join categories c on c.categories_id=p2c.categories_id
        left join specials s on p.products_id = s.products_id
        left join products_images pi on p.products_id=pi.products_id
        left join manufacturers tm on p.manufacturers_id=tm.manufacturers_id
        left join attributi_desc ad on (p.colore1=ad.id_attributo and ad.languages_id = '4')
        left join tax_class tc ON (p.products_tax_class_id = tc.tax_class_id)
        WHERE p.products_status = '1' 
        AND p.products_id = '237923'
        AND pd.language_id = '4' and p.products_price_rivenditore > 0 
            [30] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237923 and (expires_date > now() or expires_date IS NULL) and status=1
            [31] => 
    select
    p.products_id,p.taglia,ad.nome as colore1,p.colore1 as color,
    pd.products_submodel_desc,pd.products_note,p.products_sconto,p.products_sconto_rivenditore,
    p.products_price_gross,p.products_quantity,at.color,p.products_image,p.produttore, products_submodel
    from products p 
    inner join products_description pd on p.products_id=pd.products_id
    left join attributi at on p.colore1=at.id_attributo
    left join attributi at1 on p.taglia=at1.id_attributo
    left join attributi_desc ad on (at.id_attributo=ad.id_attributo and ad.languages_id = '4') 
    where
    p.products_status='1'  and p.products_price_rivenditore > 0  AND pd.language_id = '4'
    and p.products_model='RCB0282BJ'  order by p.colore1,at1.posizione
            [32] => SELECT products_price,products_price_gross FROM products WHERE products_id=237917
            [33] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237917 and (expires_date > now() or expires_date IS NULL) and status=1
            [34] => SELECT products_price,products_price_gross FROM products WHERE products_id=237918
            [35] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237918 and (expires_date > now() or expires_date IS NULL) and status=1
            [36] => SELECT products_price,products_price_gross FROM products WHERE products_id=237919
            [37] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237919 and (expires_date > now() or expires_date IS NULL) and status=1
            [38] => SELECT products_price,products_price_gross FROM products WHERE products_id=237920
            [39] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237920 and (expires_date > now() or expires_date IS NULL) and status=1
            [40] => SELECT products_price,products_price_gross FROM products WHERE products_id=237921
            [41] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237921 and (expires_date > now() or expires_date IS NULL) and status=1
            [42] => SELECT products_price,products_price_gross FROM products WHERE products_id=237922
            [43] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237922 and (expires_date > now() or expires_date IS NULL) and status=1
            [44] => SELECT products_price,products_price_gross FROM products WHERE products_id=237923
            [45] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237923 and (expires_date > now() or expires_date IS NULL) and status=1
            [46] => SELECT products_price,products_price_gross FROM products WHERE products_id=237924
            [47] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237924 and (expires_date > now() or expires_date IS NULL) and status=1
            [48] => SELECT products_price,products_price_gross FROM products WHERE products_id=237925
            [49] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237925 and (expires_date > now() or expires_date IS NULL) and status=1
            [50] => SELECT products_price,products_price_gross FROM products WHERE products_id=237926
            [51] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237926 and (expires_date > now() or expires_date IS NULL) and status=1
            [52] => SELECT products_price,products_price_gross FROM products WHERE products_id=237927
            [53] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237927 and (expires_date > now() or expires_date IS NULL) and status=1
            [54] => SELECT products_price,products_price_gross FROM products WHERE products_id=237928
            [55] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237928 and (expires_date > now() or expires_date IS NULL) and status=1
            [56] => SELECT products_price,products_price_gross FROM products WHERE products_id=237929
            [57] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=237929 and (expires_date > now() or expires_date IS NULL) and status=1
            [58] => select distinct p.products_model, m.manufacturers_name, p.products_quantity,p.products_image, m.manufacturers_id, p.trasportogratis, p.colore1,p.colore2,p.novita,p.products_sconto,p.products_sconto_rivenditore,p.multivar,p.products_price_rivenditore,
                          p.products_submodel,p.products_id, pd.products_name, pd.products_description,pd.products_materiale,p2c.categories_id,cd.categories_name,p.products_forsale,
                          p.products_price_gross ,p.products_price, p.products_price_listino,p.listino,p.products_tax_class_id,
                          SUM(p.products_quantity) as qta_tot
                           from products p left join manufacturers m using(manufacturers_id) 
                         left join specials s on p.products_id = s.products_id
                         inner join products_description pd on p.products_id=pd.products_id 
                         inner join products_to_categories p2c on p.products_id=p2c.products_id 
                         inner join categories c on c.categories_id=p2c.categories_id 
                         inner join categories_description cd on c.categories_id=cd.categories_id 
                         inner join products_kit pk on p.products_id = pk.pop_products_id_slave
                          where p.products_status = '1' and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and cd.language_id = '4'  and pk.pop_products_id_master=237923 and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  group by p.products_model,p.colore1 
            [59] => select p.products_id, p.MPN, m.manufacturers_name, p.products_image,pd.products_name,pd.products_description, p.products_quantity, p.products_tax_class_id, s.status AS specstat,p.trasportogratis, IF(s.status, s.specials_new_products_price_gross, NULL) AS specials_new_products_price_gross, p.products_price_gross, p.products_price, p.products_forsale, p.products_submodel, p.products_price_listino,p.listino,  products_model, colore1 AS color FROM products p
                   LEFT JOIN manufacturers m USING(manufacturers_id)
                   LEFT JOIN specials s ON p.products_id = s.products_id
                   INNER JOIN products_description pd ON p.products_id=pd.products_id
                   LEFT JOIN products_related_products n ON p.products_id = n.pop_products_id_slave  where p.products_status = '1' AND p.products_id = pd.products_id  and p.products_price_rivenditore > 0 AND p.products_forsale_rivenditore=1  AND pd.language_id = '4'  and p.manufacturers_id = '178' group by p.products_model order by rand(1489318423) DESC limit 12
            [60] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=229892 and (expires_date > now() or expires_date IS NULL) and status=1
            [61] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=235932 and (expires_date > now() or expires_date IS NULL) and status=1
            [62] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=234680 and (expires_date > now() or expires_date IS NULL) and status=1
            [63] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=234079 and (expires_date > now() or expires_date IS NULL) and status=1
            [64] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=234537 and (expires_date > now() or expires_date IS NULL) and status=1
            [65] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=228930 and (expires_date > now() or expires_date IS NULL) and status=1
            [66] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=230539 and (expires_date > now() or expires_date IS NULL) and status=1
            [67] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=236974 and (expires_date > now() or expires_date IS NULL) and status=1
            [68] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232009 and (expires_date > now() or expires_date IS NULL) and status=1
            [69] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=229499 and (expires_date > now() or expires_date IS NULL) and status=1
            [70] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=230411 and (expires_date > now() or expires_date IS NULL) and status=1
            [71] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=235117 and (expires_date > now() or expires_date IS NULL) and status=1
        )

    [TIME] => Array
        (
            [0] => 0.003913
            [1] => 0.000525
            [2] => 0.000510
            [3] => 0.000826
            [4] => 0.029458
            [5] => 0.000541
            [6] => 0.000353
            [7] => 0.000278
            [8] => 0.000944
            [9] => 0.000310
            [10] => 0.000233
            [11] => 0.000151
            [12] => 0.000217
            [13] => 0.000262
            [14] => 0.000236
            [15] => 0.000181
            [16] => 0.000289
            [17] => 0.000329
            [18] => 0.000762
            [19] => 0.000574
            [20] => 0.406785
            [21] => 0.343012
            [22] => 0.254312
            [23] => 0.001419
            [24] => 0.000620
            [25] => 0.001167
            [26] => 0.003334
            [27] => 0.000983
            [28] => 0.000990
            [29] => 0.001752
            [30] => 0.000484
            [31] => 0.002052
            [32] => 0.000436
            [33] => 0.000438
            [34] => 0.000456
            [35] => 0.000487
            [36] => 0.001148
            [37] => 0.000537
            [38] => 0.000282
            [39] => 0.000326
            [40] => 0.000258
            [41] => 0.000370
            [42] => 0.000479
            [43] => 0.000321
            [44] => 0.000436
            [45] => 0.000981
            [46] => 0.002689
            [47] => 0.000551
            [48] => 0.000343
            [49] => 0.000455
            [50] => 0.000454
            [51] => 0.000319
            [52] => 0.000210
            [53] => 0.000302
            [54] => 0.000368
            [55] => 0.000430
            [56] => 0.000427
            [57] => 0.000251
            [58] => 0.004708
            [59] => 0.149478
            [60] => 0.000495
            [61] => 0.000921
            [62] => 0.000244
            [63] => 0.000372
            [64] => 0.000239
            [65] => 0.000267
            [66] => 0.000258
            [67] => 0.000186
            [68] => 0.000192
            [69] => 0.000319
            [70] => 0.000238
            [71] => 0.000223
        )

)

SESSION:
Array
(
    [session_product_listing] => 
)

COOKIE:
Array
(
)
POST:
Array
(
)

GET:
Array
(
    [page] => detail
    [products_id] => 237923
    [products_name] => piumino_richmond_jr.html
)