1950 International LM150: Accessory Drive Belt
select distinct p.products_quantity, p.products_weight, p.products_model, p.manufacturers_name, p.products_image, p.products_name, p.products_id, p.manufacturers_id, p.manufacturers_image, p.products_stocked, p.products_price, p.products_core, p.products_tax_class_id, p.products_universal, p.products_remarketing_id, p.products_partnum, p.products_upc, p.products_description, p.products_parttype, p.products_tags from products_search_helper p , products_to_categories p2c , products_ymm pf where pf.products_id = p.products_id AND ( pf.products_car_year_bof <= 1950 AND 1950 <= pf.products_car_year_eof ) AND pf.products_car_make = 'International' AND pf.products_car_model = 'LM150' AND p.products_status = 1 and p.products_id = p2c.products_id and p2c.categories_id = 908900 order by products_stocked DESC , products_vendor_rank ASC , products_parttype ASC , manufacturers_rank ASC, products_partnum ASC
[TEP STOP]