SELECT equipments.id,equipments.slug,equipments.model_name,equipments.mpn1,equipments.version, brands.manufacturer_name FROM equipments LEFT JOIN brands ON(equipments.manufacturer_id=brands.id) WHERE 1 AND equipments.is_duplicate = 0 AND ( TRIM(equipments.model_name) IN('7.0AT - TM704 - TM1002 - 2018') ) OR TRIM(equipments.mpn1) IN('7.0AT - TM704 - TM1002 - 2018') AND TRIM(equipments.manufacturer) = 'Johnson Health Technologies' ORDER BY brands.manufacturer_name ASC
Qty
Catalog Number: 970910
Provide an email address, and we will notify you as soon as the part is available, you will get a notification if we receive either a new or used condition version of the part you seek.