Porovnanie cien v eshopoch pre RCA378A

-6%

ROMO RCA378A plus

A Supermrazenie 62.9 cm 206.8 cm 59.5 cm 253 kWh 159 l 205 l Výrobník ľadu 39 dB 7.2 kg/24h 2019

od 419.00€

ponúkajú 4 obchody Kde kúpiť

ROMO RCA 378 A++

Bezkonkurenčné ceny, OSOBNÝ ODBER V BRATISLAVE ZDARMA

andreashop.sk

KOMBINOVANÁ CHLADNIČKA S MRAZNIČKOU DOLE. VLASTNOSTI:. A ++ kombinovaná chladnička s mrazničkou dole. Farebné prevedenie: biela. Elektronické ovládanie s LED kontrolkami. Čistý objem chladničky / mrazničky: 205 l / 159 l.

možnosti

skladom
info v obchode

419.00 € 91 %
8551 recenzií Do obchodu andreashop.sk

Odporúčaný zákazníkmi

ROMO RCA 378 A++

andreashop-sala.sk

možnosti

skladom
info v obchode

419.00 € 94 %
1652 recenzií Do obchodu andreashop-sala.sk

ROMO chladnička RCA 378A++

ckdmarket.sk

Kombinovaná chladnička s mrazničkou dole; en. trieda A ++; klimatická trieda N-ST; hlučnosť 39 dB; farebné prevedenie: biele; celkový hrubý / čistý objem: 378 l / 364 l; možnosť zmeny smeru otvárania dverí; elektronické riadenie teploty; Soft Touch ovládanie s LED ukazovateľmi; zvuková signalizácia viac..

možnosti

info v obchode
info v obchode

449.00 € 97 %
1057 recenzií Do obchodu ckdmarket.sk

Odporúčaný zákazníkmi

ROMO RCA378A++

mall.sk

možnosti

skladom
doprava zdarma

450.00 € 33 %
287 recenzií Do obchodu mall.sk

ROMO Chladnička <em>RCA 378A++</em> kombinovaná + DARČEK

ROMO Chladnička RCA 378A++ kombinovaná + DARČEK

elmaxshop.sk

Největší mrazák na trhu 159 l, 378 l, kombinovaná, A++, 207 cm, hlučnost 39 dB

možnosti

je skladem
od 3.95 €

489.00 € 96 %
196 recenzií Do obchodu elmaxshop.sk

ROMO RCA378A++

elektrosahul.eu

možnosti

dodanie do 7 dn
info v obchode

529.00 € 100 %
12 recenzií Do obchodu elektrosahul.eu

Thread id: 538
14.12.2019 15:28:13.109     +0ms s: Application_BeginRequest 
14.12.2019 15:28:13.109     +0ms     s: GetDataFromDb: 
SELECT * FROM (
  SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM (
    SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match'
    UNION ALL
    SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match'
  ) a) b
/*WHERE poradie=1*/
@searchPhraseUpper : "RCA378A"
@searchPhraseLower : "rca378a" 
14.12.2019 15:28:13.111     +2ms     f: GetDataFromDb: 
SELECT * FROM (
  SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM (
    SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match'
    UNION ALL
    SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match'
  ) a) b
/*WHERE poradie=1*/
@searchPhraseUpper : "RCA378A"
@searchPhraseLower : "rca378a" execute: NO, render: 2ms 
14.12.2019 15:28:13.111     +0ms     s: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains)
@contains : ("RCA378A*") 
14.12.2019 15:28:13.112     +1ms     f: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains)
@contains : ("RCA378A*") execute: NO, render: 0ms 
14.12.2019 15:28:13.116     +4ms     s: SearchResults:_GetSearchResults 
14.12.2019 15:28:13.117     +1ms         s: DUPL GetDataFromDb: 
SELECT * FROM (
  SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM (
    SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match'
    UNION ALL
    SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match'
  ) a) b
/*WHERE poradie=1*/
@searchPhraseUpper : "RCA378A"
@searchPhraseLower : "rca378a" 
14.12.2019 15:28:13.118     +1ms         f: GetDataFromDb: 
SELECT * FROM (
  SELECT *, ROW_NUMBER() OVER(PARTITION BY probe, occurrence ORDER BY probe, occurrence) poradie FROM (
    SELECT 0 as probe, occurrence, UPPER(display_term) display_term FROM sys.dm_fts_parser (@searchPhraseUpper, 1051, null, 0) WHERE special_term='Exact Match'
    UNION ALL
    SELECT 1 as probe, occurrence, display_term FROM sys.dm_fts_parser (@searchPhraseLower, 1051, null, 0) WHERE special_term='Exact Match'
  ) a) b
