DELETE FROM `part-types` WHERE `RefNumber` = 'IR5591' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R816]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5592' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R816]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5593' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R820]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5594' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R820]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5595' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R828]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5596' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R828]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5597' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R740]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5598' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R750]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5599' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R760]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5600' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R761]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5601' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R762]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5602' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R763]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5603' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R812]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5604' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R814]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5605' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R815]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5606' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5607' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R859]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5608' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R742]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5609' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R744]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5610' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R744]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5611' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R746]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5612' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R748]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5613' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R748]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5614' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R754]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5615' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R754]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5616' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R800]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5617' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R802]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5618' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R802]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5619' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R805]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5620' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R805]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5621' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R806]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5622' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R808]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5623' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R808]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5624' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R809]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5625' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R814]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5626' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R814]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5627' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R815]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5628' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R845]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5629' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R845]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5630' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R854]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5631' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R854]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5632' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R854]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5633' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R857]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5634' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5635' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5636' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5637' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R742]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5638' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R744]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5639' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R800]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5640' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R802]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5641' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R805]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5642' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R806]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5643' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R808]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5644' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R809]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5645' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R814]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5646' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R815]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5647' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R816]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5648' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R820]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5649' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R828]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5650' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R845]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5651' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R849]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5652' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R854]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5653' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R854]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5654' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R857]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5655' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R858]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5656' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R858]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5591RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R816]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5592RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R816]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5593RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R820]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5594RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R820]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5595RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R828]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5596RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi GT' AND `Engine` = '[M9R828]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5597RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R740]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5598RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R750]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5599RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R760]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5600RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R761]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5601RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R762]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5602RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R763]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5603RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R812]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5604RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R814]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5605RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R815]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5606RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5607RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10597 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R859]' AND `DateDebut` = '01.2006');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5608RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R742]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5609RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R744]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5610RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R744]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5611RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R746]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5612RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R748]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5613RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R748]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5614RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R754]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5615RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R754]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5616RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R800]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5617RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R802]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5618RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R802]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5619RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R805]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5620RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R805]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5621RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R806]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5622RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R808]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5623RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R808]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5624RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R809]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5625RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R814]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5626RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R814]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5627RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R815]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5628RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R845]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5629RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R845]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5630RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R854]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5631RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R854]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5632RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R854]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5633RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R857]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5634RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5635RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5636RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi' AND `Engine` = '[M9R858]' AND `DateDebut` = '09.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5637RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R742]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5638RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R744]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5639RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R800]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5640RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R802]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5641RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R805]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5642RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R806]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5643RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R808]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5644RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R809]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5645RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R814]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5646RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R815]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5647RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R816]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5648RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R820]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5649RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R828]' AND `DateDebut` = '03.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5650RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R845]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5651RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R849]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5652RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R854]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5653RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R854]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5654RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R857]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5655RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R858]' AND `DateDebut` = '10.2007' AND `DateFin` = '12.2015');
DELETE FROM `part-types` WHERE `RefNumber` = 'IR5656RP' AND `TypeID` = (SELECT `ID` FROM `types` WHERE `ModelID` = 10710 AND `Name` = '2.0 DCi Grandtour' AND `Engine` = '[M9R858]' AND `DateDebut` = '01.2008' AND `DateFin` = '12.2015');