SELECT * FROM inv_parts_map INNER JOIN inv_parts ON part_stock_detail = ipart_ref INNER JOIN search ON result_stock_number = part_stock_number INNER JOIN inv_makes ON make_aid = ipart_make INNER JOIN inv_models ON model_aid = ipart_model WHERE ipart_cat = 100 AND ipart_desc = '19772243' AND ipart_make = 23 AND ipart_model = 1977505 AND part_price > 249 AND result_qty > 0 AND result_qty > 0 AND result_price > 249 GROUP BY ipart_stock LIMIT 0, 25 FRONT AXLE COMPLETE - STEERING Parts for John Deere 9630 - Bootheel Tractor Parts - Used Part Finder