spain
My Account Cart Contents Checkout
Home »
 
Search in    Quick Find
Receive updates on the latest news and promotions. Sign up to receive our newsletter
E-mail        MaleFemale          Country:  
Manufacturers

Categories
 
 
    

SUBSCRIBE TO NEWSLETTER AND RECEIVE OFFERS AND COUPONS !

Jacket Mod. ARMANI JEANS AJ B6B73AJ-Cam Black
272,00 €
Jacket Mod. ARMANI JEANS AJ B6B29MD-Cam Brown
310,00 €
Jacket Mod. DANIELE ALESSANDRINI I1070S15563407 Black
89,50 €

Hoddie Mod. ARMANI JEANS AJ Z6M71YZ Grey/Scuro
92,50 €
Vestito Mod. ARMANI JEANS AJ V5A28 Blue
95,00 €
Hoddie Mod. DANIELE ALESSANDRINI M5145N6293405 Green
75,50 €

Jacket Mod. DANIELE ALESSANDRINI I1074S15563407 Blue
119,50 €
Jeans Mod. DANIELE ALESSANDRINI PJ5330L583 Denim
71,50 €
Shirt Mod. DANIELE ALESSANDRINI C1512B9243406 Grey/Light
37,50 €

Jacket Mod. DANIELE ALESSANDRINI I90563407 Black
175,50 €
Knitwear Mod. ARMANI JEANS AJ A5022ER Black/Green
60,00 €
Bag Mod. ARMANI JEANS AJ A522CV3 Black
131,50 €

Jacket Mod. DANIELE ALESSANDRINI I1062K1013405 Black
212,00 €
Vestito Mod. ELISABETTA FRANCHI AM1011033110 Black
178,00 €
Boots Mod. GUCCI 355645 Black
495,00 €

Piumino Mod. MARINA YACHTING 420274000000 Argento
395,50 €
Jacket Mod. ARMANI JEANS AJ B6B50EH-Cam Grey
225,50 €
Jacket Mod. ARMANI JEANS AJ A5B15UD White/Black
102,00 €

    
Login
E-Mail Address:

Password:


Sign In
 
Accettiamo PayPal
 
Information
Our Company
Contact Us
Privacy Notice
Conditions of Use
How to buy
Payment
Shipping
 
 
Opzioni aggiuntive
 
Share |
 
 
Presente su TrovaPrezzi Presente su ShoppyDoo
 



Copyright Maranello Web Fashion P. iva 02989250366 © 2005 Tutti i marchi citati appartengono ai loro legittimi proprietari.
Maranello Web Fashion di Bolognesi Enrico e Cattani Giuliano & C. snc P.IVA: 02989250366.
Tel. 0536944200

