select /*getOffers*/ distinct sa.mi_id, sa.id, o.offer_id, sa.id as saved_id, sa.id orig_id
                , IFNULL(master_sa.id, sa.id) master_sa
                , IFNULL(master_sa.saved_group_id, sa.saved_group_id) saved_group_id
                , IFNULL(master_sa.saved_group_ordering, sa.saved_group_ordering) saved_group_ordering
                , 0 as visits
                , shop_rating_cache.avg*100 rated
                , IFNULL(master_sa.id,sa.id) ifnullmastersa
                , IFNULL(sa.master_ShopSAAlias,1) master_ShopSAAlias
                , IFNULL(sa.master_ShopDesription,1) master_ShopDesription
                , IFNULL(sa.master_descriptionShop,1) master_descriptionShop
                , IFNULL(sa.master_descriptionTextShop,1) master_descriptionTextShop
                , IFNULL(sa.master_pics,1) master_pics
                , IFNULL(sa.master_banner,1) master_banner
                , IFNULL(sa.master_sims,1) master_sims
                , IFNULL(sa.master_others,1) master_others
                , IFNULL(sa.master_ShopSAKeywords,1) master_ShopSAKeywords
                , IFNULL(sa.master_ShopShortTitle,1) master_ShopShortTitle
                , IFNULL(sa.master_icons,1) master_icons
                , IFNULL(sa.master_amazon,1) master_amazon
                , max(sa.shop_catalogue_id) cat_id
                , alias.name ShopDescription
                , sa.ShopHPrice  as ShopHPrice
                , sa.ShopMinusPercent
                , sa.ShopShortDescription
                , sa.ShopPrice  as ShopPrice
                , (0 ) as fake_free_shipping
                , alias.name alias
                , o.name offer_name
                , IFNULL(tShopSAAlias.value, tShopSAAlias_default.value) ShopSAAlias
                , IFNULL(tShopShortTitle.value, tShopShortTitle_default.value) ShopShortTitle
                , orig_o.offer_id orig_offer_id
                , orig_o.available
                , orig_o.available_weeks
                , orig_o.available_date
                , IF(orig_o.available
                    , ' ja'
                    ,IF(orig_o.available_weeks
                        , CONCAT('Leverbaar vanaf:', ' ', DATE(date_add(NOW(), INTERVAL orig_o.available_weeks week)))
                        , IF(orig_o.available_date='0000-00-00'
                            , ' nee'
                            , CONCAT('Leverbaar vanaf:',' ', orig_o.available_date)
                        )
                    )
                ) available_text
                #, sa.details
                , sa.ShopShippingCharge
                , o.sshipping_plan_free
                , sa.siteid
                , IF(IF(0, 1, IFNULL(tsshipping_plan_free_tr.value,0)), 0, spc.shipping_cost) as shipping_cost

                , (select translation.value from translation
                    join saved_doc on saved_doc.doc_id=translation.id
                            where translation.language='german'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '1594' 
                            and saved_doc.saved_id=58757 order by saved_doc.primary desc limit 1) alt
                , (select translation.value from translation
                    join saved_doc on saved_doc.doc_id=translation.id
                            where translation.language='german'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '121' 
                            and saved_doc.saved_id=58757 order by saved_doc.primary desc limit 1) title
                , (SELECT group_concat(concat(al.article_id,':',al.default_quantity,':',a.weight_per_single_unit))
                    FROM article_list al
                    JOIN offer_group og ON al.group_id = og.offer_group_id and base_group_id=0
                    join article a on a.article_id=al.article_id and a.admin_id=0
                    WHERE og.offer_id = 80221 and al.inactive=0 and og.additional=0) als                

            from sa17 sa
            left join sa_all master_sa on sa.master_sa=master_sa.id
            join offer o on o.offer_id=IFNULL(master_sa.offer_id, sa.offer_id)
            left join offer orig_o on orig_o.offer_id=sa.offer_id
            join translation t1 on 
                t1.id=47 
                AND  `t1`.`table_name_id` = '887'  
                AND  `t1`.`field_name_id` = '5575' 
                and t1.language='dutch'
            left join translation t2 on 
                t2.id=(57-orig_o.available)
                AND  `t2`.`table_name_id` = '887'  
                AND  `t2`.`field_name_id` = '5575' 
                and t2.language='dutch'
            left join translation tShopDesription on tShopDesription.id=IF(IFNULL(sa.master_ShopDesription,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopDesription`.`table_name_id` = '411'  
                AND  `tShopDesription`.`field_name_id` = '1678' 
                and tShopDesription.language = 'dutch'
            left join translation tShopDesription_default on tShopDesription_default.id=IF(IFNULL(sa.master_ShopDesription,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopDesription_default`.`table_name_id` = '411'  
                AND  `tShopDesription_default`.`field_name_id` = '1678' 
                and tShopDesription_default.language = 'dutch'
            join offer_name alias on IFNULL(tShopDesription.value, tShopDesription_default.value)=alias.id
            left join translation tShopSAAlias on tShopSAAlias.id=IF(IFNULL(sa.master_ShopSAAlias,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopSAAlias`.`table_name_id` = '411'  
                AND  `tShopSAAlias`.`field_name_id` = '5550' 
                and tShopSAAlias.language = 'dutch'
            left join translation tShopSAAlias_default on tShopSAAlias_default.id=IF(IFNULL(sa.master_ShopSAAlias,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopSAAlias_default`.`table_name_id` = '411'  
                AND  `tShopSAAlias_default`.`field_name_id` = '5550' 
                and tShopSAAlias_default.language = 'dutch'
            left join translation tShopShortTitle on tShopShortTitle.id=IF(IFNULL(sa.master_ShopShortTitle,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopShortTitle`.`table_name_id` = '411'  
                AND  `tShopShortTitle`.`field_name_id` = '5553' 
                and tShopShortTitle.language = 'dutch'
            left join translation tShopShortTitle_default on tShopShortTitle_default.id=IF(IFNULL(sa.master_ShopShortTitle,1),IFNULL(master_sa.id, sa.id), sa.id)
                AND  `tShopShortTitle_default`.`table_name_id` = '411'  
                AND  `tShopShortTitle_default`.`field_name_id` = '5553' 
                and tShopShortTitle_default.language = 'dutch'
            left join translation tsshipping_plan_free_tr
                on tsshipping_plan_free_tr.language=sa.siteid
                and tsshipping_plan_free_tr.id=orig_o.offer_id
                AND  `tsshipping_plan_free_tr`.`table_name_id` = '285'  
                AND  `tsshipping_plan_free_tr`.`field_name_id` = '5557' 
            join translation tsshipping_plan_id
                on tsshipping_plan_id.language=sa.siteid
                and tsshipping_plan_id.id=orig_o.offer_id
                AND  `tsshipping_plan_id`.`table_name_id` = '285'  
                AND  `tsshipping_plan_id`.`field_name_id` = '5558' 
            join shipping_plan_country spc on spc.shipping_plan_id=tsshipping_plan_id.value
            join config_api_values cav on cav.par_id=5 and cav.value=sa.siteid
            join country c on c.code=spc.country_code and c.name=REPLACE(cav.description,'United Kingdom','UK')
            left join shop_rating_cache on shop_rating_cache.shop_id=1 and shop_rating_cache.saved_id=sa.id
                    WHERE tShopSAAlias.value != ''
                        AND sa.username='Beliani NL'
                        AND sa.siteid='146'
                        AND NOT o.hidden 
                        AND IFNULL(sa.old,0)=0
                        AND sa.id>0
                        AND sa.shop_catalogue_id IN (1685)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
NIEUW | Koop nu online en betaal later. Gratis bezorging en retourneren
Prijs
Gesorteerd op
Achtergrond foto's
Bekijken:

Bed gestoffeerd met lattenbodem verschillende groottes VIENNE

Hanglamp zwart THAMES II

Hanglamp wit 50 cm MUSONE

Tafellamp wit 30 cm MUSONE

Dekbed Japara katoen verschillende groottes RIMO

Hoekbank gestoffeerd ochtgrijs NORREA

Tapijt zwart-wit verschillende groottes DAFNI

Hoekbank gestoffeerd grijs NORREA

Dekbed katoen verschillende groottes KABRU

2-Zits bank gestoffeerd zwart KUOPIO

3-Zits bank gestoffeerd zwart KUOPIO

2-Zits bank gestoffeerd grijs gemeleerd KUOPIO

3-Zits bank gestoffeerd grijs gemeleerd KUOPIO

2-Zits bank gestoffeerd pastelgroen KUOPIO

3-Zits bank gestoffeerd pastelgroen KUOPIO

2-Zits bank gestoffeerd fuchsia KUOPIO

3-Zits bank gestoffeerd fuchsia KUOPIO

2-Zits bank gestoffeerd rood KUOPIO

3-Zits bank gestoffeerd rood KUOPIO

Hoekbank gestoffeerd beige NORREA

Hanglamp koper/zwart TRESA

Hanglamp glas zilver SESSERA

Hanglamp zilver BRADANO

Hanglamp zilver MUCONE

Hanglamp koper MAGRA

Hanglamp zwart CONCA

Hanglamp wit RUBICON

Kroonluchter glas zilver LOCONE

Hanglamp glas zilver NURE

Hanglamp glas zilver ORBA

Hanglamp glas zilver SANGONE

Dekbed katoen verschillende groottes KABRU

Loungeset aluminium wit 4-zits kussen grijs POSITANO

Bijzettafel grijs 1 lade MONROE

Bijzettafel wit 1 lade MONROE

Barkruk wit - kruk - krukje - opstapje - 42x42x76 cm - CABRILLO

Fauteuil gestoffeerd blauw KOUKI

Fauteuil gestoffeerd geel KOUKI

Fauteuil gestoffeerd lichtgrijs KOUKI

Kruk geel-goud - zithocker - kruk - barkruk - 40x40x60 cm - CABRILLO

Bed gestoffeerd lichtgrijs met lattenbodem verschillende groottes LIFFRE

Boekenkast zwart 4 vakken FOSTER

Hanglamp zwart / koper FUCINO

Hocker grijs MANTEO

Zitbank met deksel marineblauw MICHIGAN

Hocker pastelmunt KANSAS

Hocker met deksel roze/wit TUNICA

Kast wit MOBILE DUO

Slaapbank stoffen bekleding beige HALTI

Slaapbank stoffen bekleding mint HALTI

Slaapbank stoffen bekleding lichtbruin HALTI

Kast wit MOBILE SOLO

Slaapbank gestoffeerd roze BELFAST

Slaapbank gestoffeerd roze EXETER

Balkonmeubelset - bistroset - tuinset - met grijs/beige kussens - FIJI

Tafellamp zilver 53 cm TENNA

Staande lamp zilver 160 cm TENNA

Houten bed wit met lattenbodem verschillende groottes OLIVET

Commode wit SHARON

Commode wit EVERETT

Gestoffeerd bed grijs lattenbodem verschillende groottes SENNEZ

Salontafel bruin LOGAN

Salontafel bruin BOLTON

TV meubel bruin CARLISLE

Nachtkastje bruin 3 schuiflades CLIFTON

Nachtkast bruin 3 lades LINDEN

Nachtkastje bruin 1 schuiflade DENVILLE

Dressoir bruin 3 lades BYRAM

Nachtkastje bruin 2 schuiflades RANDOLPH

Nachtkastje bruin 3 laeds WINDSOR

Hanglamp zwart TORDINO

Hanglamp goud TORDINO

Dressoir bruin 1 lade HARDWICK

Hanglamp zwart MAZARO

Hanglamp koper MAZARO

Hanglamp koper GIONA

Hanglamp zwart GIONA

Eetkamerstoel wit 2 stuks APOLLO

Eetkamerstoel wit/licht 2 stuks APOLLO

Eetkamerstoel zwart 2 stuks APOLLO

Eetkamerstoel donkerbruin 2 stuks APOLLO

* Alle prijzen incl. BTW en verzendkosten

PROFITEER VAN ONZE

exclusieve kortingen