Трансмиссия: ZF5HP24 , ZF5HP24A
Название: Drum, F
OEM номер: 1058-277-001
Номер в каталоге:
Описание:
Дополнительные параметры:
Внешний диаметр (OD) : 160.60 мм
Внутренний диаметр (ID) : 36.00 мм
Количество зубьев (z) : 24.00 шт
Толщина (h) : 74.30 мм
Для того чтобы купить или продать деталь АКПП ZF5HP24, ZF5HP24A Корпус сцепления Drum, F OEM номер: 1058-277-001 отправьте сообщение через WhatsApp или SMS, где укажите номер 001057.
contactNumberList
product
productTransmissionList
extraParamList
photoList
productDistributorList
currencyUSD
currencyEUR
productArticlesList
obLevel
__env
app
errors
__currentLoopData
productTransmission
loop
extraParam
productDistributor
photo
select * from `product` where `id` = '1057' 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` = '1057' 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` = '1057' 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` = '1057' 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` = '1057' order by `distributor`.`caption` asc
select * from `currency_value` order by `currency_value`.`post_date` desc limit 1
select * from `product_article` where `product` = '1057' order by `orderNum` asc