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
                    , 'In stock'
                    ,IF(orig_o.available_weeks
                        , CONCAT('Available from:', ' ', DATE(date_add(NOW(), INTERVAL orig_o.available_weeks week)))
                        , IF(orig_o.available_date='0000-00-00'
                            , 'Out of stock'
                            , CONCAT('Available from:',' ', 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='english'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '1594' 
                            and saved_doc.saved_id=IFNULL(master_sa.id, sa.id) 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='english'
                            AND  `translation`.`table_name_id` = '508'  
                            AND  `translation`.`field_name_id` = '121' 
                            and saved_doc.saved_id=IFNULL(master_sa.id, sa.id) 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 = o.offer_id and al.inactive=0 and og.additional=0) als                 

            from sa2 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='english'
            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='english'
            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 = 'english'
            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 = 'english'
            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 = 'english'
            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 = 'english'
            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 = 'english'
            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 = 'english'
            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 UK'
                        AND sa.siteid='3'
                        AND NOT o.hidden 
                        AND IFNULL(sa.old,0)=0
                        AND sa.id>0
                        AND sa.shop_catalogue_id IN (1703)
                    GROUP BY sa.id
                    ORDER BY IFNULL(sa.shopspos_cat*1,999)
Modern Garden Tables | Beliani.co.uk
Colour
Material
Length
Sort by:
Show:

Garden Bistro Set for 2 Lime Green FIORI

159.00
FREE shipping, available now

Garden Bistro Set for 2 Grey FIORI

159.00
FREE shipping, available now

Garden Bistro Set for 2 Blue FIORI

159.00
FREE shipping, available now
(5)
5 stars
(5)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Bistro Set for 2 White FIORI

159.00
FREE shipping, available now
(5)
5 stars
(5)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Bistro Set for 2 Taupe FIORI

159.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Sectional Outdoor Sofa Set - 4- Piece Patio Conversation Set - White and Grey - VINCI

1,239.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Outdoor Dining Table - Rattan - Round - 150 cm - NAPLES

529.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

White Wooden Garden Bistro Set with Zigzag Cushions FIJI

239.00
FREE shipping, available now

Garden Bistro Set with Blue-white Cushions FIJI

199.00
FREE shipping, available now

White Wooden Garden Bistro Set with Grey-Beige Cushions FIJI

239.00
FREE shipping, available now

Garden Bistro Set with Grey-beige Cushions FIJI

199.00
FREE shipping, available now

White Wooden Garden Bistro Set with Yellow Cushions FIJI

239.00
FREE shipping, available now

Garden Bistro Set with Yellow Cushions FIJI

199.00
FREE shipping, available now

Garden Sofa Set - Patio Set - Rattan - 4 Seater Sofa Set - MARSALA

529.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Sofa Set - Patio Set - Rattan - 4 Seater Sofa Set - LUCA

899.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table and Chairs - Dining Set - 6 Seater - Grey Granite - Brown Chairs - TORINO

1,159.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Light Brown Wooden Extending Garden Table 160/220 x 100 cm MAUI

469.00
FREE shipping, available now

8 Seater Wooden Garden Table and Chairs MAUI

999.00
FREE shipping, available now

Garden Table and Chairs - Dining Set - 6 Seater - Polished Black Granite - Brown Chairs - TORINO

1,159.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table and Chairs - Dining Set - 6 Seater - Flamed Black Granite - Brown Chairs - TORINO

1,159.00
FREE shipping, available from 2018-05-28

Garden Table - Dining Table - Grey Polished Granite - 180 cm - TORINO

839.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

2 Seater Bistro Set White ACAPULCO

259.00
FREE shipping, available now
(4)
5 stars
(4)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

2 Seater Bistro Set Light Grey ACAPULCO

259.00
FREE shipping, available now

2 Seater Bistro Set Brown ACAPULCO

259.00
FREE shipping, available now

2 Seater Bistro Set Green ACAPULCO

259.00
FREE shipping, available now
(5)
5 stars
(5)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

2 Seater Bistro Set Orange ACAPULCO

259.00
FREE shipping, available now
(7)
5 stars
(6)
4 stars
(1)
3 stars
(0)
2 stars
(0)
1 star
(0)

2 Seater Bistro Set Blue ACAPULCO

259.00
FREE shipping, available now
(4)
5 stars
(4)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Dining Table - Black Polished Granite - 180 cm - TORINO

839.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Dining Table - Black Flamed Granite - 180 cm - TORINO

839.00
FREE shipping, available from 2018-05-28

4 Piece Conversation Set White BALTIC

1,199.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Outdoor Dining Table - Aluminum - 95x95 cm - Brown - PRATO

349.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Steel Garden Table 80x80 cm - Black LIVO

199.00
FREE shipping, available now

Steel Garden Table 140x180 - Black LIVO

309.00
FREE shipping, available now

Garden Table - Outdoor Dining Table - Aluminum - 150x90 cm - Brown - COMO

389.00
FREE shipping, available now

Garden Set - Dining Set - 2 Benches - 8 Seater - White and Brown - SCANIA

699.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Rattan Dining Table - Wicker Table with Glass Top - 160 cm - ITALY

359.00
FREE shipping, available now

Rattan Garden Dining Table - Wicker Outdoor - Glass Top 220 cm - ITALY

479.00
FREE shipping, available now
(4)
5 stars
(4)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Outdoor Dining Table - Rattan - 220 cm - White - ITALY

499.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Set - Dining Set - 2 Benches - 8 Seater - Black and Brown - SCANIA

699.00
FREE shipping, available now

Dining Table - Garden Table - Extending - JAVA

519.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Aluminium Garden Table - 160cm - Outdoor Furniture - Black - CATANIA

249.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Aluminium Garden Table - 160cm - Outdoor Furniture - White - CATANIA

249.00
FREE shipping, available now
(4)
5 stars
(3)
4 stars
(1)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden table acacia wood - rectangular table, extendable - JAVA

409.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Dining Table 200x90 - Teak- Steel Table - VIAREGGIO

549.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Modern Outdoor Dining Set for 6 - Teak & Stainless Steel - VIAREGGIO

1,999.00
FREE shipping, available now
(3)
5 stars
(3)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Wooden Garden Table - Rectangular Pull-out Table - TOSCANA

459.00
FREE shipping, available now
(6)
5 stars
(5)
4 stars
(0)
3 stars
(1)
2 stars
(0)
1 star
(0)

Dining Table - Garden Table - Wooden Garden Furniture - Extendable - TOSCANA

519.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden table - Dining table 180cm - Stainless steel - Wooden plate - GROSSETO

929.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Nice Table 180cm single, Stainless Steel - with Granite Plate - GROSSETO grey polished

949.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Nice Garden Table 180cm - Stainless Steel - Granite Plate - GROSSETO grey polished

929.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Nice Table 180cm single, Stainless Steel - with Granite Plate - GROSSETO black polished

1,159.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Nice Garden Table 180cm - Stainless Steel - Granite Plate - GROSSETO black polished

929.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Outdoor Dining Table for 6 - Black Granite Top - GROSSETO

929.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Nice Table 180cm single, Stainless Steel - with Granite Plate - GROSSETO black flamed

1,159.00
FREE shipping, available from 2018-05-28
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden Table - Outdoor Dining Table - Tempered Glass - 6 Seater - Black - GROSSETO

779.00
FREE shipping, available now

Garden Table - Outdoor Dining Table - Tempered Glass - 6 Seater - White - GROSSETO

779.00
FREE shipping, available now

Outdoor Dining Table for 8 - Acacia Wood Table Top - GROSSETO

929.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Outdoor Dining Table for 8 - Grey Granite - GROSSETO

1,049.00
FREE shipping, available now
(2)
5 stars
(2)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Garden table - Dining table 220cm - Stainless Steel - Black granite top - GROSSETO

1,049.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)

Outdoor Dining Table for 8 - Black Granite - GROSSETO

1,049.00
FREE shipping, available now
(1)
5 stars
(1)
4 stars
(0)
3 stars
(0)
2 stars
(0)
1 star
(0)
* All prices incl. VAT and incl. shipping cost
Ratings

4.95 / 5.00 79

TAKE ADVANTAGE OF OUR EXCLUSIVE

voucher offers

See all pictures