Трансмиссия: 4L40E , 5L40E , 5L50E
Название: Sprag, low
OEM номер:
Номер в каталоге:
Описание: 26 кулачков
Дополнительные параметры:
Внешний диаметр (OD) : 81.50 мм
Внутренний диаметр (ID) : 64.70 мм
Количество зубьев (z) : 26.00 шт
Толщина (h) : 25.20 мм
Для того чтобы купить или продать деталь АКПП 4L40E, 5L40E, 5L50E Сепаратор обгонной муфты Sprag, low OEM номер: отправьте сообщение через WhatsApp или SMS, где укажите номер 001024.
contactNumberList
product
productTransmissionList
extraParamList
photoList
productDistributorList
currencyUSD
currencyEUR
productArticlesList
obLevel
__env
app
errors
__currentLoopData
productTransmission
loop
extraParam
productDistributor
select * from `product` where `id` = '1024' limit 1
SELECT *
LIMIT
ORDER BY
select * from `contact_number` order by `orderNum` asc
SELECT
WHERE
select `transmission`.* from `transmission` left join `product_transmission` on `product_transmission`.`transmission` = `transmission`.`id` where `product_transmission`.`product` = '1024' order by `caption` asc
select `extra_params`.`caption`, `product_extra_params_value`.`value`, `extra_params`.`dimension` from `product_extra_params_value` left join `product_group_extra_params` on `product_group_extra_params`.`id` = `product_extra_params_value`.`product_group_extra_params` left join `extra_params` on `extra_params`.`id` = `product_group_extra_params`.`extra_params` where `product_extra_params_value`.`product` = '1024' order by `extra_params`.`caption` asc
select `distributor_product_files`.`id`, `fsg_file`.`name` as `file_name`, `distributor_product_files`.`distributor_product` from `distributor_product_files` left join `distributor_product` on `distributor_product_files`.`distributor_product` = `distributor_product`.`id` left join `fsg_file` on `distributor_product_files`.`file_id` = `fsg_file`.`id` where `distributor_product`.`product` = '1024' order by `distributor_product_files`.`id` asc
select `distributor_product`.*, `distributor`.`caption` as `distributor_caption`, `manufacturer`.`caption` as `manufacturer_caption`, `product_state`.`caption` as `product_state_caption`, `ct_for_buy`.`caption` as `ct_for_buy_caption`, `ct_for_sell`.`caption` as `ct_for_sell_caption` from `distributor_product` left join `distributor` on `distributor_product`.`distributor` = `distributor`.`id` left join `manufacturer` on `distributor_product`.`manufacturer` = `manufacturer`.`id` left join `product_state` on `distributor_product`.`product_state` = `product_state`.`id` left join `currency_type` as `ct_for_buy` on `distributor_product`.`currency_type_for_buy` = `ct_for_buy`.`id` left join `currency_type` as `ct_for_sell` on `distributor_product`.`currency_type_for_sell` = `ct_for_sell`.`id` where `distributor_product`.`product` = '1024' order by `distributor`.`caption` asc
select * from `currency_value` order by `currency_value`.`post_date` desc limit 1
select * from `product_article` where `product` = '1024' order by `orderNum` asc