1. Trang chủ
  2. Phụ kiện tập gym
  3. Dây Quấn Bảo Vệ Đầu Gối
  4. Đai quấn bảo vệ gối PJ 758a
Nhận xét sản phẩm

Đai quấn bảo vệ gối PJ 758a

Mã sản phẩm: BVG 758a
Giá cũ: 280.000 VNĐ
Giá mới: 230.000 VNĐ
Hãng sản xuất: PJ
Xuất xứ: Hàng chính hãng
Tình trạng: Còn hàng
Gọi mua ngay
0936.237.327​
Đặt hàng ngay

Đai quấn bảo vệ gối PJ 758a

Đai quấn đầu gối PJ 759A là phụ kiện chuyên dụng hỗ trợ hoàn hảo cho người thường xuyên tập luyện các bộ môn thể thao. Đai giúp bảo vệ các vùng khớp, cơ và da khi bị ngã. Đặc biệt, đây không chỉ là phụ kiện tập gym mà còn hỗ trợ giảm đau cơ bắp, dây chằng giúp bạn thoải mái tập luyện và hoạt động đi lại hàng ngày.

Thông tin đai quấn bảo vệ gối PJ 758a

- Màu sắc: Xanh, đen và màu da chân.

- Đai quấn gối được làm từ chất liệu xốp, cao su tổng hợp cao cấp, bó sát gối có độ đàn hồi cao và rất êm.

- Ngoài ra đai quấn gối PJ 758A còn có tác dụng thấm hút mồ hôi rất nhanh giúp bạn có thể mặc thoải mái cả ngày.

- Cách bảo quản: bạn có thể giặt bằng tay với xà phòng và phơi khô, tránh dùng các loại hóa chất, thuốc tẩy.

- Đơn giá: 230.000đ/cái

 

Lợi ích của Quý khách khi mua sản phẩm tại Hệ thống bán hàng thể thao 24hsport.vn :

=> Giá rẻ nhất, hàng chính hãng, chất lượng vượt trội.

=> Giao hàng toàn quốc, thanh toán tại nhà

=> Đổi mới sản phẩm nếu có lỗi từ nhà sản xuất.

=> Bảo hành chính hãng từ nhà cung cấp 

=> Tư vấn 24/7, phục vụ với nhiều chính sách ưu đãi khuyến mại hấp hẫn.

Sản phẩm liên quan
Đai quấn gối tập gym Camewin 0635 - Giá rẻ nhất - 24hsport.vn
Mua hàng

Đai quấn gối tập gym Camewin 0635

180.000 VNĐ150.000 VNĐ
Bảo vệ gối Camewin 0626 - Băng quấn gối giá rẻ nhất - 24hsport.vn
Mua hàng

Bảo vệ gối Camewin 0626

220.000 VNĐ180.000 VNĐ
Đai quấn gối cao cấp BG 301 - Giảm 35% - 24hsport.vn
Mua hàng

Đai quấn gối cao cấp BG 301

220.000 VNĐ150.000 VNĐ
Dây quấn bảo vệ đầu gối tập gym Valeo - Giá tốt nhất - 24hsport.vn
Mua hàng

Dây quấn bảo vệ đầu gối tập gym Valeo

350.000 VNĐ290.000 VNĐ
Đai hỗ trợ vệ gối Camewin 0738 - Giá rẻ nhất - 24hsport.vn
Mua hàng

Đai hỗ trợ vệ gối Camewin 0738

250.000 VNĐ200.000 VNĐ
Đai bảo vệ đầu gối Kaiwei 0832 chính hãng - Giá rẻ nhất - 24hsport.vn
Mua hàng

Đai bảo vệ đầu gối Kaiwei 0832

180.000 VNĐ150.000 VNĐ

 

0936 237 327
.

Đang xử lý...

