全部商品分类
-
低压电气
工控
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '1505') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
- 电线电缆 附件
-
仪器仪表
传感
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '3') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
传动
气动
液压
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '90') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
电工
照明
风机
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '96') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
控制阀
流体泵
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '102') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
紧固
密封
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '122') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
管材
管件
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '136') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
工具
耗材
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '36') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
-
油脂
防护
SELECT `main_table`.*, `link`.`position` AS `pos` FROM `catalog_brand` AS `main_table`
INNER JOIN `catalog_category_brand` AS `link` ON main_table.brand_id=link.brand_id WHERE (`link`.`category_id` = '132') AND (`is_active` = '1') ORDER BY pos DESC LIMIT 16