/*WHERE poradie=1*/
@searchPhraseUpper : "RCA378A"
@searchPhraseLower : "rca378a" execute: NO, render: 1ms 
14.12.2019 15:28:13.123     +5ms         s: GetDataFromDb:
select w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, 
  w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, 
  (case when w.aktivny=0 and a.ppc_platic=0 then '' else w.dostupnost end) as dostupnost, 
  a.handleAsVipPartner, 
  (case when a.handleAsVipPartner = 0 then 0 else isnull(a.viptextmode,0)+1 end) vipprogram,
  a.produkt_id, w.load_vysl, w.load_vyrobca_id, 
  (case when load_produkt_id is null then 0 else ISNULL(a.current_bids,0) END) as pocet_ponuk,
  (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane,
  w.pict, w.popis, '' as pictPath, a.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, 
  a.kategoria_id, w.priradena_kategoria_id , w.aktivny, a.ppc_platic
from web_searches_tdatas w with(nolock) join (
SELECT TOP 5000 w.web_search_tdata_id, p.produkt_id, p.kategoria_id, p.nazov, w.web_id, 
  we.handleAsVipPartner, we.viptextmode, h.current_bids, we.ppc_platic
  FROM CONTAINSTABLE(web_searches_tdatas, (produkt_fulltext_2018), @contains) ft 
  INNER JOIN najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) on ft.[key] = w.web_search_tdata_id
    JOIN najnakup_svk_remote.dbo.a_webs we WITH (NOLOCK) ON we.web_id=w.web_id    
    LEFT OUTER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id
    LEFT OUTER JOIN najnakup_svk_remote.dbo.a_produkty_history h WITH (NOLOCK) ON h.produkt_id=p.produkt_id
    
          ORDER BY ft.[key]

        ) a on w.web_search_tdata_id=a.web_search_tdata_id
        ORDER BY a.handleAsVipPartner desc, pocet_ponuk DESC, w.cena ASC, vipprogram desc
