cerca
Richmond JR
Piumino Richmond JR
[RCB0284BJ]
Codice prodotto: C0110990
Prezzo:  
Variante prodotto
 
COLORE
TAGLIA
DISP.
QUANTITÀ
COLORE: Nero
TAGLIA : 10
DISP. : 1
QUANTITÀ :

Descrizione

MADE IN ITALY: tessuto tecnico, trapuntato, tinta unita, zip, multitasche, maniche lunghe, interno in piuma d'oca, lavare a 30°, non asciugare meccanicamente, 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: 0.853 s with 76 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 = '238042' 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 = '238042' 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 = '238042'
        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=238042 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='RCB0284BJ'  order by p.colore1,at1.posizione
            [32] => SELECT products_price,products_price_gross FROM products WHERE products_id=238034
            [33] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238034 and (expires_date > now() or expires_date IS NULL) and status=1
            [34] => SELECT products_price,products_price_gross FROM products WHERE products_id=238035
            [35] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238035 and (expires_date > now() or expires_date IS NULL) and status=1
            [36] => SELECT products_price,products_price_gross FROM products WHERE products_id=238036
            [37] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238036 and (expires_date > now() or expires_date IS NULL) and status=1
            [38] => SELECT products_price,products_price_gross FROM products WHERE products_id=238037
            [39] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238037 and (expires_date > now() or expires_date IS NULL) and status=1
            [40] => SELECT products_price,products_price_gross FROM products WHERE products_id=238038
            [41] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238038 and (expires_date > now() or expires_date IS NULL) and status=1
            [42] => SELECT products_price,products_price_gross FROM products WHERE products_id=238039
            [43] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238039 and (expires_date > now() or expires_date IS NULL) and status=1
            [44] => SELECT products_price,products_price_gross FROM products WHERE products_id=238040
            [45] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238040 and (expires_date > now() or expires_date IS NULL) and status=1
            [46] => SELECT products_price,products_price_gross FROM products WHERE products_id=238041
            [47] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238041 and (expires_date > now() or expires_date IS NULL) and status=1
            [48] => SELECT products_price,products_price_gross FROM products WHERE products_id=238042
            [49] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238042 and (expires_date > now() or expires_date IS NULL) and status=1
            [50] => SELECT products_price,products_price_gross FROM products WHERE products_id=238043
            [51] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238043 and (expires_date > now() or expires_date IS NULL) and status=1
            [52] => SELECT products_price,products_price_gross FROM products WHERE products_id=238044
            [53] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238044 and (expires_date > now() or expires_date IS NULL) and status=1
            [54] => SELECT products_price,products_price_gross FROM products WHERE products_id=238045
            [55] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238045 and (expires_date > now() or expires_date IS NULL) and status=1
            [56] => SELECT products_price,products_price_gross FROM products WHERE products_id=238046
            [57] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238046 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=238042 and p.products_price_rivenditore > 0  and p.products_forsale_rivenditore=1  group by p.products_model,p.colore1 
            [59] => SELECT products_submodel FROM products WHERE products_id = 238042
            [60] => SELECT products_price,products_price_gross FROM products WHERE products_id=238042
            [61] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238042 and (expires_date > now() or expires_date IS NULL) and status=1
            [62] => select distinct sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '105') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '15242') and tr.tax_class_id = '0' group by tr.tax_priority
            [63] => 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(1295573279) DESC limit 12
            [64] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=229112 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=236792 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=229992 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=238523 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=235324 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=234723 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=232309 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=238680 and (expires_date > now() or expires_date IS NULL) and status=1
            [72] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=229170 and (expires_date > now() or expires_date IS NULL) and status=1
            [73] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=232591 and (expires_date > now() or expires_date IS NULL) and status=1
            [74] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=238701 and (expires_date > now() or expires_date IS NULL) and status=1
            [75] => SELECT specials_new_products_price,specials_new_products_price_gross FROM specials WHERE products_id=230017 and (expires_date > now() or expires_date IS NULL) and status=1
        )

    [TIME] => Array
        (
            [0] => 0.003869
            [1] => 0.000348
            [2] => 0.000614
            [3] => 0.000609
            [4] => 0.027973
            [5] => 0.000388
            [6] => 0.000126
            [7] => 0.000234
            [8] => 0.000428
            [9] => 0.000248
            [10] => 0.000156
            [11] => 0.000212
            [12] => 0.000429
            [13] => 0.000217
            [14] => 0.000200
            [15] => 0.000146
            [16] => 0.000183
            [17] => 0.000329
            [18] => 0.000913
            [19] => 0.000645
            [20] => 0.215912
            [21] => 0.231088
            [22] => 0.169737
            [23] => 0.000670
            [24] => 0.000398
            [25] => 0.000419
            [26] => 0.000359
            [27] => 0.000476
            [28] => 0.000407
            [29] => 0.000944
            [30] => 0.000260
            [31] => 0.001067
            [32] => 0.000171
            [33] => 0.000179
            [34] => 0.000176
            [35] => 0.000161
            [36] => 0.000193
            [37] => 0.000192
            [38] => 0.000147
            [39] => 0.000184
            [40] => 0.000131
            [41] => 0.000182
            [42] => 0.000195
            [43] => 0.000217
            [44] => 0.000167
            [45] => 0.000169
            [46] => 0.000210
            [47] => 0.000171
            [48] => 0.000182
            [49] => 0.000152
            [50] => 0.000129
            [51] => 0.000154
            [52] => 0.000159
            [53] => 0.000238
            [54] => 0.000616
            [55] => 0.000237
            [56] => 0.000160
            [57] => 0.000197
            [58] => 0.003011
            [59] => 0.000356
            [60] => 0.000160
            [61] => 0.000203
            [62] => 0.000325
            [63] => 0.111328
            [64] => 0.000679
            [65] => 0.000344
            [66] => 0.000251
            [67] => 0.000209
            [68] => 0.000185
            [69] => 0.000200
            [70] => 0.000240
            [71] => 0.000255
            [72] => 0.000233
            [73] => 0.000258
            [74] => 0.000291
            [75] => 0.000835
        )

)

SESSION:
Array
(
    [session_product_listing] => 
)

COOKIE:
Array
(
)
POST:
Array
(
)

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