Porovnanie cien v eshopoch pre RCA378A

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 449.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

449.00 € 91 %
8499 recenzií Do obchodu andreashop.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 %
1057 recenzií Do obchodu ckdmarket.sk

Odporúčaný zákazníkmi

ROMO RCA 378 A++

andreashop-sala.sk

možnosti

skladom
info v obchode

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

ROMO RCA378A++

mall.sk

možnosti

skladom
doprava zdarma

450.00 € 33 %
285 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 %
195 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: 145
09.12.2019 04:40:44.847     +0ms s: Application_BeginRequest 
09.12.2019 04:40:44.847     +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" 
09.12.2019 04:40:44.869    +22ms     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: 22ms 
09.12.2019 04:40:44.869     +0ms     s: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains)
@contains : ("RCA378A*") 
09.12.2019 04:40:44.903    +34ms     f: GetDataFromDb:select [key] from containstable(keywords, keyword, @contains)
@contains : ("RCA378A*") execute: NO, render: 34ms 
09.12.2019 04:40:44.906     +3ms     s: SearchResults:_GetSearchResults 
09.12.2019 04:40:44.906     +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" 
09.12.2019 04:40:44.913     +7ms         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: 6ms 
09.12.2019 04:40:44.949    +36ms         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" 
09.12.2019 04:40:45.075   +126ms         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: 125ms 
09.12.2019 04:40:45.076     +1ms         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,150091210,136883416,139120318,123971014,131055293)  
09.12.2019 04:40:45.135    +59ms         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,150091210,136883416,139120318,123971014,131055293)  execute: NO, render: 58ms 
09.12.2019 04:40:45.139     +4ms         s: CustomCode:CatController_sub.GetCatData 
09.12.2019 04:40:45.158    +19ms             s: GetDataFromDb:SELECT thumb2, img_type, key1 from najnakup_images.dbo.images WITH (NOLOCK) WHERE type=1 and key1 in (3459045) and key2=1 
09.12.2019 04:40:45.167     +9ms             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: 9ms 
09.12.2019 04:40:45.168     +1ms         f: CustomCode:CatController_sub.GetCatData execute: NO, render: 29ms 
09.12.2019 04:40:45.172     +4ms         s: Product_Offers:Get_Grid_item 
09.12.2019 04:40:45.172     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
09.12.2019 04:40:45.173     +1ms         s: Product_Offers:Get_Grid_item 
09.12.2019 04:40:45.173     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
09.12.2019 04:40:45.173     +0ms         s: Product_Offers:Get_Grid_item 
09.12.2019 04:40:45.173     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
09.12.2019 04:40:45.174     +1ms         s: Product_Offers:Get_Grid_item 
09.12.2019 04:40:45.174     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
09.12.2019 04:40:45.174     +0ms         s: Product_Offers:Get_Grid_item 
09.12.2019 04:40:45.174     +0ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 0ms 
09.12.2019 04:40:45.174     +0ms         s: Product_Offers:Get_Grid_item 
09.12.2019 04:40:45.175     +1ms         f: Product_Offers:Get_Grid_item execute: 0ms, render: 1ms 
09.12.2019 04:40:45.176     +1ms         s: UserLoginContent:GetUserLoginContentData 
09.12.2019 04:40:45.176     +0ms         f: UserLoginContent:GetUserLoginContentData execute: 0ms, render: 0ms 
09.12.2019 04:40:45.176     +0ms         s: Schranka:LoadFooter_VisitedProducts 
09.12.2019 04:40:45.176     +0ms         f: Schranka:LoadFooter_VisitedProducts execute: 0ms, render: 0ms 
09.12.2019 04:40:45.176     +0ms     f: SearchResults:_GetSearchResults execute: 269ms, render: 1ms 