(default) 42 queries took 72 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'contact_%'161639
2SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'site_%'22220
3SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'slideshow_%'13130
4SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`unit`, `Currency`.`location`, `Currency`.`value`, `Currency`.`status` FROM `vnsport24h_admin`.`currencies` AS `Currency` WHERE `status` = '1' ORDER BY `name` asc220
5SELECT `ProductCategory`.`slug`, `ProductCategory`.`meta_title`, `ProductCategory`.`name`, `ProductCategory`.`pos_home`, `ProductCategory`.`lang`, `ProductCategory`.`id`, `ProductCategory`.`path`, `ProductCategory`.`rel`, `ProductCategory`.`parent_id`, `ProductCategory`.`target`, `ProductCategory`.`link`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`lang` = 'vi' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' ORDER BY `lft` asc56560
6SELECT `ProductCategory`.`id`, `ProductCategory`.`name` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `parent_id` IS NULL11110
7SELECT `PostCategory`.`slug`, `PostCategory`.`meta_title`, `PostCategory`.`name`, `PostCategory`.`lang`, `PostCategory`.`id`, `PostCategory`.`path`, `PostCategory`.`rel`, `PostCategory`.`parent_id`, `PostCategory`.`target`, `PostCategory`.`link`, `PostCategory`.`position` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `PostCategory`.`lang` = 'vi' AND `PostCategory`.`status` = '1' AND `PostCategory`.`trash` = '0' ORDER BY `lft` asc220
8SELECT `PostCategory`.`id`, `PostCategory`.`name`, `PostCategory`.`lft`, `PostCategory`.`rght` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND 1 = 1 ORDER BY `PostCategory`.`lft` asc220
9SELECT `PostCategory`.`slug`, `PostCategory`.`meta_title`, `PostCategory`.`name`, `PostCategory`.`lang`, `PostCategory`.`id`, `PostCategory`.`path`, `PostCategory`.`rel`, `PostCategory`.`parent_id`, `PostCategory`.`target`, `PostCategory`.`link`, `PostCategory`.`position` FROM `vnsport24h_admin`.`post_categories` AS `PostCategory` LEFT JOIN `vnsport24h_admin`.`post_categories` AS `ParentPostCategory` ON (`PostCategory`.`parent_id` = `ParentPostCategory`.`id`) WHERE `PostCategory`.`lang` = 'vi' AND `PostCategory`.`status` = '1' AND `PostCategory`.`trash` = '0' ORDER BY `PostCategory`.`lft` asc220
10SELECT `ChildPostCategory`.`id`, `ChildPostCategory`.`lang`, `ChildPostCategory`.`name`, `ChildPostCategory`.`position`, `ChildPostCategory`.`image`, `ChildPostCategory`.`banner`, `ChildPostCategory`.`banner_link`, `ChildPostCategory`.`slug`, `ChildPostCategory`.`path`, `ChildPostCategory`.`column`, `ChildPostCategory`.`link`, `ChildPostCategory`.`description`, `ChildPostCategory`.`meta_title`, `ChildPostCategory`.`meta_keyword`, `ChildPostCategory`.`meta_description`, `ChildPostCategory`.`meta_robots`, `ChildPostCategory`.`rel`, `ChildPostCategory`.`target`, `ChildPostCategory`.`counter`, `ChildPostCategory`.`parent_id`, `ChildPostCategory`.`lft`, `ChildPostCategory`.`rght`, `ChildPostCategory`.`status`, `ChildPostCategory`.`trash` FROM `vnsport24h_admin`.`post_categories` AS `ChildPostCategory` WHERE `ChildPostCategory`.`parent_id` IN (47, 60)000
11SELECT `Post`.`id`, `Post`.`lang`, `Post`.`post_category_id`, `Post`.`user_id`, `Post`.`category_other`, `Post`.`name`, `Post`.`image`, `Post`.`summary`, `Post`.`description`, `Post`.`slug`, `Post`.`tag`, `Post`.`meta_title`, `Post`.`meta_keyword`, `Post`.`meta_description`, `Post`.`meta_robots`, `Post`.`rel`, `Post`.`target`, `Post`.`view`, `Post`.`pos_1`, `Post`.`pos_2`, `Post`.`pos_3`, `Post`.`pos_4`, `Post`.`pos_5`, `Post`.`pos_6`, `Post`.`sort`, `Post`.`public`, `Post`.`star_rate_count`, `Post`.`star_rate`, `Post`.`created`, `Post`.`modifired`, `Post`.`status`, `Post`.`trash` FROM `vnsport24h_admin`.`posts` AS `Post` WHERE `Post`.`post_category_id` = (47) LIMIT 1010101
12SELECT `Post`.`id`, `Post`.`lang`, `Post`.`post_category_id`, `Post`.`user_id`, `Post`.`category_other`, `Post`.`name`, `Post`.`image`, `Post`.`summary`, `Post`.`description`, `Post`.`slug`, `Post`.`tag`, `Post`.`meta_title`, `Post`.`meta_keyword`, `Post`.`meta_description`, `Post`.`meta_robots`, `Post`.`rel`, `Post`.`target`, `Post`.`view`, `Post`.`pos_1`, `Post`.`pos_2`, `Post`.`pos_3`, `Post`.`pos_4`, `Post`.`pos_5`, `Post`.`pos_6`, `Post`.`sort`, `Post`.`public`, `Post`.`star_rate_count`, `Post`.`star_rate`, `Post`.`created`, `Post`.`modifired`, `Post`.`status`, `Post`.`trash` FROM `vnsport24h_admin`.`posts` AS `Post` WHERE `Post`.`post_category_id` = (60) LIMIT 10662
13SELECT `Support`.`id`, `Support`.`name`, `Support`.`phone`, `Support`.`yahoo`, `Support`.`skype`, `Support`.`sort`, `Support`.`status` FROM `vnsport24h_admin`.`supports` AS `Support` WHERE `status` = '1' ORDER BY `sort` asc110
14SELECT `Information`.`id`, `Information`.`name`, `Information`.`lang`, `Information`.`slug`, `Information`.`parent_id`, `Information`.`link`, `Information`.`rel`, `Information`.`target`, `Information`.`position`, `Information`.`meta_title` FROM `vnsport24h_admin`.`information` AS `Information` WHERE `Information`.`status` = '1' AND `Information`.`trash` = '0' AND `Information`.`parent_id` IS NULL AND `Information`.`lang` = 'vi' ORDER BY `sort` asc12120
15SELECT `ChildInformation`.`id`, `ChildInformation`.`name`, `ChildInformation`.`lang`, `ChildInformation`.`slug`, `ChildInformation`.`parent_id`, `ChildInformation`.`link`, `ChildInformation`.`rel`, `ChildInformation`.`target`, `ChildInformation`.`position`, `ChildInformation`.`meta_title` FROM `vnsport24h_admin`.`information` AS `ChildInformation` WHERE `status` = '1' AND `trash` = '0' AND `ChildInformation`.`parent_id` IN (1026, 1034, 1037, 1038, 1042, 1029, 1039, 1031, 1040, 1032, 1033, 1035) ORDER BY `sort` asc000
16SELECT `VideoCategory`.`id`, `VideoCategory`.`name`, `VideoCategory`.`slug`, `VideoCategory`.`meta_title`, `VideoCategory`.`rel`, `VideoCategory`.`target` FROM `vnsport24h_admin`.`video_categories` AS `VideoCategory` WHERE `lang` = 'vi' AND `status` = 1 AND `trash` = '0' ORDER BY `sort` asc, `name` asc110
17SELECT `Video`.`id`, `Video`.`name`, `Video`.`youtube`, `Video`.`slug`, `Video`.`meta_title`, `Video`.`rel`, `Video`.`target` FROM `vnsport24h_admin`.`videos` AS `Video` LEFT JOIN `vnsport24h_admin`.`video_categories` AS `VideoCategory` ON (`Video`.`video_category_id` = `VideoCategory`.`id`) WHERE `Video`.`status` = '1' AND `Video`.`trash` = '0' AND `VideoCategory`.`status` = 1 AND `VideoCategory`.`trash` = '0' AND `Video`.`lang` = 'vi' AND `pos_1` != 0 ORDER BY `pos_1` asc, `name` asc LIMIT 10110
18SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_2` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-14-%')) ORDER BY `sort` asc, `pos_2` asc, `name` asc LIMIT 30220
19SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_3` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-14-%')) ORDER BY `sort` asc, `pos_3` asc, `name` asc LIMIT 30000
20SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_4` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-14-%')) ORDER BY `sort` asc, `pos_4` asc, `name` asc LIMIT 30110
21SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_9` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-14-%')) ORDER BY `sort` asc, `pos_9` asc, `name` asc LIMIT 30000
22SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`name`, `Banner`.`image`, `Banner`.`link`, `Banner`.`rel`, `Banner`.`target`, `Banner`.`description` FROM `vnsport24h_admin`.`banners` AS `Banner` WHERE `lang` = 'vi' AND `status` = '1' AND `trash` = '0' AND `pos_10` != 0 AND ((`page` like '%-1-%') OR (`page` like '%-14-%')) ORDER BY `sort` asc, `pos_10` asc, `name` asc LIMIT 30000
23SELECT `Product`.*, `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`path`, `ProductMaker`.`name`, `Product`.`id` FROM `vnsport24h_admin`.`products` AS `Product` LEFT JOIN `vnsport24h_admin`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `vnsport24h_admin`.`product_makers` AS `ProductMaker` ON (`Product`.`product_maker_id` = `ProductMaker`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`trash` = '0' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' AND `Product`.`slug` = 'dai-quan-bao-ve-goi-pj-758a' AND `Product`.`lang` = 'vi' AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' LIMIT 1111
24SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`name`, `ProductImage`.`image`, `ProductImage`.`sort` FROM `vnsport24h_admin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (961)001
25SELECT `Config`.`name`, `Config`.`value` FROM `vnsport24h_admin`.`configs` AS `Config` WHERE `name` like 'product_%'550
26SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`id` = 186 LIMIT 1110
27SELECT `ProductCategory`.`id`, `ProductCategory`.`status`, `ProductCategory`.`trash` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`rght` < 69 AND `ProductCategory`.`lft` > 68 ORDER BY `ProductCategory`.`lft` asc000
28SELECT `Product`.`id`, `Product`.`name`, `Product`.`lang`, `Product`.`price_new`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`rel`, `Product`.`target`, `Product`.`description`, `Product`.`image`, `Product`.`price`, `Product`.`quantity`, `Product`.`discount`, `Product`.`discount_unit`, `Product`.`promotion`, `Product`.`public`, `Product`.`summary`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`status` FROM `vnsport24h_admin`.`products` AS `Product` LEFT JOIN `vnsport24h_admin`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `vnsport24h_admin`.`product_makers` AS `ProductMaker` ON (`Product`.`product_maker_id` = `ProductMaker`.`id`) LEFT JOIN `vnsport24h_admin`.`product_taxes` AS `ProductTax` ON (`Product`.`product_tax_id` = `ProductTax`.`id`) LEFT JOIN `vnsport24h_admin`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE product_category_id = (186) AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' AND `Product`.`lang` = 'vi' AND `Product`.`slug` != 'dai-quan-bao-ve-goi-pj-758a' AND `Product`.`public` <= 1786565780 AND `ProductMaker`.`status` = '1' AND `ProductMaker`.`trash` = '0' ORDER BY rand() ASC LIMIT 10663
29SELECT `Product`.`id`, `Product`.`name`, `Product`.`lang`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`rel`, `Product`.`target`, `Product`.`image`, `Product`.`price`, `Product`.`quantity`, `Product`.`discount`, `Product`.`discount_unit`, `Product`.`public`, `Product`.`promotion`, `Product`.`summary`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`status` FROM `vnsport24h_admin`.`products` AS `Product` LEFT JOIN `vnsport24h_admin`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `vnsport24h_admin`.`product_makers` AS `ProductMaker` ON (`Product`.`product_maker_id` = `ProductMaker`.`id`) LEFT JOIN `vnsport24h_admin`.`product_taxes` AS `ProductTax` ON (`Product`.`product_tax_id` = `ProductTax`.`id`) LEFT JOIN `vnsport24h_admin`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE `Product`.`code` = ('') AND `Product`.`status` = '1' AND `Product`.`trash` = '0' AND `ProductCategory`.`status` = '1' AND `ProductCategory`.`trash` = '0' AND `Product`.`lang` = 'vi' AND `Product`.`public` <= 1786565780 ORDER BY rand() ASC002
30SELECT `Product`.`view`, `Product`.`id` FROM `vnsport24h_admin`.`products` AS `Product` LEFT JOIN `vnsport24h_admin`.`product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) LEFT JOIN `vnsport24h_admin`.`product_makers` AS `ProductMaker` ON (`Product`.`product_maker_id` = `ProductMaker`.`id`) LEFT JOIN `vnsport24h_admin`.`product_taxes` AS `ProductTax` ON (`Product`.`product_tax_id` = `ProductTax`.`id`) LEFT JOIN `vnsport24h_admin`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE `Product`.`id` = 961 LIMIT 1110
31SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`name`, `ProductImage`.`image`, `ProductImage`.`sort` FROM `vnsport24h_admin`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (961)000
32SELECT `ProductOption`.`id`, `ProductOption`.`product_id`, `ProductOption`.`name`, `ProductOption`.`price`, `ProductOption`.`image` FROM `vnsport24h_admin`.`product_options` AS `ProductOption` WHERE `ProductOption`.`product_id` = (961)000
33SELECT `ProductProperty`.`id`, `ProductProperty`.`product_id`, `ProductProperty`.`field`, `ProductProperty`.`value` FROM `vnsport24h_admin`.`product_properties` AS `ProductProperty` WHERE `ProductProperty`.`product_id` = (961)0015
34SELECT `Comment`.`id`, `Comment`.`member_id`, `Comment`.`item_id`, `Comment`.`model`, `Comment`.`lang`, `Comment`.`name`, `Comment`.`email`, `Comment`.`description`, `Comment`.`like`, `Comment`.`view`, `Comment`.`ip`, `Comment`.`proxy`, `Comment`.`parent_id`, `Comment`.`created`, `Comment`.`status` FROM `vnsport24h_admin`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Product' AND `Comment`.`item_id` = (961)006
35SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 961111
36SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 961110
37SELECT COUNT(*) AS `count` FROM `vnsport24h_admin`.`products` AS `Product` WHERE `Product`.`id` = 961110
38UPDATE `vnsport24h_admin`.`products` SET `view` = 2484, `id` = 961 WHERE `vnsport24h_admin`.`products`.`id` = '961'111
39SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 186 LIMIT 1110
40SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`meta_title`, `ProductCategory`.`path`, `ProductCategory`.`link`, `ProductCategory`.`parent_id`, `ProductCategory`.`status` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 68 AND `ProductCategory`.`rght` >= 69 ORDER BY `ProductCategory`.`lft` asc220
41SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`meta_title`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`link`, `ProductCategory`.`parent_id`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `parent_id` IS NULL AND `id` != 177 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc10100
42SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`meta_title`, `ProductCategory`.`slug`, `ProductCategory`.`path`, `ProductCategory`.`link`, `ProductCategory`.`parent_id`, `ProductCategory`.`counter` FROM `vnsport24h_admin`.`product_categories` AS `ProductCategory` WHERE `parent_id` = 177 AND `id` != 186 AND `status` = '1' AND `trash` = '0' AND `lang` = 'vi' ORDER BY `lft` asc10100