@contains : ("RCA378A") AND "active_1" 
14.12.2019 15:28:13.369   +246ms         f: GetDataFromDb:
select w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, w.gift, 
  w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, 
  (case when w.aktivny=0 and a.ppc_platic=0 then '' else w.dostupnost end) as dostupnost, 
  a.handleAsVipPartner, 
  (case when a.handleAsVipPartner = 0 then 0 else isnull(a.viptextmode,0)+1 end) vipprogram,
  a.produkt_id, w.load_vysl, w.load_vyrobca_id, 
  (case when load_produkt_id is null then 0 else ISNULL(a.current_bids,0) END) as pocet_ponuk,
  (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane,
  w.pict, w.popis, '' as pictPath, a.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, 
  a.kategoria_id, w.priradena_kategoria_id , w.aktivny, a.ppc_platic
from web_searches_tdatas w with(nolock) join (
SELECT TOP 5000 w.web_search_tdata_id, p.produkt_id, p.kategoria_id, p.nazov, w.web_id, 
  we.handleAsVipPartner, we.viptextmode, h.current_bids, we.ppc_platic
  FROM CONTAINSTABLE(web_searches_tdatas, (produkt_fulltext_2018), @contains) ft 
  INNER JOIN najnakup.dbo.web_searches_tdatas w WITH (NOLOCK) on ft.[key] = w.web_search_tdata_id
    JOIN najnakup_svk_remote.dbo.a_webs we WITH (NOLOCK) ON we.web_id=w.web_id    
    LEFT OUTER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id
    LEFT OUTER JOIN najnakup_svk_remote.dbo.a_produkty_history h WITH (NOLOCK) ON h.produkt_id=p.produkt_id
    
          ORDER BY ft.[key]

        ) a on w.web_search_tdata_id=a.web_search_tdata_id
        ORDER BY a.handleAsVipPartner desc, pocet_ponuk DESC, w.cena ASC, vipprogram desc
@contains : ("RCA378A") AND "active_1" execute: NO, render: 245ms 
14.12.2019 15:28:13.380    +11ms         s: GetDataFromDb:
SELECT TOP 1000 w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, 
  w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, 
  (case when w.aktivny=1 then w.dostupnost else '' end) as dostupnost, 
  (case when we.handleAsVipPartner = 0 then 0 else isnull(we.viptextmode,0)+1 end) vipprogram, we.handleAsVipPartner, 
  p.produkt_id, w.load_vysl, w.load_vyrobca_id, 
  (case when load_produkt_id is null then 0 else ISNULL(h.current_bids,0) END) as pocet_ponuk,
  (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane,
    w.pict, w.popis, '' as pictPath, p.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, p.kategoria_id, 
    null as priradena_kategoria_id, w.aktivny, we.ppc_platic
FROM najnakup.dbo.web_searches_tdatas w WITH (NOLOCK)
  INNER JOIN a_webs we WITH (NOLOCK) ON we.web_id=w.web_id
  INNER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id
    LEFT OUTER JOIN a_produkty_history h WITH (NOLOCK) on h.produkt_id=p.produkt_id
WHERE (w.aktivny=1 /*or (w.aktivny=0 and we.ppc_platic=0)*/) AND w.load_produkt_id in (3459045) and w.load_vysl=0 AND w.web_search_tdata_id not in (136981974,136883416,150091210,139120318,123971014,131055293)  
14.12.2019 15:28:13.478    +98ms         f: GetDataFromDb:
SELECT TOP 1000 w.web_search_tdata_id, w.produkt, w.vyrobca_kod, w.vyrobca_kod1, w.load_produkt_id, w.cena, w.cpc, 
  w.gift, w.dopravne, w.hyperlinktarget, w.hyperlinktarget as hl, w.web_id, 
  (case when w.aktivny=1 then w.dostupnost else '' end) as dostupnost, 
  (case when we.handleAsVipPartner = 0 then 0 else isnull(we.viptextmode,0)+1 end) vipprogram, we.handleAsVipPartner, 
  p.produkt_id, w.load_vysl, w.load_vyrobca_id, 
  (case when load_produkt_id is null then 0 else ISNULL(h.current_bids,0) END) as pocet_ponuk,
  (case when load_vysl is not null AND load_vysl = 0 then 1 else 0 END) as sparovane,
    w.pict, w.popis, '' as pictPath, p.nazov nas_nazov, 0 body_zhody, 0 product_visits, 0 category_visits, p.kategoria_id, 
    null as priradena_kategoria_id, w.aktivny, we.ppc_platic
FROM najnakup.dbo.web_searches_tdatas w WITH (NOLOCK)
  INNER JOIN a_webs we WITH (NOLOCK) ON we.web_id=w.web_id
  INNER JOIN najnakup.dbo.produkty p WITH (NOLOCK) ON w.load_produkt_id = p.produkt_id
    LEFT OUTER JOIN a_produkty_history h WITH (NOLOCK) on h.produkt_id=p.produkt_id
WHERE (w.aktivny=1 /*or (w.aktivny=0 and we.ppc_platic=0)*/) AND w.load_produkt_id in (3459045) and w.load_vysl=0 AND w.web_search_tdata_id not in (136981974,136883416,150091210,139120318,123971014,131055293)  execute: NO, render: 97ms 
14.12.2019 15:28:13.483     +5ms         s: CustomCode:CatController_sub.GetCatData 
14.12.2019 15:28:13.510    +27ms             s: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (3459045) and key2=1 
14.12.2019 15:28:13.515     +5ms             f: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (3459045) and key2=1 execute: NO, render: 4ms 
14.12.2019 15:28:13.516     +1ms         f: CustomCode:CatController_sub.GetCatData execute: NO, render: 32ms 
14.12.2019 15:28:13.521     +5ms         s: Product_Offers:Get_Grid_item 
14.12.2019 15:28:13.522     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
14.12.2019 15:28:13.522     +0ms         s: Product_Offers:Get_Grid_item 
14.12.2019 15:28:13.523     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
14.12.2019 15:28:13.523     +0ms         s: Product_Offers:Get_Grid_item 
14.12.2019 15:28:13.523     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
14.12.2019 15:28:13.524     +1ms         s: Product_Offers:Get_Grid_item 
14.12.2019 15:28:13.524     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
14.12.2019 15:28:13.525     +1ms         s: Product_Offers:Get_Grid_item 
14.12.2019 15:28:13.525     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
14.12.2019 15:28:13.525     +0ms         s: Product_Offers:Get_Grid_item 
14.12.2019 15:28:13.526     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
14.12.2019 15:28:13.527     +1ms         s: UserLoginContent:GetUserLoginContentData 
14.12.2019 15:28:13.527     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms 
14.12.2019 15:28:13.527     +0ms         s: Schranka:LoadFooter_VisitedProducts 
14.12.2019 15:28:13.528     +1ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms 
14.12.2019 15:28:13.528     +0ms     f: SearchResults:_GetSearchResults execute: 409ms, render: 2ms 