0
:067 312 52 59
:0382 703 793
grandpresent@gmail.com (опт)
info@grand-present.com (розница)
  1. Главная
  2. АКЦИИ И РАСПРОДАЖА

АКЦИИ И РАСПРОДАЖА

Столик-бар фигурный

Столик-бар фигурный

Артикул: TCS005-M
2 517,50 грн.
2 342,88 грн.
шт.
Столик -бар прямоугольный

Столик -бар прямоугольный

Артикул: TCS002-M
2 517,50 грн.
2 342,88 грн.
шт.
Столик-бар круглый

Столик-бар круглый

Артикул: TCS001-M
2 517,50 грн.
2 342,88 грн.
шт.
Столик-бар

Столик-бар

Артикул: FG001
3 975,00 грн.
3 686,15 грн.
шт.
Винная стойка – Скрипка

Винная стойка – Скрипка

Артикул: JJ0004
3 180,00 грн.
2 935,14 грн.
шт.
Глобус бар напольный на 3 ножках 450 мм

Глобус бар напольный на 3 ножках 450 мм

Артикул: 45001N-M
4 459,95 грн.
4 140,89 грн.
шт.
Глобус бар напольный на 4х ножках 360 мм

Глобус бар напольный на 4х ножках 360 мм

Артикул: 36003N
3 487,40 грн.
3 238,30 грн.
шт.
Глобус бар напольный 360 мм на 3х ножках

Глобус бар напольный 360 мм на 3х ножках

Артикул: 36001L-G
3 405,25 грн.
3 162,51 грн.
шт.
Глобус бар напольный 330мм

Глобус бар напольный 330мм

Артикул: 33001W-R
2 676,50 грн.
2 389,31 грн.
шт.
Глобус бар напольный на 3х ножках 330 мм

Глобус бар напольный на 3х ножках 330 мм

Артикул: 33001N-M
2 920,30 грн.
2 711,22 грн.
шт.
Глобус бар напольный со столиком 330 мм коричневый

Глобус бар напольный со столиком 330 мм коричневый

Артикул: 33035R
3 731,20 грн.
3 345,63 грн.
шт.
Глобус бар напольный на 4 ножки 450 мм коричневый

Глобус бар напольный на 4 ножки 450 мм коричневый

Артикул: 45043R
4 715,00 грн.
4 365,88 грн.
шт. 

        WP_Query Object
