gistfile1.sql

use CurtDev;
 
select bv.YearID, ma.MakeName, mo.ModelName, sm.SubmodelName,
		(select GROUP_CONCAT(ca.value) as combined 
				  from VehicleConfigAttribute vca
				  inner join ConfigAttribute ca ON vca.AttributeID = ca.ID
				  where vca.ID in (select vca1.AttributeID FROM VehicleConfigAttribute vca1 where vca1.VehicleConfigID = v.ConfigID)
		) as Config
  			from BaseVehicle bv
				join vcdb_Vehicle v on bv.ID = v.BaseVehicleID
				join vcdb_VehiclePart vp on v.ID = vp.VehicleID
				left join Submodel sm on v.SubModelID = sm.ID
				left join vcdb_Make ma on bv.MakeID = ma.ID
				left join vcdb_Model mo on bv.ModelID = mo.ID
				where vp.PartNumber = 120363
				order by bv.YearID desc, ma.MakeName, mo.ModelName;