select distinct partnumber from performance where year = "2011" and make = "Ford" and model = "Mustang" select id, name, itemno, smallimage, price = '$' + cast(cast(price as decimal(10,2)) as varchar), shortdesc, saleprice = '$' + cast(cast(saleprice as decimal(10,2)) as varchar), custom1, custom2 from items where itemno in ('15076','15077','15589','15590','15591','15592','15593','15594','15595','15596','16396','16397','16398','16399','16400','16459','16460') and active = 'yes' order by itemno select partno, numgrp, pricedescr, list, map from pies where partno in ('15076','15077','15589','15590','15591','15592','15593','15594','15595','15596','16396','16397','16398','16399','16400','16459','16460') and partno not in ('15076','15077','15589','15590','15591','15592','15593','15594','15595','15596','16398','16399','16400') select partnumber, systemtype, concat(min(year),"-",max(year)," ",make," ",model," ",engine," ",systemtype) as title from performance where partnumber in ('15076','15077','15589','15590','15591','15592','15593','15594','15595','15596','16396','16397','16398','16399','16400','16459','16460') and partnumber not in ('15076','15077','15589','15590','15591','15592','15593','15594','15595','15596','16398','16399','16400','16459','16460') group by partnumber
Magnaflow Catalytic Search at PlanetMagnaflow
'A Preferred Professional Magnaflow Exhaust Dealer'
Magnaflow Stainless Steel 2.5"
Magnapack axleback for the 2011-2012
Mustang V6 3.7L is a mandrel bent
system featuring
Polished QUAD Stainless Steel Tips.