(
    [query] => Array
        (
            [catalog] => aktsii
        )

    [query_vars] => Array
        (
            [catalog] => aktsii
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [static] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [posts_per_page] => 12
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => al_view_type
                            [compare] => !=
                            [value] => 2
                            [type] => NUMERIC
                        )

                    [remaining_amount] => Array
                        (
                            [key] => fs_remaining_amount
                            [compare] => !=
                            [value] => 0
                        )

                )

            [tax_query] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => catalog
                            [field] => term_id
                            [terms] => Array
                                (
                                    [0] => 7991
                                    [1] => 7990
                                    [2] => 8021
                                    [3] => 7989
                                    [4] => 7800
                                    [5] => 6533
                                    [6] => 6522
                                    [7] => 6519
                                    [8] => 8018
                                    [9] => 8017
                                    [10] => 7987
                                    [11] => 7985
                                    [12] => 7981
                                    [13] => 7983
                                    [14] => 7980
                                    [15] => 7984
                                    [16] => 7986
                                    [17] => 7982
                                    [18] => 7801
                                    [19] => 7799
                                )

                            [operator] => NOT IN
                        )

                )

            [orderby] => ID
            [order] => DESC
            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => catalog
            [term] => aktsii
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => catalog
                            [terms] => Array
                                (
                                    [0] => 7991
                                    [1] => 7990
                                    [2] => 8021
                                    [3] => 7989
                                    [4] => 7800
                                    [5] => 6533
                                    [6] => 6522
                                    [7] => 6519
                                    [8] => 8018
                                    [9] => 8017
                                    [10] => 7987
                                    [11] => 7985
                                    [12] => 7981
                                    [13] => 7983
                                    [14] => 7980
                                    [15] => 7984
                                    [16] => 7986
                                    [17] => 7982
                                    [18] => 7801
                                    [19] => 7799
                                )

                            [field] => term_id
                            [operator] => NOT IN
                            [include_children] => 1
                        )

                    [1] => Array
                        (
                            [taxonomy] => catalog
                            [terms] => Array
                                (
                                    [0] => aktsii
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wp_term_relationships
                )

            [queried_terms] => Array
                (
                    [catalog] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => aktsii
                                )

                            [field] => slug
                        )

                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => al_view_type
                            [compare] => !=
                            [value] => 2
                            [type] => NUMERIC
                        )

                    [remaining_amount] => Array
                        (
                            [key] => fs_remaining_amount
                            [compare] => !=
                            [value] => 0
                        )

                    [relation] => AND
                )

            [relation] => AND
            [meta_table] => wp_postmeta
            [meta_id_column] => post_id
            [primary_table] => wp_posts
            [primary_id_column] => ID
            [table_aliases:protected] => Array
                (
                    [0] => wp_postmeta
                    [1] => mt1
                )

            [clauses:protected] => Array
                (
                    [wp_postmeta] => Array
                        (
                            [key] => al_view_type
                            [compare] => !=
                            [value] => 2
                            [type] => NUMERIC
                            [alias] => wp_postmeta
                            [cast] => SIGNED
                        )

                    [remaining_amount] => Array
                        (
                            [key] => fs_remaining_amount
                            [compare] => !=
                            [value] => 0
                            [alias] => mt1
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [queried_object] => WP_Term Object
        (
            [term_id] => 5697
            [name] => АКЦИИ И РАСПРОДАЖА
            [slug] => aktsii
            [term_group] => 0
            [term_taxonomy_id] => 5697
            [taxonomy] => catalog
            [description] => 
            [parent] => 0
            [count] => 0
            [filter] => raw
        )

    [queried_object_id] => 5697
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1  AND ( 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (6519,6522,6533,7799,7800,7801,7980,7981,7982,7983,7984,7985,7986,7987,7989,7990,7991,8017,8018,8021)
			) 
  AND 
  wp_term_relationships.term_taxonomy_id IN (5697,7799,7800,7801,7803,7980,7981,7982,7983,7984,7985,7986,7987,7989,7990,7991,7996,8016,8017,8018,8021,8110,8111)
) AND ( 
  ( wp_postmeta.meta_key = 'al_view_type' AND CAST(wp_postmeta.meta_value AS SIGNED) != '2' ) 
  AND 
  ( mt1.meta_key = 'fs_remaining_amount' AND mt1.meta_value != '0' )
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.ID DESC LIMIT 0, 12
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 18220
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:03:35
                    [post_date_gmt] => 2017-09-22 05:03:35
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Столик-бар фигурный
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => stolik-bar-figurnyj
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:03:35
                    [post_modified_gmt] => 2017-09-22 05:03:35
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/stolik-bar-figurnyj/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [1] => WP_Post Object
                (
                    [ID] => 18219
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:03:35
                    [post_date_gmt] => 2017-09-22 05:03:35
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Столик -бар прямоугольный
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => stolik-bar-pryamougolnyj-2
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:03:35
                    [post_modified_gmt] => 2017-09-22 05:03:35
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/stolik-bar-pryamougolnyj-2/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [2] => WP_Post Object
                (
                    [ID] => 18218
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:03:35
                    [post_date_gmt] => 2017-09-22 05:03:35
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Столик-бар круглый
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => stolik-bar-kruglyj-2
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:03:35
                    [post_modified_gmt] => 2017-09-22 05:03:35
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/stolik-bar-kruglyj-2/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [3] => WP_Post Object
                (
                    [ID] => 18217
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:03:34
                    [post_date_gmt] => 2017-09-22 05:03:34
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Столик-бар
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => stolik-bar
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:03:34
                    [post_modified_gmt] => 2017-09-22 05:03:34
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/stolik-bar/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [4] => WP_Post Object
                (
                    [ID] => 18216
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:06
                    [post_date_gmt] => 2017-09-22 05:02:06
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Винная стойка - Скрипка
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => vinnaya-stojka-skripka
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:06
                    [post_modified_gmt] => 2017-09-22 05:02:06
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/vinnaya-stojka-skripka/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [5] => WP_Post Object
                (
                    [ID] => 18215
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:05
                    [post_date_gmt] => 2017-09-22 05:02:05
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный на 3 ножках 450 мм
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-na-3-nozhkah-450-mm
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:05
                    [post_modified_gmt] => 2017-09-22 05:02:05
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/globus-bar-napolnyj-na-3-nozhkah-450-mm/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [6] => WP_Post Object
                (
                    [ID] => 18214
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:03
                    [post_date_gmt] => 2017-09-22 05:02:03
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный на 4х ножках 360 мм
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-na-4h-nozhkah-360-mm
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:03
                    [post_modified_gmt] => 2017-09-22 05:02:03
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/globus-bar-napolnyj-na-4h-nozhkah-360-mm/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [7] => WP_Post Object
                (
                    [ID] => 18213
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:03
                    [post_date_gmt] => 2017-09-22 05:02:03
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный 360 мм на 3х ножках
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-360-mm-na-3h-nozhkah
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:03
                    [post_modified_gmt] => 2017-09-22 05:02:03
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/globus-bar-napolnyj-360-mm-na-3h-nozhkah/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [8] => WP_Post Object
                (
                    [ID] => 18212
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:03
                    [post_date_gmt] => 2017-09-22 05:02:03
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный 330мм
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-330mm
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:03
                    [post_modified_gmt] => 2017-09-22 05:02:03
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/globus-bar-napolnyj-330mm/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [9] => WP_Post Object
                (
                    [ID] => 18211
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:02
                    [post_date_gmt] => 2017-09-22 05:02:02
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный на 3х ножках 330 мм
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-na-3h-nozhkah-330-mm
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:02
                    [post_modified_gmt] => 2017-09-22 05:02:02
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/product/globus-bar-napolnyj-na-3h-nozhkah-330-mm/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [10] => WP_Post Object
                (
                    [ID] => 18210
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:03
                    [post_date_gmt] => 2017-09-22 05:02:03
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный со столиком 330 мм коричневый
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-so-stolikom-330-mm-korichnevyj
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:03
                    [post_modified_gmt] => 2017-09-22 05:02:03
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://grand-present.com/globus-bar-napolnyj-so-stolikom-330-mm-korichnevyj/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

            [11] => WP_Post Object
                (
                    [ID] => 15407
                    [post_author] => 1
                    [post_date] => 2017-09-22 08:02:05
                    [post_date_gmt] => 2017-09-22 05:02:05
                    [post_content] => 
В упаковке 1 шт.

                    [post_title] => Глобус бар напольный на 4 ножки 450 мм коричневый
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => open
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => globus-bar-napolnyj-na-4-nozhki-450-mm-korichnevyj
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2017-09-22 08:02:05
                    [post_modified_gmt] => 2017-09-22 05:02:05
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://139.59.143.207/globus-bar-napolnyj-na-4-nozhki-450-mm-korichnevyj/
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [ura_post_type] => 
                )

        )

    [post_count] => 12
    [current_post] => -1
    [in_the_loop] => 
    [post] => WP_Post Object
        (
            [ID] => 18220
            [post_author] => 1
            [post_date] => 2017-09-22 08:03:35
            [post_date_gmt] => 2017-09-22 05:03:35
            [post_content] => 
В упаковке 1 шт.

            [post_title] => Столик-бар фигурный
            [post_excerpt] => 
            [post_status] => publish
            [comment_status] => open
            [ping_status] => closed
            [post_password] => 
            [post_name] => stolik-bar-figurnyj
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-09-22 08:03:35
            [post_modified_gmt] => 2017-09-22 05:03:35
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => https://grand-present.com/product/stolik-bar-figurnyj/
            [menu_order] => 0
            [post_type] => product
            [post_mime_type] => 
            [comment_count] => 0
            [filter] => raw
            [ura_post_type] => 
        )

    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 36
    [max_num_pages] => 3
    [max_num_comment_pages] => 0
    [is_single] => 
    [is_preview] => 
    [is_page] => 
    [is_archive] => 1
    [is_date] => 
    [is_year] => 
    [is_month] => 
    [is_day] => 
    [is_time] => 
    [is_author] => 
    [is_category] => 
    [is_tag] => 
    [is_tax] => 1
    [is_search] => 
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_posts_page] => 
    [is_post_type_archive] => 
    [query_vars_hash:WP_Query:private] => 84983611e022e980a242177d19d03eab
    [query_vars_changed:WP_Query:private] => 1
    [thumbnails_cached] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)