Powered by GSI Realizzazione siti web
Current Parse Time: 0.574 s with 51 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 = '1' and now() >= expires_date and expires_date > 0
            [6] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0
            [7] => select * from traduzioni
            [8] => select distinct c.categories_tree 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) where p.products_status = '1' and p.products_quantity > 0 
            [9] => select c.categories_id,cd.categories_name from categories c
            inner join categories_description cd on c.categories_id=cd.categories_id
            where c.parent_id = 0 and c.categories_id > 0 and cd.language_id = '5' order by c.sort_order,cd.categories_name
            [10] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Sopra' and btc.categories_id = '-999' and b.banners_id = btc.banners_id
            [11] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Sopra' and btc.categories_id = '0' and b.banners_id = btc.banners_id
            [12] => select countries_id, countries_name from countries order by countries_name
            [13] => select distinct m.manufacturers_id, m.manufacturers_name 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) left join manufacturers m using(manufacturers_id)  where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '5' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_quantity > '0'  order by m.manufacturers_name
            [14] => select distinct c.categories_tree 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) left join manufacturers m using(manufacturers_id) where p.products_status = '1' and  p.products_quantity > '0'  and pd.language_id=5
            [15] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id > 0 and c.categories_id = cd.categories_id and cd.language_id='5' order by sort_order, cd.categories_name
            [16] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'sopra_basso_en' and btc.categories_id = '-999' and b.banners_id = btc.banners_id
            [17] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'sopra_basso_en' and btc.categories_id = '0' and b.banners_id = btc.banners_id
            [18] => select count(*) as count from banners_history where banners_id = '7' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
            [19] => update banners_history set banners_shown = banners_shown + 1 where banners_id = '7' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')
            [20] => select categories_name from categories_description where categories_id = '0' limit 1
            [21] => select p.products_id, p.products_image,pd.products_name,pd.products_description, 
    p.products_tax_class_id, s.status as specstat, 
    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  
    from products p left join specials 
    s on p.products_id = s.products_id left join featured 
    f on p.products_id = f.products_id ,products_description pd
    where 
    p.products_id=pd.products_id and pd.language_id='5' and
    p.products_status = '1' 
    and f.status = '1'  and p.products_quantity > '0' group by p.products_model order by rand(1099046008) DESC limit 18
            [22] => select coupon, specials_new_products_price_gross from specials where products_id = '70536' and status
            [23] => select 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 = '15263') and tr.tax_class_id = '1' group by tr.tax_priority
            [24] => select coupon, specials_new_products_price_gross from specials where products_id = '70534' and status
            [25] => select coupon, specials_new_products_price_gross from specials where products_id = '71912' and status
            [26] => select coupon, specials_new_products_price_gross from specials where products_id = '71237' and status
            [27] => select coupon, specials_new_products_price_gross from specials where products_id = '67757' and status
            [28] => select coupon, specials_new_products_price_gross from specials where products_id = '72193' and status
            [29] => select coupon, specials_new_products_price_gross from specials where products_id = '71935' and status
            [30] => select coupon, specials_new_products_price_gross from specials where products_id = '71996' and status
            [31] => select coupon, specials_new_products_price_gross from specials where products_id = '71850' and status
            [32] => select coupon, specials_new_products_price_gross from specials where products_id = '70717' and status
            [33] => select coupon, specials_new_products_price_gross from specials where products_id = '61634' and status
            [34] => select coupon, specials_new_products_price_gross from specials where products_id = '69102' and status
            [35] => select coupon, specials_new_products_price_gross from specials where products_id = '71898' and status
            [36] => select coupon, specials_new_products_price_gross from specials where products_id = '70140' and status
            [37] => select coupon, specials_new_products_price_gross from specials where products_id = '72441' and status
            [38] => select coupon, specials_new_products_price_gross from specials where products_id = '72448' and status
            [39] => select coupon, specials_new_products_price_gross from specials where products_id = '70537' and status
            [40] => select coupon, specials_new_products_price_gross from specials where products_id = '67742' and status
            [41] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra1' and btc.categories_id = '-999' and b.banners_id = btc.banners_id
            [42] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra1' and btc.categories_id = '0' and b.banners_id = btc.banners_id
            [43] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra2' and btc.categories_id = '-999' and b.banners_id = btc.banners_id
            [44] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra2' and btc.categories_id = '0' and b.banners_id = btc.banners_id
            [45] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra3' and btc.categories_id = '-999' and b.banners_id = btc.banners_id
            [46] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra3' and btc.categories_id = '0' and b.banners_id = btc.banners_id
            [47] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra4' and btc.categories_id = '-999' and b.banners_id = btc.banners_id
            [48] => select b.banners_id, b.banners_title, b.banners_image, b.banners_html_text from banners b, banners_to_categories btc where status = '1' and banners_group = 'Destra4' and btc.categories_id = '0' and b.banners_id = btc.banners_id
            [49] => select startdate, counter from counter
            [50] => update counter set counter = '112348367'
        )

    [TIME] => Array
        (
            [0] => 0.000141
            [1] => 0.000074
            [2] => 0.000091
            [3] => 0.000615
            [4] => 0.000248
            [5] => 0.000329
            [6] => 0.000476
            [7] => 0.000267
            [8] => 0.000108
            [9] => 0.000060
            [10] => 0.000080
            [11] => 0.000047
            [12] => 0.000120
            [13] => 0.468264
            [14] => 0.022398
            [15] => 0.000170
            [16] => 0.000135
            [17] => 0.000083
            [18] => 0.009825
            [19] => 0.008123
            [20] => 0.000109
            [21] => 0.003376
            [22] => 0.000083
            [23] => 0.000090
            [24] => 0.000077
            [25] => 0.000060
            [26] => 0.000125
            [27] => 0.000112
            [28] => 0.000139
            [29] => 0.000068
            [30] => 0.000220
            [31] => 0.000090
            [32] => 0.000078
            [33] => 0.000068
            [34] => 0.000065
            [35] => 0.000076
            [36] => 0.000049
            [37] => 0.000047
            [38] => 0.000090
            [39] => 0.000088
            [40] => 0.000062
            [41] => 0.000076
            [42] => 0.000044
            [43] => 0.000048
            [44] => 0.000036
            [45] => 0.000173
            [46] => 0.000035
            [47] => 0.000040
            [48] => 0.000035
            [49] => 0.000382
            [50] => 0.001417
        )

)

SESSION:

COOKIE:
Array
(
)
POST:
Array
(
)

GET:
Array
(
    [language] => en
    [language=en] => 
)