SELECT p.*, pd.name AS name, pd.description, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '536' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20
stdClass Object
(
    [num_rows] => 20
    [row] => Array
        (
            [product_id] => 92587
            [model] => 36146
            [sku] => 36146
            [upc] => 
            [ean] => 
            [jan] => 
            [isbn] => 
            [mpn] => 
            [location] => 
            [quantity] => 0
            [stock_status_id] => 8
            [image] => import_files/4f/4f67a6f171fc11e894e524be051db987_2d0f24d2057a11eaab0924be051db987.jpeg
            [manufacturer_id] => 0
            [shipping] => 1
            [price] => 339.0000
            [points] => 0
            [tax_class_id] => 0
            [date_available] => 0000-00-00
            [weight] => 0.000
            [weight_class_id] => 1
            [length] => 0.00000000
            [width] => 0.00000000
            [height] => 0.00000000
            [length_class_id] => 1
            [subtract] => 1
            [minimum] => 1
            [sort_order] => 0
            [status] => 1
            [viewed] => 11
            [date_added] => 2021-01-16 15:27:33
            [date_modified] => 2021-02-19 13:05:51
            [sima_update] => 0
            [name] => Бадминтон 206, в чехле (860) /50/
            [description] => 
            [rating] => 
            [discount] => 
            [special] => 
        )

    [rows] => Array
        (
            [0] => Array
                (
                    [product_id] => 92587
                    [model] => 36146
                    [sku] => 36146
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => import_files/4f/4f67a6f171fc11e894e524be051db987_2d0f24d2057a11eaab0924be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 339.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 11
                    [date_added] => 2021-01-16 15:27:33
                    [date_modified] => 2021-02-19 13:05:51
                    [sima_update] => 0
                    [name] => Бадминтон 206, в чехле (860) /50/
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [1] => Array
                (
                    [product_id] => 92659
                    [model] => 36147
                    [sku] => 36147
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => import_files/4f/4f67a6f271fc11e894e524be051db987_2d0f24d3057a11eaab0924be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 266.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 6
                    [date_added] => 2021-01-16 15:27:33
                    [date_modified] => 2021-02-19 13:05:51
                    [sima_update] => 0
                    [name] => Бадминтон 218 в чехле (AL-232)(229) /50/
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [2] => Array
                (
                    [product_id] => 94283
                    [model] => 54725
                    [sku] => 54725
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => no_image.png
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 215.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 6
                    [date_added] => 2021-01-16 15:31:53
                    [date_modified] => 2021-02-19 13:07:27
                    [sima_update] => 0
                    [name] => Бадминтон 218 в чехле (AL-232)/50/
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [3] => Array
                (
                    [product_id] => 92647
                    [model] => 14260
                    [sku] => 14260
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => import_files/4f/4f67a6f371fc11e894e524be051db987_b726c86173d611e8973f24be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 201.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 8
                    [date_added] => 2021-01-16 15:27:33
                    [date_modified] => 2021-02-19 13:05:51
                    [sima_update] => 0
                    [name] => Бадминтон 460 в сетке, с воланом (859) /50/
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [4] => Array
                (
                    [product_id] => 94207
                    [model] => 17571
                    [sku] => 17571
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => import_files/ad/adb7b2c036f711e7b24b408d5cd3339f_38c99c9b4bbf11e8be0e24be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 170.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 4
                    [date_added] => 2021-01-16 15:31:53
                    [date_modified] => 2021-02-19 13:07:27
                    [sima_update] => 0
                    [name] => Бадминтон 9301 в сетке, с воланом (129)/50/
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [5] => Array
                (
                    [product_id] => 93950
                    [model] => рч221346
                    [sku] => рч221346
                    [upc] => 
                    [ean] => 6900242213463
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => no_image.png
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 250.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 8
                    [date_added] => 2021-01-16 15:31:20
                    [date_modified] => 2021-02-19 13:07:27
                    [sima_update] => 0
                    [name] => Бадминтон деревянный в сетке.
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [6] => Array
                (
                    [product_id] => 92560
                    [model] => 66906
                    [sku] => 66906
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => import_files/4f/4f67a6f471fc11e894e524be051db987_b726c86273d611e8973f24be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 384.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 6
                    [date_added] => 2021-01-16 15:27:33
                    [date_modified] => 2021-02-19 13:05:51
                    [sima_update] => 0
                    [name] => Бадминтон детский (В-238) (857) /50/
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [7] => Array
                (
                    [product_id] => 93987
                    [model] => рч223737
                    [sku] => рч223737
                    [upc] => 
                    [ean] => 6900242237377
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => no_image.png
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 286.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 7
                    [date_added] => 2021-01-16 15:31:20
                    [date_modified] => 2021-02-19 13:07:27
                    [sima_update] => 0
                    [name] => Бадминтон детский 2шт.
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [8] => Array
                (
                    [product_id] => 94565
                    [model] => ХК61440
                    [sku] => ХК61440
                    [upc] => 
                    [ean] => 
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 0
                    [stock_status_id] => 8
                    [image] => import_files/7a/7a75b1eaed2811eab47f24be051db987_7a75b1ebed2811eab47f24be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 70.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 4
                    [date_added] => 2021-01-16 15:42:45
                    [date_modified] => 2021-02-19 13:07:36
                    [sima_update] => 0
                    [name] => Волан для бадминтона 12шт, в паккете,  /250/ (шт.)
                    [description] => 
                    [rating] => 
                    [discount] => 
                    [special] => 
                )

            [9] => Array
                (
                    [product_id] => 93360
                    [model] => ГИ10710
                    [sku] => ГИ10710
                    [upc] => 
                    [ean] => 2000107100014
                    [jan] => 
                    [isbn] => 
                    [mpn] => 
                    [location] => 
                    [quantity] => 4
                    [stock_status_id] => 7
                    [image] => import_files/21/21f55bd3ffc111e9a3e524be051db987_ea3bbfc3f31a11ea8b4624be051db987.jpeg
                    [manufacturer_id] => 0
                    [shipping] => 1
                    [price] => 10.0000
                    [points] => 0
                    [tax_class_id] => 0
                    [date_available] => 0000-00-00
                    [weight] => 0.000
                    [weight_class_id] => 1
                    [length] => 0.00000000
                    [width] => 0.00000000
                    [height] => 0.00000000
                    [length_class_id] => 1
                    [subtract] => 1
                    [minimum] => 1
                    [sort_order] => 0
                    [status] => 1
                    [viewed] => 3
                    [date_added] => 2021-01-16 15:29:36
                    [date_modified] => 2021-02-19 13:06:57
                    [sima_update] => 0
                    [name] => Волан для бадминтона В АССР
                    [description] => Лицевое полотенце в тубусе. Торговая Марка «Гранд стиль» производит и реализует текстиль только наивысшего качества. Мы предлагаем махровые изделия изготовленные из бамбука и хлопка. Наши полотенца прекрасно впитывают влагу, не линяют и не выцветают. Код производителя: Восторг Страна-производитель: Китай Размер: 48х90, см Цвет: голубой Материал: Бамбук


,


Хлопок Штрихкод: 2000107100014 Вес: 0.255 Тип товара: Полотенце для лица, рук или ног Название: Полотенце для лица, рук или ног Grand Stil Восторг , размер 48*90, GS-H27t, голубой Вес товара, г: 255 Название модели: Восторг , размер 48*90, GS-H27t Дата создания: 16.01.2019 11:37:44 [rating] => [discount] => [special] => ) [10] => Array ( [product_id] => 94113 [model] => 11816 [sku] => 11816 [upc] => [ean] => 2103007654462 [jan] => [isbn] => [mpn] => [location] => [quantity] => 4 [stock_status_id] => 7 [image] => import_files/ad/adb7b2c136f711e7b24b408d5cd3339f_c1b90151263a11eb9f2524be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 20.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 3 [date_added] => 2021-01-16 15:31:53 [date_modified] => 2021-02-19 13:07:27 [sima_update] => 0 [name] => Воланчик 2114 (AL-233) /40/ [description] => [rating] => [discount] => [special] => ) [11] => Array ( [product_id] => 17919 [model] => 20714 [sku] => 20714 [upc] => [ean] => 4690408023181 [jan] => [isbn] => [mpn] => [location] => [quantity] => 1 [stock_status_id] => 7 [image] => import_files/81/81975670543711e8838c24be051db987_bd42b06d73d611e8973f24be051db987.jpeg [manufacturer_id] => 150 [shipping] => 1 [price] => 28.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 4 [date_added] => 2021-01-15 04:24:37 [date_modified] => 2021-02-19 13:02:00 [sima_update] => 0 [name] => Воланы (набор из 3 шт) BadVol-3P [description] => 3 волана в наборе
Материал: пластик
Упаковка: пакет + хедер
Вес в ед. упаковке: 17 г

Код производителя: BadVol-3P
Страна-производитель: Китай
Материал: Пластик
Штрихкод: 4690408023181
Количество в наборе: 3
Вес: 0.017
Тип товара: Волан
Название: Волан Ecos BadVol-3P, 3
Вид спорта: Бадминтон
Название модели: BadVol-3P
Дата создания: 16.05.2019 19:09:09 [rating] => [discount] => [special] => ) [12] => Array ( [product_id] => 92737 [model] => 10724 [sku] => 10724 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623bfa71fc11e894e524be051db987_d5eb71c673d611e8973f24be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 45.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 6 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор воланов 3шт, ПВХ, цветные (006) [description] => [rating] => [discount] => [special] => ) [13] => Array ( [product_id] => 92745 [model] => 34157 [sku] => 34157 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623bfb71fc11e894e524be051db987_86eb0786a18b11e8a1d924be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 65.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 8 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор воланов 6шт, ПВХ,  в тубе (005) [description] => [rating] => [discount] => [special] => ) [14] => Array ( [product_id] => 92805 [model] => 34158 [sku] => 34158 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623bfc71fc11e894e524be051db987_86eb0787a18b11e8a1d924be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 46.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 9 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор воланов детских 3шт, ПВХ, цветные, в пакете, 2114-3 [description] => [rating] => [discount] => [special] => ) [15] => Array ( [product_id] => 92780 [model] => 54723 [sku] => 54723 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623bfd71fc11e894e524be051db987_53875e17057a11eaab0924be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 164.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 3 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор для бадминтона в сетке (ракетка 2шт, волан), (007) 100 [description] => [rating] => [discount] => [special] => ) [16] => Array ( [product_id] => 92827 [model] => 17570 [sku] => 17570 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623bfe71fc11e894e524be051db987_86eb0788a18b11e8a1d924be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 243.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 7 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор для бадминтона в чехле (ракетка 2шт, волан)(010) [description] => [rating] => [discount] => [special] => ) [17] => Array ( [product_id] => 92828 [model] => 65816 [sku] => 65816 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623bff71fc11e894e524be051db987_86eb0789a18b11e8a1d924be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 196.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 2 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор для бадминтона детский (ракетка 2шт, волан)(012) [description] => [rating] => [discount] => [special] => ) [18] => Array ( [product_id] => 92781 [model] => 17147 [sku] => 17147 [upc] => [ean] => 4680259287467 [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623c0071fc11e894e524be051db987_d5eb71c773d611e8973f24be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 181.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 6 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор для бадминтона детский в сетке (ракетка 2шт, мяч 2шт.) YG3664D [description] => [rating] => [discount] => [special] => ) [19] => Array ( [product_id] => 92782 [model] => 17148 [sku] => 17148 [upc] => [ean] => [jan] => [isbn] => [mpn] => [location] => [quantity] => 0 [stock_status_id] => 8 [image] => import_files/55/55623c0171fc11e894e524be051db987_d5eb71c873d611e8973f24be051db987.jpeg [manufacturer_id] => 0 [shipping] => 1 [price] => 222.0000 [points] => 0 [tax_class_id] => 0 [date_available] => 0000-00-00 [weight] => 0.000 [weight_class_id] => 1 [length] => 0.00000000 [width] => 0.00000000 [height] => 0.00000000 [length_class_id] => 1 [subtract] => 1 [minimum] => 1 [sort_order] => 0 [status] => 1 [viewed] => 8 [date_added] => 2021-01-16 15:27:58 [date_modified] => 2021-02-19 13:05:51 [sima_update] => 0 [name] => Набор для бадминтона детский в сетке (ракетка 2шт, мяч, волан) YG3630D [description] => [rating] => [discount] => [special] => ) ) )
Бадминтон
г. Красноярск, ул. Карамзина 6
0 0
Бадминтон
Бадминтон 206, в чехле (860) /50/
Артикул: 36146
Нет в наличии
339 руб.
Бадминтон 218 в чехле (AL-232)(229) /50/
Артикул: 36147
Нет в наличии
266 руб.
Бадминтон 218 в чехле (AL-232)/50/
Артикул: 54725
Нет в наличии
215 руб.
Бадминтон 460 в сетке, с воланом (859) /50/
Артикул: 14260
Нет в наличии
201 руб.
Бадминтон 9301 в сетке, с воланом (129)/50/
Артикул: 17571
Нет в наличии
170 руб.
Бадминтон деревянный в сетке.
Артикул: рч221346
Нет в наличии
250 руб.
Бадминтон детский (В-238) (857) /50/
Артикул: 66906
Нет в наличии
384 руб.
Бадминтон детский 2шт.
Артикул: рч223737
Нет в наличии
286 руб.
Волан для бадминтона 12шт, в паккете, /250/ (шт.)
Артикул: ХК61440
Нет в наличии
70 руб.
Волан для бадминтона В АССР
Артикул: ГИ10710
В наличии
10 руб.
Воланчик 2114 (AL-233) /40/
Артикул: 11816
В наличии
20 руб.
Воланы (набор из 3 шт) BadVol-3P
Артикул: 20714
В наличии
28 руб.
Набор воланов 3шт, ПВХ, цветные (006)
Артикул: 10724
Нет в наличии
45 руб.
Набор воланов 6шт, ПВХ,  в тубе (005)
Артикул: 34157
Нет в наличии
65 руб.
Набор для бадминтона в чехле (ракетка 2шт, волан)(010)
Артикул: 17570
Нет в наличии
243 руб.
Набор для бадминтона детский (ракетка 2шт, волан)(012)
Артикул: 65816
Нет в наличии
196 руб.
0 0