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 = 700 AND ipart_desc = '19772317' AND ipart_make = 23 AND ipart_model = 197721 AND part_price > 249 AND result_qty > 0 AND result_qty > 0 AND result_price > 249 GROUP BY ipart_stock LIMIT 0, 25 HYD REMOTE VALVE & PARTS - HYDRAULICS Parts for John Deere 8210 - Bootheel Tractor Parts - Used Part Finder