Porovnanie cien v eshopoch pre RCA378A

-13%

ROMO RCA378A plus

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

od 390.00€

ponúkajú 4 obchody Kde kúpiť

ROMO Chladnička RCE 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 2.95 €

390.00 € 96 %
217 recenzií Do obchodu elmaxshop.sk

Odporúčaný zákazníkmi

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 %
1075 recenzií Do obchodu ckdmarket.sk

Odporúčaný zákazníkmi

ROMO RCA378A++

mall.sk

možnosti

skladom
doprava zdarma

450.00 € 31 %
311 recenzií Do obchodu mall.sk

ROMO Kombinovaná chladnička s mrazničkou dole <em>RCA378A,</em> A++

ROMO Kombinovaná chladnička s mrazničkou dole RCA378A, A++

okay.sk

Nízkoteplotná Fresh zóna FRESH ZÓNA vám umožňuje dlhšie skladovať mäso, ryby a pod. Prídavný výparník, ktorý nájdete za touto zónou zabezpečuje teplotu medzi 0 °C až +3 °C. Zásuvka sa pohodlne vysúva vďaka teleskopickým koľajničkám a navyše možno zásuvku otvoriť alebo aj vybrať už pri otvorení viac..

možnosti

skladom
doprava zdarma

450.00 € Do obchodu okay.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

na otázku
doprava zdarma

529.00 € 96 %
217 recenzií Do obchodu elmaxshop.sk

Odporúčaný zákazníkmi

ROMO RCA378A++

elektrosahul.eu

možnosti

dodanie do 7 dn
info v obchode

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

Thread id: 2006
02.07.2020 18:17:37.377     +0ms s: Application_BeginRequest 
02.07.2020 18:17:37.377     +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" 
02.07.2020 18:17:37.379     +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: 1ms 
02.07.2020 18:17:37.379     +0ms     s: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains)
@contains : ("RCA378A*") 
02.07.2020 18:17:37.381     +2ms     f: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains)
@contains : ("RCA378A*") execute: NO, render: 1ms 
02.07.2020 18:17:37.385     +4ms     s: SearchResults:_GetSearchResults 
02.07.2020 18:17:37.385     +0ms         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" 
02.07.2020 18:17:37.386     +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 
02.07.2020 18:17:37.390     +4ms         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" 
02.07.2020 18:17:37.466    +76ms         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: 76ms 
02.07.2020 18:17:37.469     +3ms         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 : "4811159048067"
@searchPhraseLower : "4811159048067" 
02.07.2020 18:17:37.471     +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 : "4811159048067"
@searchPhraseLower : "4811159048067" execute: NO, render: 1ms 
02.07.2020 18:17:37.471     +0ms         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 1000 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 : (("4811159048067" OR "-4811159048067")) AND "active_1" 
02.07.2020 18:17:37.537    +66ms         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 1000 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 : (("4811159048067" OR "-4811159048067")) AND "active_1" execute: NO, render: 65ms 
02.07.2020 18:17:37.537     +0ms         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 (150091210,156425372,139120318,123971014,131055293)  
02.07.2020 18:17:37.593    +56ms         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 (150091210,156425372,139120318,123971014,131055293)  execute: NO, render: 56ms 
02.07.2020 18:17:37.601     +8ms         s: CustomCode:CatController_sub.GetCatData 
02.07.2020 18:17:37.629    +28ms             s: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (3459045) and key2=1 
02.07.2020 18:17:37.635     +6ms             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: 5ms 
02.07.2020 18:17:37.636     +1ms         f: CustomCode:CatController_sub.GetCatData execute: NO, render: 34ms 
02.07.2020 18:17:37.642     +6ms         s: Product_Offers:Get_Grid_item 
02.07.2020 18:17:37.643     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
02.07.2020 18:17:37.643     +0ms         s: Product_Offers:Get_Grid_item 
02.07.2020 18:17:37.644     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
02.07.2020 18:17:37.644     +0ms         s: Product_Offers:Get_Grid_item 
02.07.2020 18:17:37.645     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
02.07.2020 18:17:37.645     +0ms         s: Product_Offers:Get_Grid_item 
02.07.2020 18:17:37.645     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
02.07.2020 18:17:37.646     +1ms         s: Product_Offers:Get_Grid_item 
02.07.2020 18:17:37.646     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
02.07.2020 18:17:37.647     +1ms         s: Product_Offers:Get_Grid_item 
02.07.2020 18:17:37.647     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
02.07.2020 18:17:37.648     +1ms         s: UserLoginContent:GetUserLoginContentData 
02.07.2020 18:17:37.648     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms 
02.07.2020 18:17:37.649     +1ms         s: Schranka:LoadFooter_VisitedProducts 
02.07.2020 18:17:37.649     +0ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms 
02.07.2020 18:17:37.649     +0ms     f: SearchResults:_GetSearchResults execute: 262ms, render: 2ms 