INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'CL', 1997, 1998, 'MBUSD', 'HON92', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'CL 3.0 3.2', 1999, 2003, 'MBUS', 'MBUS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'CSX', 2006, 2011, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'EL', 1997, 2005, 'MBUS', 'MBUS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'Integra', 1992, 2001, 'MBUSD', 'HON92', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'ILX', 2013, 2015, 'HON1', 'HON1', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'ILX', 2013, 2015, 'HON1_HON2V_', '', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'ILX', 2016, 2020, 'HON3', '', '', 'dual screen only', 'dual screen only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'Legend', 1992, 1995, 'MBUSD', 'HON92', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RSX', 2002, 2006, 'MBUS', 'MBUS', 'No Type S, No built-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'MDX', 2001, 2004, 'MBUS', 'MBUS', 'rear seat entertainment or dvd must be disconnected, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'MDX', 2005, 2009, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'MDX', 2010, 2013, 'HON1', 'HON1', '', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'MDX', 2010, 2013, 'HON1_HON2M_', 'HON2', '', 'NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'MDX', 2014, 2020, 'HON3', '', '', 'dual screen only', 'dual screen only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'NSX', 1991, 2005, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RDX', 2007, 2012, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RDX', 2013, 2015, 'HON2V', 'HON2', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RDX', 2016, 2018, 'HON3', 'HON3', '', 'dual screen only', 'dual screen only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RL', 2003, 2004, 'HON1', 'HON1', 'Must have SAT button, only NAV stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RL', 2005, 2012, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'RLX', 2014, 2020, 'HON3', 'HON3', '', 'dual screen only', 'dual screen only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'SLX', 1996, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TL', 1996, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TL', 1999, 2003, 'MBUS', 'MBUS', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TL', 2004, 2008, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TL', 2009, 2014, 'HON1', 'HON1', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TL', 2012, 2015, 'HON1_HON2V_', 'HON2', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TL', 2009, 2011, 'HON1_HON2_', 'HON2', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TLX', 2014, 2020, 'HON3', 'HON3', '', 'dual screen only', 'dual screen only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TSX', 2004, 2010, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TSX', 2011, 2014, 'HON1', 'HON1', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'TSX', 2011, 2014, 'HON1_HON2M_', 'HON2', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'Vigor', 1992, 1994, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Acura', 'ZDX', 2010, 2013, 'HON2M', 'HON2', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Alfa Romeo', 'any model', 2000, 2012, 'BPT', 'BPT', 'Blaupunkt stereo, 376, 378, 379, 937, 947', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A2', 1999, 2005, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A3', 2003, 2006, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A3', 2007, 2009, 'AUD', 'SD', 'no MMI, no SAT', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4', 1998, 2005, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4', 2006, 2008, 'AUD', 'SD', 'NO MMI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4 Quattro', 1998, 2005, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4 Quattro', 2006, 2008, 'AUD', 'SD', 'NO MMI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4', 2009, 2009, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4', 2009, 2009, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'Concept or Symphony' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A4', 2010, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A5', 2009, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A6', 2001, 2004, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A6 Quattro', 2001, 2004, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A6', 2005, 2009, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A6 Avant', 2005, 2005, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A6 Allroad', 2006, 2008, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A8', 1999, 2002, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A8 Quattro', 1999, 2002, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'A8', 2004, 2008, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'Allroad Quattro', 2001, 2004, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'Allroad', 2009, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'Avant', 2009, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'Q5', 2009, 2017, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'Q7', 2007, 2009, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'RS4', 2007, 2008, 'AUD', 'SD', 'NO MMI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'RS5', 2009, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'RS6', 2008, 2009, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S4', 2000, 2005, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S4', 2006, 2008, 'AUD', 'SD', 'NO MMI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S4', 2009, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S5', 2009, 2016, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S6', 2002, 2003, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S6', 2007, 2009, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S8', 2001, 2002, 'AUD', 'SD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'S8/R8', 2008, 2009, 'AUDO4', 'POF', 'MMI 2G High, MP3 support, MMI SW:33.6.0 and up', '', 'MMI 2G High' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'SQ5', 2009, 2017, 'AUDC_', 'SD', '', 'Concert or Symphony Radio 6.5 inch Screen', 'No nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'TT', 2000, 2008, 'AUD', 'SD', 'NO MMI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Audi', 'TT Quattro', 2000, 2008, 'AUD', 'SD', 'NO MMI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Bentley', 'Continental GT', 2004, 2009, 'VAGT', 'VAGT', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Bentley', 'Flying Spur', 2005, 2009, 'VAGT', 'VAGT', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Blaupunkt', 'All Blaupunkt', 2000, 2012, 'BPT', 'BPT', 'stereos with MiniISO connector for CD changer ', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Blaupunkt', 'MPxx CDxx Cxx DJxx DABxx', 2000, 2012, 'BPT', 'BPT', 'stereos with MiniISO connector for CD changer ', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series', 1999, 2005, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series', 1999, 2005, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series Coupe, Convertible', 2006, 2006, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series Coupe, Convertible', 2006, 2006, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series Sedan, Vagon', 2006, 2006, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series', 2007, 2010, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '3 series', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '5 series', 1997, 2003, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '5 series', 1997, 2003, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '5 series', 2005, 2010, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '5 series', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '7 series', 1999, 2001, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '7 series', 1999, 2001, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', '7 series', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M Coupe', 1999, 2002, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M Coupe', 1999, 2002, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M Series', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M Roadster', 1999, 2002, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M Roadster', 1999, 2002, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M3', 1997, 2006, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M3', 1997, 2006, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M3', 2007, 2010, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M5', 2000, 2003, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M5', 2000, 2003, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'M5', 2004, 2010, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X3', 2004, 2010, 'BMWT', 'BMWT', 'All, *05+ see below', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X3', 2004, 2010, 'BMWS', 'BMWS', 'No Nav or DSP, *05+ see below', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X3', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X5', 2000, 2006, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X5', 2000, 2006, 'BMWS', 'S', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X5', 2007, 2010, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X5', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X6', 2008, 2014, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'X6', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z3', 1997, 2002, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z3', 1997, 2002, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z4', 2003, 2008, 'BMWT', 'BMWT', 'All, *06+ see below', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z4', 2003, 2008, 'BMWS', 'BMWS', 'No Nav or DSP, *06+ see below', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z4', 2009, 2010, 'BMWO4', 'POF', 'Must have MP3 CDC capability', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z4', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z8', 2000, 2003, 'BMWT', 'BMWT', 'All', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'BMW', 'Z8', 2000, 2003, 'BMWS', 'BMWS', 'No Nav or DSP', '', 'No Nav or DSP' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'Cascada', 2016, 2019, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'Encore', 2013, 2016, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'Enclave', 2008, 2011, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'LaCrosse', 2010, 2013, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'Lucerne', 2006, 2011, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'Regal', 2011, 2013, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Buick', 'Verano', 2012, 2017, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Cadillac', 'CTS/CTS V', 2008, 2015, 'GM1C_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Cadillac', 'DTS', 2006, 2011, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Cadillac', 'Escalade', 2007, 2013, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Cadillac', 'SRX', 2007, 2009, 'GM', 'GM08', 'not USB ready radio, must have CAT button, no rear seat entertainment', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Cadillac', 'SRX', 2010, 2012, 'GM1S', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Avalanche', 2007, 2013, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Camaro', 2010, 2015, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Caprice', 2014, 2017, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Cruze', 2011, 2015, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Equinox', 2007, 2009, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Equinox', 2010, 2017, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Express', 2009, 2014, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Impala', 2007, 2013, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Malibu', 2013, 2015, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Monte Carlo', 2006, 2007, 'GM', 'GM08', 'must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Orlando', 2013, 2014, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Silverado', 2007, 2013, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'SS', 2014, 2017, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Suburban', 2007, 2013, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Tahoe', 2007, 2014, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Traverse', 2009, 2012, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chevrolet', 'Volt', 2011, 2015, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', '200', 2015, 2018, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', '300', 2015, 2022, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', '300M', 2002, 2004, 'CHR02', 'CHR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'Concord', 2002, 2004, 'CHR02', 'CHR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'LHS', 2002, 2004, 'CHR02', 'CHR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'Pacifica', 2017, 2020, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'PT Cruiser', 2002, 2005, 'CHR02', 'CHR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'Sebring', 2002, 2005, 'CHR02', 'CHR', 'sedan and convertible only', '', 'sedan/convertible' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'Town Country', 2002, 2005, 'CHR02', 'CHR', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'Voyager', 2002, 2005, 'CHR02', 'CHR', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Chrysler', 'Voyager', 2020, 2020, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Citroen', 'Aircross', 2012, 2014, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Citroen', 'C-Crosser', 2007, 2012, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Caravan', 2002, 2005, 'CHR02', 'CHR', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Challenger', 2015, 2022, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Charger', 2015, 2022, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Dakota', 2002, 2004, 'CHR02', 'CHR', 'Must have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Durango', 2002, 2003, 'CHR02', 'CHR', 'Must have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Durango', 2014, 2020, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Intrepid', 2003, 2004, 'CHR02', 'CHR', 'Must have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Neon', 2002, 2005, 'CHR02', 'CHR', 'Must have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'RAM', 2002, 2005, 'CHR02', 'CHR', 'Must have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Stratus', 2002, 2005, 'CHR02', 'CHR', 'Sedan only, must have MODE button', '', 'Sedan' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Viper', 2002, 2006, 'CHR02', 'CHR', 'SRI-10 production', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Dodge', 'Viper', 2013, 2017, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', '500', 2007, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Bravo II', 2007, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Croma', 2007, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Multipla', 2007, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Panda', 2003, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Grande Punto', 2005, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Punto EVO', 2010, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Fiat', 'Sedici', 2006, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Edge', 2007, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Escape (Hybrid)', 2008, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Expedition', 2007, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Explorer', 2006, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'F-x50 trucks', 2008, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Five Hundred', 2006, 2007, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Focus', 2006, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Freestyle', 2006, 2007, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Fusion', 2005, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Mustang', 2007, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Mustang', 2010, 2014, 'FRD', 'FRD07', 'no Sync, no SAT, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Taurus(X)', 2008, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'C-Max', 2003, 2007, 'FRDEU', 'FRDEU', 'serial starts with M, L, A, N', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Fiesta Mk5', 2005, 2008, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Fiesta Mk5', 2009, 2010, 'FRDEU', 'FRDEU', 'serial starts with M, L, A, N', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Fusion', 2002, 2002, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Focus Mk2', 2004, 2007, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Galaxy', 2006, 2007, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Mondeo Mk3', 2003, 2007, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'S-Max', 2006, 2006, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Transit', 2006, 2007, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Transit', 2009, 2012, 'FRDEU', 'FRDEU', 'serial starts with M, L, A, N', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Tourneo', 2006, 2007, 'FRDEU', 'FRDEU', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Ford', 'Tourneo Connect', 2009, 2010, 'FRDEU', 'FRDEU', 'serial starts with M, L, A, N', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Acadia', 2007, 2012, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Savana', 2008, 2012, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Sierra', 2007, 2012, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Terrain', 2010, 2015, 'GM1_', '', '', 'Mylink 7-inch screen', 'Mylink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Yukon', 2007, 2012, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Yukon Denali', 2007, 2009, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'GMC', 'Yukon XL', 2007, 2009, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Accord', 1992, 1997, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Accord', 1998, 2002, 'MBUS', 'MBUS', 'no CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Accord', 2003, 2012, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Accord', 2013, 2017, 'HON3', 'HON3', '', 'Navigation only', 'with Navigation' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Civic', 1992, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Civic', 1999, 2005, 'MBUS', 'MBUS', 'no built-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Civic', 2006, 2014, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Civic del Sol', 1993, 1997, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'CR-V', 1997, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'CR-V', 1999, 2004, 'MBUS', 'MBUS', 'no built-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'CR-V', 2005, 2014, 'HON1', 'HON1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'CR-Z', 2010, 2015, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Element', 2003, 2012, 'HON1', 'HON1M', 'Double Din, 4 inch stereo', '', 'DoubleDin' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Element', 2003, 2012, 'MBUS', 'MBUS', 'Single Din, 2 inch stereo', '', 'SingleDin' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'EV Plus', 1998, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Fit Jazz', 2006, 2014, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Fit Jazz', 2001, 2005, 'MBUS', 'MBUS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Goldwing', 2001, 2010, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Insight', 1999, 2006, 'MBUS', 'MBUS', 'no build-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Insight', 2008, 2014, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 1995, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 1999, 2004, 'MBUS', 'MBUS', 'no build-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 2005, 2010, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 2011, 2012, 'HON1', 'HON1M', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 2011, 2012, 'HON1_HON2M_', 'HON1M', '', 'Navi stereo only', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 2013, 2013, 'HON2M', 'VHA8A', '', 'Navi stereo only', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Odyssey', 2014, 2017, 'HON3', 'HON3', '', 'dual screen only', 'dual screen only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Passport', 1994, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Pilot', 2003, 2005, 'MBUS', 'MBUS', 'no build-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Pilot', 2006, 2014, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Pilot', 2012, 2015, 'HON2M', 'VHA8A', '', 'Only NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Prelude', 1992, 1998, 'MBUSD', 'HON92', 'CD changer capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Prelude', 1999, 2002, 'MBUS', 'MBUS', 'no build-in CD changer', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'Ridgeline', 2006, 2013, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'S2000', 2000, 2003, 'MBUS', 'MBUS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Honda', 'S2000', 2004, 2012, 'HON1', 'HON1M', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Hummer', 'Hummer H2', 2008, 2009, 'GM', 'GM08', 'not USB ready radio, must have CAT button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Hyundai', 'Elantra', 2008, 2009, 'HYU', 'HYU08', 'XM capable radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Hyundai', 'Accent', 2008, 2008, 'HYU', 'HYU08', 'XM capable radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Hyundai', 'Azera', 2007, 2008, 'HYU', 'HYU08', 'XM capable radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Hyundai', 'Entourage', 2008, 2008, 'HYU', 'HYU08', 'XM capable radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Hyundai', 'Veracruz', 2007, 2008, 'HYU', 'HYU08', 'XM capable radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'EX35', 2005, 2007, 'NIS02', 'NIS02', 'CAT/SAT should be on stere, no NAV', '', 'no NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'EX35', 2008, 2009, 'NIS8', 'NIS02', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'EX35 EX37', 2008, 2010, 'NISK_NIS02_', 'C-MCFNISK', 'CAT/SAT should be on stere, no NAV', 'no NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'EX35 EX37', 2010, 2013, 'NIS9', 'NIS02', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'EX35 EX37', 2011, 2013, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2003, 2008, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2003, 2008, 'NISCDC', 'NIS02', 'no CAT/SAT button', '', 'no CAT/SAT button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2009, 2010, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo, no NAV', '', 'CAT/SAT button, no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2009, 2009, 'NIS8', 'NIS02', '', 'NAV stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2009, 2009, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2010, 2013, 'NIS9_', '', 'IPOD ready stereo', 'NAV stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'FX35 FX45 FX50', 2010, 2013, 'NISK_', 'C-MCFNISK', 'IPOD ready stereo', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G20', 1999, 2001, 'NISCDC', 'NIS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Coupe', 2003, 2007, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Coupe', 2008, 2009, 'NIS8', 'NIS02', '', 'NAV stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Coupe', 2008, 2009, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Coupe', 2010, 2013, 'NIS9_', 'C-MCFNIS9', 'IPOD ready stereo', 'NAV stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Coupe', 2010, 2013, 'NISK_', 'C-MCFNISK', 'IPOD ready stereo', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Sedan', 2003, 2006, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Sedan', 2007, 2007, 'NISK_NIS02_', 'NIS02', 'CAT/SAT should be on stereo, no NAV', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Sedan', 2007, 2009, 'NIS8', 'NIS02', '', 'NAV stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Sedan', 2008, 2009, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Sedan', 2010, 2013, 'NIS9_', 'C-MCFNIS9', 'IPOD ready stereo', 'NAV stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G35 G35S Sedan', 2010, 2013, 'NISK__', 'C-MCFNISK', 'IPOD ready stereo', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G37 G37S', 2008, 2009, 'NIS8', 'C-MCFNIS8', '', 'NAV stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G37 G37S', 2008, 2009, 'NISK_NIS02_', 'C-MCFNISK', 'CAT/SAT should be on stereo/ no NAV', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G37 G37S', 2010, 2013, 'NIS9_', 'C-MCFNIS9', 'IPOD ready stereo', 'NAV Stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G37 G37S', 2010, 2013, 'NISK_NIS02_', 'C-MCFNISK', 'CAT/SAT should be on stereo/ no NAV', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Convertible', 2009, 2009, 'NIS8', 'C-MCFNIS8', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Convertible', 2010, 2013, 'NIS9', 'C-MCFNIS9', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Convertible', 2010, 2013, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Coupe', 2010, 2013, 'NIS9', 'C-MCFNIS9', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Coupe', 2010, 2013, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Sedan', 2010, 2013, 'NIS9', 'C-MCFNIS9', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'G Sedan', 2010, 2013, 'NISK', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'I30 I35', 1999, 2001, 'NISCDC', 'NIS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'I30 I35', 2002, 2004, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo/no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'JX', 2013, 2013, 'NIS9', 'NIS02', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'M35 M45', 2006, 2007, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'M35 M45', 2008, 2010, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo/no NAV', '', 'no NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'M35 M45', 2008, 2010, 'NIS8', 'NIS02', '', 'NAV stereo', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'M37 M56', 2011, 2013, 'NIS9', 'C-MCFNIS9', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q40', 2014, 2014, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo/no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q40', 2015, 2015, 'NIS9_', 'C-MCFNIS9', '', 'Nav stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q40', 2015, 2015, 'NISK_', 'C-MCFNISK', '', 'No NAV', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q45', 1997, 2001, 'NISCDC', 'NIS02', 'must have CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q60 Coupe', 2014, 2015, 'NIS9', 'NIS02', '', 'NAV stereo', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q60 Convertible', 2014, 2015, 'NIS9', 'NIS02', '', 'NAV stereo', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q70', 2011, 2013, 'NIS9', 'C-MCFNIS9', '', 'NAV stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'Q70', 2014, 2017, 'NIS9_', 'NIS02', 'IPOD ready stereo', 'Nav stereo', 'Nav steereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX4', 1999, 2001, 'NISCDC', 'NIS02', 'must have CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX56', 2004, 2006, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX56', 2007, 2009, 'NIS02', 'NIS02', 'CAT/SAT should be on stereo/no NAV', '', 'no NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX56', 2008, 2010, 'NIS8', 'NIS02', '', 'NAV stereo', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX56', 2011, 2013, 'NIS9_', 'NIS02', '', 'Nav stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX50', 2014, 2017, 'NIS9_', 'NIS02', '', 'Nav stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX60', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX60', 2014, 2016, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX70', 2014, 2017, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX70', 2014, 2017, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX80', 2014, 2017, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Infiniti', 'QX80', 2014, 2017, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav stereo', 'Nav stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Compass', 2017, 2021, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Cherokee', 2014, 2022, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Grand Cherokee', 2002, 2004, 'CHR02', 'CHR', 'Must Have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Grand Cherokee', 2014, 2021, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Liberty', 2002, 2007, 'CHR02', 'CHR', 'Must Have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Renegade', 2015, 2022, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Jeep', 'Wrangler', 2002, 2006, 'CHR02', 'CHR', 'Must Have MODE button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lancia', 'Musa', 2004, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lancia', 'Ypsilon', 2003, 2012, 'BPT', 'BPT', 'Blaupunkt stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'CT 200H', 2011, 2012, 'LEX6RT', 'MCFLEX6F', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'CT 200H', 2013, 2016, 'LEX78', 'MCFLEX89', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'CT 200H', 2014, 2017, 'LEXK', 'MCFLEXK', '', 'No Navi', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'CT 200H', 2017, 2017, 'LEX78', 'MCFLEX89', '', 'Navi, US only', 'Nav, US only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'CT 200H', 2017, 2020, 'LEX9L', 'MCFLEX9', '', 'Navi, non-US only', 'Nav, non-US only' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'HS 250H', 2010, 2012, 'LEX6RT', 'MCFLEX6F', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 1999, 2000, 'TOYF', 'TOYF', 'non-Nakamichi stereo only', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2001, 2001, 'TOYF_LEX3_', 'TOYF', 'non-Nakamichi stereo only', 'Navi, non-Nakamichi stereo only', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2001, 2001, 'TOYF', 'TOYF', 'non-Nakamichi stereo only', '', 'no-Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2002, 2003, 'TOYO', 'TOY1', '', '', 'no-Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2002, 2003, 'TOYO_LEX3_', 'MCFTOY1', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2004, 2004, 'TOYL', 'LEX', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2005, 2006, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2007, 2009, 'TOYN', 'TOY', '', '', 'no LCD Screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300 330 350', 2007, 2009, 'TOYN_LEX5_', 'TOY', '', 'LCD Screen', 'LCD Screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 350', 2010, 2012, 'LEX6_', 'MCFLEX6', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300h 350', 2013, 2014, 'LEXKL', 'MCFLEXKL', '', 'No-Navi', 'no-Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300h 350', 2013, 2018, 'LEX78_', 'MCFLEX789', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'ES 300h 350', 2019, 2022, 'LEX9_', 'MCFLEX789', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GS 300 430', 2001, 2005, 'TOYO_LEX3_', 'TOY1', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GS 300 350 430 450H 460', 2006, 2006, 'TOYN_LEXGS_', 'TOY', '', 'All', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GS 350 430 450H 460', 2007, 2009, 'TOYN_LEX5_', 'TOY', '', 'LCD Screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GS 350 430 450H 460', 2010, 2011, 'LEX6_', 'TOY', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GS 350 430 450H 460', 2012, 2015, 'LEX78_', 'TOY', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GS 200t 350 450h GS F', 2016, 2020, 'LEX78_', 'MCFLEX89', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 470', 2003, 2004, 'TOYL_LEXGX_', 'LEX', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 470', 2005, 2006, 'TOYN_LEX4_', 'TOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 470', 2007, 2009, 'TOYN_LEX5_', 'TOY', '', 'LCD Screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 460', 2010, 2013, 'LEX6_', 'TOY', '', 'NAV', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 460', 2014, 2021, 'LEX78T_', 'TOY', '', 'NAVI', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 460', 2014, 2018, 'LEXK_', 'TOY', '', 'no NAVI', 'no-Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'GX 460', 2022, 2023, 'LEX9_', 'TOY', '', 'NAVI', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 200 250 300', 1999, 2001, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 200 250 300', 2002, 2005, 'TOYL', 'TOY1', 'no-Navi', '', 'no-Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 200 250 300', 2002, 2005, 'TOYL_LEX3_', 'TOY1', 'Navi', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 250 350 IS F', 2006, 2009, 'TOYN_LEX5_', 'TOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 250 350 IS F', 2010, 2013, 'TOYN', 'TOY', 'No Navigation', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 250 350 IS F C', 2010, 2012, 'LEX6_', 'TOY', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 250C 350C F', 2013, 2015, 'LEX78T_', 'TOY', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 200t 250 300 350', 2013, 2016, 'LEX78_', 'MCFLEX89', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 200t 250 300 350', 2014, 2019, 'LEXK', 'MCFLEXK', '', 'No Navi', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 200t 250 300 350 F', 2017, 2020, 'LEX9L_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 300 350', 2021, 2023, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'IS 500', 2022, 2023, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LFA', 2012, 2012, 'LEX6RT_', 'TOYF', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LC 500 500h', 2017, 2017, 'LEX9_', 'MCFLEX789', '', 'non-US only, NAV', 'non-US only, NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LC 500 500h', 2018, 2023, 'LEX9_', 'MCFLEX789', '', 'NAV', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 430', 2001, 2003, 'TOYL', 'LEX', 'non-Nakamichi stereo only', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 430', 2001, 2003, 'LEX3L_', 'TOY1', '', 'Navigation only', 'NAVI' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 430', 2004, 2006, 'TOYN_LEX4_', 'TOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 430', 2007, 2007, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 460', 2007, 2009, 'LEX5LS_', 'MCFTOY', '', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 600h', 2008, 2009, 'LEX5_', 'MCFTOY', '', 'LCD Screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 460 600h', 2010, 2012, 'LEX6_', 'MCFLEX6', '', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 460 600hl', 2013, 2017, 'LEX78_', 'MCFLEX789', '', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 460 600hl', 2018, 2020, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LS 500 500h', 2021, 2022, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 470', 2001, 2002, 'TOYO_', 'TOY1', 'non-Nakamichi stereo only', '', 'non-Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 470', 2001, 2002, 'TOYO_LEX3L_', 'TOY1', 'non-Nakamichi stereo only', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 470', 2003, 2003, 'TOYL_LEX3L_', 'TOYL', 'non-Nakamichi stereo only', 'Navi', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 470', 2003, 2003, 'TOYL_', 'TOYL', 'non-Nakamichi stereo only', 'Navi', 'non-Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 470', 2004, 2007, 'TOYN_LEX4_', 'TOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 570', 2008, 2009, 'TOYN_LEX5_', 'MCFTOY', '', 'LCD Screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 570', 2010, 2011, 'LEX6_', 'MCFTOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 570', 2013, 2015, 'LEX78T_', 'MCFLEX7T', '', 'Navi', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'LX 570', 2016, 2020, 'LEX78_', 'MCFLEX789', '', 'Navi', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'NX 200t 300h', 2015, 2017, 'LEX78_', 'MCFLEX789', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'NX 200t 300h', 2015, 2018, 'LEXK_', 'MCFLEXK', '', 'No Navi', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'NX 200t 300h', 2018, 2020, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'NX 300 300h', 2021, 2021, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RC 200t 250 300 350 RC F', 2015, 2017, 'LEX78', 'MCFLEX89', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RC 200t 250 300 350 RC F', 2015, 2018, 'LEXK', 'MCFLEXK', '', 'No Navi', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RC 200t 250 300 350 RC F', 2018, 2020, 'LEX9', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RC 300 330 350', 2021, 2022, 'LEX9', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 300', 1999, 1999, 'TOYF', 'TOYF', 'non-Nakamichi stereo only', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 300', 2000, 2003, 'TOYF_LEX3L_', 'TOYF', 'non-Nakamichi stereo only', 'Navi, non-Nakamichi stereo only', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 300', 2000, 2003, 'TOYF_', 'TOYF', 'non-Nakamichi stereo only', '', 'no-Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 330 350 400H', 2004, 2009, 'TOYN', 'TOY', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 330 350 400H', 2004, 2005, 'TOYN_LEXGX_', 'TOY', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 330 350 400H', 2006, 2006, 'TOYN_LEX4_', 'TOY', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 350 400H', 2007, 2009, 'TOYN_LEX5_', 'MCFTOY', '', 'LCD Screen', 'LCD Screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 350 450H', 2010, 2012, 'LEX6RT_', 'MCFLEX6RT', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 350 450H', 2013, 2015, 'LEXKL', 'MCFLEXKL', '', 'no-Nav', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 350 450H', 2013, 2019, 'LEX78_', 'MCFLEX789', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 350 450H', 2016, 2019, 'LEXK_', 'MCFLEXK', '', 'No Navi', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'RX 350 350L 450H 450HL', 2020, 2022, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'SC 430', 2005, 2009, 'TOYO_LEXSC_', 'TOY1', '', 'LCD Screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lexus', 'UX 200 250H', 2019, 2022, 'LEX9_', 'MCFLEX9', '', 'Navi', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lincoln', 'Mark LT', 2006, 2008, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lincoln', 'MKX', 2007, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lincoln', 'MKZ', 2007, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lincoln', 'Navigator', 2007, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Lincoln', 'Zephyr', 2005, 2006, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', '3', 2010, 2012, 'MAZ8', 'MAZM', 'MP3 stereo', '', 'MP3 stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', '3', 2003, 2008, 'MAZ', 'MAZ02', '*', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', '5', 2005, 2008, 'MAZ', 'MAZ02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', '6', 2003, 2008, 'MAZ', 'MAZ02', '03-05 may require change on the radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', '6', 2009, 2012, 'MAZ8', 'MAZ02', 'Should have AUX button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', '5', 2009, 2012, 'MAZ8', 'MAZM', 'MP3 stereo', '', 'MP3 stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'Miata MX5', 2002, 2008, 'MAZ', 'MAZ02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'MPV', 2002, 2008, 'MAZ', 'MAZ02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'Protege', 2002, 2003, 'MAZ', 'MAZ02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'RX-8', 2004, 2008, 'MAZ', 'MAZ02', 'radio firmware v9.55 or later /v10.01 and v9.81 not supported/', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'Tribute', 2002, 2006, 'MAZ', 'MAZ02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'BT 50', 2006, 2008, 'MAZ', 'MAZ02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'CX-7', 2007, 2008, 'MAZ', 'MAZ02', 'no navigation', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'CX-7', 2009, 2012, 'MAZ8', 'MAZ02', 'no navigation', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'CX-9', 2007, 2008, 'MAZ', 'MAZ02', 'no navigation', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mazda', 'B-series', 2003, 2008, 'MAZ', 'MAZ02', 'not navigation', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'A-Class', 2004, 2008, 'MBO4', 'POF', 'W169', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'A-Class', 2012, 2014, 'MB45', 'MCFMB45', '', 'W176', 'W176' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'B-Class', 2005, 2009, 'MBO4', 'POF', 'W245', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'B-Class', 2012, 2014, 'MB45', 'MCFMB45', '', 'W246', 'W246' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'C-Class', 2005, 2007, 'MBO4', 'POF', 'W203', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'C-Class', 2012, 2013, 'MB45', 'MCFMB45', '', 'W204,S204', 'W204/S204' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLA-Class', 2013, 2016, 'MB45', 'MCFMB45', '', 'C117', 'C117' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLC-Class', 2012, 2015, 'MB45', 'MCFMB45', '', 'C204', 'C204' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLK-Class', 2004, 2008, 'MBO4', 'POF', 'C209, W209', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLK-Class', 2012, 2016, 'MB45', 'MCFMB45', '', 'C207', 'C207' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLS-Coupe', 2004, 2008, 'MBO4', 'POF', 'W219', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLS-Class', 2012, 2015, 'MB45', 'MCFMB45', '', 'X218', 'X218' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E-Class', 2004, 2008, 'MBO4', 'POF', 'W211', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E-Class', 2012, 2016, 'MB45', 'MCFMB45', '', 'S212', 'S212' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E-Class', 2013, 2016, 'MB45', 'MCFMB45', '', 'V212', 'V212' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E-Class', 2012, 2016, 'MB45', 'MCFMB45', '', 'W212', 'W212' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'G-Class', 2013, 2018, 'MB45', 'MCFMB45', '', 'W463', 'W463' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'GL-Class', 2006, 2008, 'MBO4', 'POF', 'X164', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'GLE-Class', 2012, 2014, 'MB45', 'MCFMB45', '', 'W116', 'W116' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'GLK-Class', 2012, 2014, 'MB45', 'MCFMB45', '', 'X204', 'X204' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'ML-Class', 2006, 2008, 'MBO4', 'POF', 'W164', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'R-Class', 2006, 2008, 'MBO4', 'POF', 'W251', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'S-Class', 2004, 2006, 'MBO4', 'POF', 'W2200', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SL-Class', 2012, 2014, 'MB45', 'MCFMB45', '', 'R231', 'R231' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SLC-Class', 2011, 2015, 'MB45', 'MCFMB45', '', 'R171', 'R171' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SLC-Class Roadster', 2011, 2015, 'MB45', 'MCFMB45', '', 'R172', 'R172' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SLK-Class', 2004, 2008, 'MBO4', 'POF', 'R171', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SLK-Class', 2011, 2015, 'MB45', 'MCFMB45', '', 'R171', 'R171' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SLK-Class Roadster', 2011, 2015, 'MB45', 'MCFMB45', '', 'R172', 'R172' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'C220', 1994, 1998, 'MB', 'MB', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'C36 AMG', 1995, 1997, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'C43 AMG', 1998, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CL500', 1998, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CL600', 1998, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'CLK320', 1998, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E300', 1995, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E320', 1994, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E420', 1994, 1997, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E430', 1998, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'E500', 1994, 1994, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'S320', 1994, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'S600', 1994, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SL320', 1994, 1997, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SL500', 1994, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SL600', 1994, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercedes', 'SLK230', 1998, 1998, 'MB', 'MBA', 'CDC Capable', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercury', 'Sable', 2008, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercury', 'Mountaineer', 2006, 2010, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercury', 'Milan', 2006, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercury', 'Mariner', 2008, 2009, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mercury', 'Montego', 2006, 2007, 'FRD', 'FRD07', 'MP3 stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mini', 'Cooper', 2002, 2005, 'BMWT', 'BMWT', '', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mini', 'Cooper', 2002, 2005, 'BMWS', 'BMWS', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mini', 'Cooper Convertible R52/R53', 2004, 2008, 'BMWT', 'BMWT', '', '', 'All' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mini', 'Cooper Convertible R52/R53', 2004, 2008, 'BMWS', 'BMWS', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mini', 'Cooper R56', 2006, 2013, 'BMWO4', 'POF', 'Must have MP3 CDC capability, only Silver CD Drive compatible', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mini', 'Cooper R56', 2011, 2017, 'WLQ1MU_WLQ1TC_', '', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', '3000GT', 1998, 1999, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Diamante', 1998, 2004, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Galant', 1998, 2009, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Outlander', 2003, 2006, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Endeavor', 2004, 2012, 'MITS02', 'MITS02', 'will lose DVD/rear seat entertainment', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Mirage', 1997, 2002, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Lancer', 2002, 2007, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Eclipse', 2000, 2012, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Montero', 1998, 2005, 'MITS02', 'MITS02', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Lancer', 2008, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Outlander', 2007, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'Outlander Sport', 2011, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'I-MiEV', 2012, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'RVR', 2010, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Mitsubishi', 'ASX', 2011, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', '200SX', 1999, 2001, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', '350Z', 2002, 2003, 'NISCDC', 'NIS02', 'must have CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', '350Z', 2004, 2008, 'NIS02', 'NIS02', 'CAT/SATimprinted on stereo, for 2009 - No Navigation', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', '370Z', 2009, 2014, 'NIS02', 'NIS02', 'CAT/SATimprinted on stereo, No Navigation', '', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', '370Z Coupe Roadster', 2009, 2009, 'NIS8', 'MCFNIS8', '', 'NAV stereo', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', '370Z Coupe Roadster', 2010, 2017, 'NIS9_', 'MCFNIS9', '', 'Nav Stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima', 1999, 2001, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima', 2005, 2006, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo, BOSE only', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima Sedan', 2007, 2012, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo, no nav', '', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima Sedan', 2009, 2012, 'WLQ1MU_WLQ1TC_', 'NIS02', 'iPod Ready Stereo', '', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima Sedan', 2013, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'iPod Ready Stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima Coupe', 2008, 2013, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo, no nav', '', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima Coupe', 2009, 2013, 'WLQ1MU_WLQ1TC_', 'NIS02', 'iPod Ready Stereo', '', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Altima Coupe', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'iPod Ready Stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Armada', 2008, 2012, 'NIS8', 'NIS02', '', 'NAV stereo', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Armada', 2013, 2017, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'NAV stereo', 'NAV Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Armada', 2013, 2017, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Frontier Pickup', 2004, 2010, 'NIS02', 'NIS02', 'BOSE, with CAT/SAT on the stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Frontier Pickup', 2011, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'GT-R', 2009, 2010, 'NIS8', 'NIS02', '', 'NAV stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'GT-R', 2009, 2010, 'WLQ1MU_WLQ1TC_', 'NIS02', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'GT-R', 2011, 2016, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'USB IPOD ready stereo', 'Nav stereo', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'GT-R', 2011, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'USB IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 1999, 2001, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2002, 2003, 'NISCDC', 'NIS02', 'Single CD player radio only', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2004, 2008, 'NIS02', 'NIS02', 'CAT/SATimprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2009, 2010, 'NIS02', 'NIS02', 'CAT/SATimprinted on stereo', '', 'No NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2009, 2009, 'NIS8', 'NIS02', '', 'NAV Stereo', 'NAV' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2010, 2014, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav Stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2010, 2014, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Maxima', 2015, 2017, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Murano', 2004, 2008, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Murano No NAV', 2009, 2010, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo, no NAV', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Murano NAV', 2009, 2010, 'NIS8', 'NIS02', '', 'NAV stereo', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Murano', 2011, 2014, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav Stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Murano', 2011, 2014, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Murano', 2015, 2017, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Pathfinder LE', 1999, 2001, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Pathfinder LE', 2004, 2009, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Pathfinder LE', 2008, 2012, 'NIS8', 'NIS02', '', 'NAV Stereo', 'NAV stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Pathfinder', 2013, 2016, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav Stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Pathfinder', 2013, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Pathfinder', 2013, 2018, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Rogue', 2007, 2010, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Rogue', 2011, 2017, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Quest', 2004, 2010, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Quest', 2011, 2016, 'NIS9_WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', 'Nav Stereo', 'Nav Stereo' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Quest', 2011, 2016, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', 'no Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Quest', 2017, 2018, 'WLQ1MU_WLQ1TC_', 'NIS02', 'IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Sentra', 1999, 2007, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Sentra', 2008, 2009, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Skyline 250GT/300GT/350GT', 2001, 2008, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Titan', 2004, 2010, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Versa', 2007, 2009, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Xterra', 1999, 2006, 'NISCDC', 'NIS02', 'double DIN with CD/CHG button', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Nissan', 'Xterra', 2007, 2010, 'NIS02', 'NIS02', 'CAT/SAT imprinted on stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Peugeot', '4007', 2007, 20012, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Peugeot', '4008', 2012, 2013, 'MITS08', 'MITS08', 'no navigation, no touchscreen', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Pontiac', 'Torrent', 2007, 2009, 'GM', 'GM08', 'not USB ready radio, must have SAT', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Pontiac', 'Vibe', 2009, 2010, 'GM', 'GM08', 'not USB ready radio, must have SAT', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'RAM', '1500', 2013, 2018, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'RAM', '2500', 2013, 2018, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'RAM', '3500', 2013, 2018, 'CHRU', 'C-MCFCHRU', '', '8.4 inch screen, backup cam', '8.4 inch screen, backup cam' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Rover', 'Rover 75', 1999, 2005, 'RVR', 'C-RVR', 'Alpine stereos, no nav', '', 'Alpine stereos, no nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Rover', 'Rover MG', 2001, 2005, 'RVR', 'C-RVR', 'Alpine stereos, no nav', '', 'Alpine stereos, no nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Rover', 'LANDROVER ZT', 2002, 2004, 'RVR', 'C-RVR', 'Alpine stereos, no nav', '', 'Alpine stereos, no nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Rover', 'Discovery', 2000, 2004, 'RVR', 'C-RVR', 'Alpine stereos, no nav', '', 'Alpine stereos, no nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Rover', 'Range Rover HSE', 2002, 2004, 'BMWT', 'C-BMWT', 'Navigation 16:9; *2004 may need wire modification', '', 'Navigation 16:9' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Saab', '9-5', 2010, 2011, 'GM1S_', 'MCFGM1', '', 'MyLink 7-inch screen', 'MyLink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Saab', '9-4X', 2011, 2011, 'GM1S_', 'MCFGM1', '', 'MyLink 7-inch screen', 'MyLink 7-inch screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Saturn', 'Outlook', 2007, 2010, 'GM', 'GM08', 'not USB ready radio, must have SAT', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Saturn', 'Vue', 2008, 2010, 'GM', 'GM08', 'not USB ready radio, must have SAT', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'tC', 2005, 2010, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'xA', 2004, 2006, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'xB', 2004, 2007, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'xD', 2008, 2012, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'iQ', 2014, 2015, 'TOYHK_', 'TOY', '', 'LCD screen APP button', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'xD', 2014, 2014, 'TOYHK_', 'TOY', '', 'LCD screen APP button', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Scion', 'tC', 2014, 2016, 'TOYHK_', 'TOY', '', 'LCD screen APP button', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'SEAT', 'any model', 1998, 2010, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Skoda', '1 DIN radio', 1998, 2010, 'VAGS', 'VAGS', '2 inches in height', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Skoda', '2 DIN radio', 2003, 2010, 'VAGD', 'VAGD', '4 inches in height', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Forester', 2008, 2013, 'SUB08', 'SUB08', 'must have CHR/AUX/SAT button**', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Impreza', 2008, 2011, 'SUB08', 'SUB08', 'must have CHR/AUX/SAT button**', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Impreza WRX', 2012, 2014, 'SUB08', 'SUB08', 'must have CHR/AUX/SAT button**', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Legacy', 2002, 2006, 'SUB08', 'SUB08', 'must have CHR/AUX button, non-US models only*', '', 'non-US models' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Legacy', 2007, 2014, 'SUB08', 'SUB08', 'must have SAT button, not compatib. with PE669UI', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Liberty', 2003, 2009, 'SUB08', 'SUB08', 'must have CHR/AUX button, non-US models only*', '', 'non-US models' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Outback', 2004, 2006, 'SUB08', 'SUB08', 'must have CHR/AUX button, non-US models only*', '', 'non-US models' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Outback', 2007, 2009, 'SUB08', 'SUB08', 'must have CHR/AUX/SAT button**', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Subaru', 'Tribeca', 2006, 2009, 'SUB08', 'SUB08', 'must have CHR/AUX/SAT button**', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', '4 Runner', 1998, 2002, 'TOYO', 'TOY1', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', '4 Runner', 2003, 2009, 'TOYN', 'TOY', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', '4 Runner', 2010, 2012, 'TOYN_TOY6_', 'TOY', 'no DVD, no Nav', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', '4 Runner', 2013, 2013, 'TOY6_', 'MCFTOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', '4 Runner', 2014, 2019, 'TEN_', 'TOYN', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', '86', 2017, 2019, 'TEN_', 'TOYN', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Altezza', 1999, 2007, 'TOYO', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Altezza', 2008, 2009, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Avalon', 1998, 2004, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Avalon', 2005, 2010, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Avalon', 2011, 2012, 'TOYN_TOY6_', 'TOY', 'no Nav', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Avalon', 2013, 2014, 'TOYHK_', 'TOYHK', '', 'Navi with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Avalon', 2015, 2018, 'TEN_', 'TOYN', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 1998, 2001, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2002, 2006, 'LEX3L_TOYL_', 'LEX', 'Nav stereo, radio E7003', 'Nav stereo, radio E7003', 'Nav, Radio E7003' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2002, 2006, 'LEX3_TOYO_', 'TOYO', 'Nav stereo, radio 17001 17007', 'Nav stereo, radio 17001 17007', 'Nav, Radio 17001 17007' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2002, 2006, 'TOYO', 'LEX', 'no-Nav stereo', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2005, 2009, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2010, 2011, 'TOYN_TOY6_', 'TOY', 'No Nav', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2012, 2012, 'TOYN', 'TOY', 'No Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2012, 2012, 'TOYHK_', 'TOY', '', 'Navi with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry Hybrid', 2010, 2011, 'TOY6_', 'TOY', 'No Nav', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Camry', 2013, 2017, 'TEN_', 'TOYN', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Celica', 1998, 2002, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Celica', 2003, 2006, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Corolla', 1998, 2004, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Corolla', 2005, 2011, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Corolla', 2012, 2012, 'TOYN', 'TOY', 'No Nav', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Corolla', 2012, 2013, 'TOYHK_', 'TOY', '', 'NAV with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Corolla', 2014, 2019, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'FJ Cruiser', 2007, 2011, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'FJ Cruiser', 2012, 2012, 'TOYN', 'TOY', 'No Nav', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander', 2001, 2003, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander', 2004, 2010, 'TOYN', 'TOY', '', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander', 2004, 2007, 'LEX4_', 'TOY', '', 'Nav', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander', 2011, 2012, 'TOYN_TOY6_', 'TOY', 'no Nav', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander', 2013, 2013, 'TOY6_', 'TOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander', 2014, 2019, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander Hybrid', 2011, 2013, 'TOY6_', 'TOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Highlander Hybrid', 2014, 2019, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 1998, 2000, 'TOYO', 'TOY1', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2001, 2002, 'TOYO_LEX3_', 'TOY1', 'no DVD', 'Nav', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2003, 2003, 'TOYN_LEXGX_', 'TOY', '', 'Nav', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2004, 2007, 'TOYN_LEX4_', 'TOY', '', 'Nav', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2008, 2009, 'TOYN_LEX5_', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2010, 2012, 'TOYN_', 'TOY', 'no Nav', '', 'No Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2010, 2012, 'LEX6_', 'MCFLEX6', '', 'JBL 7in nav screen', 'Navi' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2013, 2018, 'LEX78T_', 'TOY', '', 'NAVI', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Land Cruiser', 2019, 2021, 'LEX9T_', 'TOY', '', 'NAVI', 'Nav' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Matrix', 2005, 2012, 'TOYN', 'TOY', ' for 2012 no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'MR2 Spyder', 1999, 2002, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'MR2 Spyder', 2003, 2007, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius', 2001, 2003, 'TOYO_LEX3_', 'TOY1', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius', 2004, 2005, 'TOYN_LEX4_', 'TOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius', 2006, 2009, 'TOYN_LEX5_', 'TOY', '', 'Navi', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius', 2010, 2011, 'TOYN', 'TOY', 'no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius Radio E7022', 2010, 2011, 'TOY6_', 'TOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius', 2012, 2014, 'TOYHK_', 'TOY', '', 'Navi with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius', 2015, 2018, 'TEN_', 'TOY', '', 'stereos with LCD screen, no Prius Prime', 'with LCD screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Prius Prime', 2015, 2018, '', 'TOY', '', 'Prius Prime not compatible', 'with LCD screen' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'RAV4', 1998, 2002, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'RAV4', 2003, 2012, 'TOYN', 'TOY', ' for 2012 no Nav, no Media button*', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'RAV4', 2013, 2013, 'TOYHK_', 'TOY', '', 'Navi with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'RAV4', 2014, 2018, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sequoia', 1998, 2002, 'TOYO', 'TOY1', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sequoia', 2003, 2009, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sequoia', 2010, 2012, 'TOYN', 'TOY', 'no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sequoia Radio E7026', 2010, 2012, 'TOY6_', 'TOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sequoia', 2014, 2017, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sienna', 1998, 2003, 'TOYO', 'TOY1', 'no DVD', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sienna', 2004, 2010, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sienna', 2011, 2012, 'TOYN', 'TOY', 'no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sienna Radio E7027', 2011, 2014, 'TOY6', 'TOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Sienna', 2014, 2017, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Solara', 1998, 2003, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Solara', 2004, 2012, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tacoma', 1998, 2004, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tacoma', 2005, 2012, 'TOYN', 'TOY', 'for 2012 no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tacoma', 2013, 2013, 'TOYHK_', 'TOY', '', 'Navi with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tacoma', 2014, 2019, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tundra', 1998, 2002, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tundra', 2003, 2009, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tundra', 2010, 2012, 'TOYN', 'TOY', 'no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tundra Radio E7026', 2010, 2013, 'TOY6', 'TOY', '', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Tundra', 2014, 2019, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Venza', 2008, 2008, 'TOYN', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Venza', 2009, 2012, 'TOYN_TOY6_', 'TOY', 'no Nav', 'JBL 7in nav screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Venza', 2013, 2015, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Vitz', 2001, 2005, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Vitz', 2006, 2012, 'TOYN', 'TOY', 'for 2012 no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Yaris', 1999, 2005, 'TOYO', 'TOY1', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Yaris', 2006, 2012, 'TOYN', 'TOY', 'for 2012 no Nav', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Yaris Verso', 2000, 2004, 'TOYO', 'TOY', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Yaris', 2015, 2017, 'TOYHK_', 'TOY', '', 'Navi with APP button, check stereo model', 'NAV with APP button' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Toyota', 'Yaris', 2018, 2018, 'TEN_', 'TOY', '', 'Stereo with LCD screen', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'all models', 1994, 2000, 'VOL94', 'VOL', 'SC-xxx radio, except S80', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'C30', 2006, 2013, 'VOLSO4', 'POF', 'Single CD', '', 'Single CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'C30', 2006, 2013, 'VOLS6O4', 'POF', '6-CD', '', '6-CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'C70', 2001, 2004, 'VOL94', 'VOL', 'SC-xxx radio', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'C70', 2006, 2012, 'VOLSO4', 'POF', 'Single CD', '', 'Single CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'C70', 2006, 2012, 'VOLS6O4', 'POF', '6-CD', '', '6-CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S40', 2001, 2003, 'VOL01', 'VOL8', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S40', 2004, 2004, 'VOL01', 'VOL8', 'no integrated climate/radio/phone controls', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S40', 2005, 2012, 'VOLSO4', 'POF', 'Single CD', '', 'Single CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S40', 2005, 2012, 'VOLS6O4', 'POF', '6-CD', '', '6-CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S60', 2000, 2009, 'VOL01', 'VOL8', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S60', 2015, 2018, 'VOLSC', 'VOLSC', '', 'Sensus Connect 7 inch and Internet/Globe button', 'with Sensus Connect' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S80', 2000, 2006, 'VOL01', 'VOL8', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'S80', 2015, 2018, 'VOLSC', 'VOLSC', '', 'Sensus Connect 7 inch and Internet/Globe button', 'with Sensus Connect' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'V40', 2001, 2003, 'VOL01', 'VOL8', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'V40', 2015, 2018, 'VOLSC', 'VOLSC', '', 'Sensus Connect 7 inch and Internet/Globe button', 'with Sensus Connect' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'V50', 2005, 2012, 'VOLSO4', 'POF', 'Single CD', '', 'Single CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'V50', 2005, 2012, 'VOLS6O4', 'POF', '6-CD', '', '6-CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'V70', 2001, 2007, 'VOL01', 'VOL8', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'V60', 2015, 2018, 'VOLSC', 'VOLSC', '', 'Sensus Connect 7 inch and Internet/Globe button', 'with Sensus Connect' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'XC60', 2015, 2018, 'VOLSC', 'VOLSC', '', 'Sensus Connect 7 inch and Internet/Globe button', 'with Sensus Connect' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'XC70', 2002, 2007, 'VOL01', 'VOL8', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'XC70', 2015, 2018, 'VOLSC', 'VOLSC', '', 'Sensus Connect 7 inch and Internet/Globe button', 'with Sensus Connect' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'XC90', 2002, 2006, 'VOLXCO4', 'POF', '6CD High Performance or Premium', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'XC90', 2007, 2013, 'VOLXCSO4', 'POF', 'Single CD', '', 'Single CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'Volvo', 'XC90', 2007, 2013, 'VOLXC6O4', 'POF', '6-CD', '', '6-CD' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Beetle', 1999, 2010, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Beetle Convertible', 1999, 2010, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Beetle', 2011, 2011, 'VAGD', 'VAGD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Beetle Convertible', 2011, 2011, 'VAGD', 'VAGD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Beetle', 2009, 2010, 'VAGT', 'VAG-T', '', '', 'armrest install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Beetle Convertible', 2009, 2010, 'VAGT', 'VAG-T', '', '', 'armrest install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Bettle', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Cabrio', 1998, 2001, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Cabrio', 1998, 2001, 'VAGT', 'VAG-T', '', '', 'armrest install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'CC', 2009, 2010, 'VAGD', 'VAGD', '', '', 'no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'CC', 2009, 2010, 'VAGT', 'VAG-T', '', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'CC', 2008, 2012, 'VAGR', 'VAGR', '', '', 'RCD510, RNS510, RCD310' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'CC', 2013, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'EOS', 2007, 2010, 'VAGD', 'VAGD', '', '', 'no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'EOS', 2007, 2010, 'VAGT', 'VAG-T', '', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'EOS', 2008, 2013, 'VAGR', 'VAGR', '', '', 'RCD510, RNS510, RCD310' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'EOS', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Fox', 2004, 2010, 'VAGD', 'VAGD', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Fox', 2004, 2010, 'VAGT', 'VAG-T', '', '', 'trunk install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Golf/Rabbit', 1998, 2002, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Golf/Rabbit', 1998, 2002, 'VAGT', 'VAG-T', '', '', 'trunk install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Golf/R32/GTI/Rabbit', 2003, 2010, 'VAGD', 'VAGD', 'except RCD510, RNS510, RCD310', '', 'no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Golf/R32/GTI/Rabbit', 2003, 2010, 'VAGT', 'VAG-T', 'except RCD510, RNS510, RCD310', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Golf/R32/GTI/Rabbit', 2009, 2013, 'VAGR', 'VAGR', '', '', 'RCD510, RNS510, RCD310' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Golf/R32/GTI/Rabbit', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Jetta', 1999, 2002, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Jetta', 1999, 2002, 'VAGT', 'VAG-T', '', '', 'trunk install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Jetta', 2003, 2010, 'VAGD', 'VAGD', 'except RCD510, RNS510, RCD310', '', 'no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Jetta', 2003, 2010, 'VAGT', 'VAG-T', 'except RCD510, RNS510, RCD310', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Jetta', 2008, 2013, 'VAGR', 'VAGR', '', '', 'RCD510, RNS510, RCD310' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Jetta', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Passat', 1999, 2001, 'VAGS', 'VAGS', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Passat', 1999, 2001, 'VAGT', 'VAG-T', '', '', 'trunk install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Passat', 2002, 2010, 'VAGD', 'VAGD', 'except RCD510, RNS510, RCD310', '', 'no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Passat', 1999, 2010, 'VAGT', 'VAG-T', 'except RCD510, RNS510, RCD310', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Passat', 2006, 2013, 'VAGR', 'VAGR', '', '', 'RCD510, RNS510, RCD310' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Passat', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Phaeton', 2002, 2006, 'VAGT', 'VAG-T', 'except RCD510, RNS510, RCD310', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Polo V', 2009, 2013, 'VAGR', 'VAGR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Polo V', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Scirocco', 2008, 2013, 'VAGR', 'VAGR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Scirocco', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Sharan', 2010, 2013, 'VAGR', 'VAGR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Sharan', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Tiguan', 2004, 2010, 'VAGD', 'VAGD', 'no RNS', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Tiguan', 2004, 2010, 'VAGT', 'VAG-T', '', '', 'trunk install, no RNS' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Tiguan', 2008, 2013, 'VAGR', 'VAGR', '', '', 'RCD510, RNS510, RCD310' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Tiguan', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Touareg', 2002, 2010, 'VAGD', 'VAGD', 'except RCD510, RNS510, RCD310', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Touareg', 2002, 2010, 'VAGT', 'VAG-T', 'except RCD510, RNS510, RCD310', '', 'trunk install' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Touareg', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Touran', 2009, 2013, 'VAGR', 'VAGR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Touran', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Transporter', 2010, 2013, 'VAGR', 'VAGR', '', '', '' ); INSERT IGNORE INTO compatibility(make_cd, model_cd, year_from_nbr, year_to_nbr, sku_cd, cable_sku_cd, cmnt_txt, vline_cmnt_txt, optn_txt ) VALUES ( 'VW', 'Transporter', 2014, 2016, 'WLQ1MU_WLQ1TC_', 'TOY', 'USB IPOD ready stereo', '', '' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'AUD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'BMWS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'BMWT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'CHR02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'BPT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'HON1' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'MBUS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'MBUSD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'MAZ' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'MB' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'MITS02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'MITS08' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'NIS02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'NISCDC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'RVR' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'SUB08' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'TOYN' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'TOYO' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'TOYF' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'TOYL' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'VOL01' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'VOL94' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'VAGS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'VAGD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 6, 'VAGT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'AUD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'BMWS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'BMWT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'CHR02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'BPT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'HON1' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'MBUS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'MBUSD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'MAZ' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'MB' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'MITS02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'MITS08' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'NIS02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'NISCDC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'RVR' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'SUB08' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'TOYN' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'TOYO' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'TOYF' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'TOYL' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'VOL01' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'VOL94' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'VAGS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'VAGD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 8, 'VAGT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'AUD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'BMWS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'BMWT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'CHR02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'BPT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'FRD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'FRDEU' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'GM' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'HON1' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MBUS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MBUSD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'HYU' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MAZ8' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MAZ' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MB' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MITS02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'MITS08' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'NIS02' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'NISCDC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'SUB08' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'RVR' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'TOYN' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'TOYO' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'TOYF' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'TOYL' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'VOL01' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'VOL94' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'VAGS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'VAGD' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'VAGT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 1, 'VAGR' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'AUDO4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'BMWO4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'MBO4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'VOLS6O4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'VOLSO4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'VOLXCO4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'VOLXC6O4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 4, 'VOLXCSO4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'HON3' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'HON2' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'HON2M' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'HON2V' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'AUDC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'GM1' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'GM1C' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'GM1S' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'CHRU' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX9' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX9L' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX9T' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX78T' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX78' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEXK' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEXKL' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX6RT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX6' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX5' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX5LS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEXGX' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEXGS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEXSC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX3' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'LEX3L' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'MB45' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'NIS9' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'NIS8' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'NISK' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'NISKI' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'TEN' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'TOYHK' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'TOY6' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 13, 'VOLSC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'HON3' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'HON2' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'HON2M' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'HON2V' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'AUDC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'GM1' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'GM1C' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'CHRU' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX9' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX9L' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX9T' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX78T' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX78' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEXK' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEXKL' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX6RT' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX6' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX5' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX5LS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX4' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEXGX' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEXGS' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEXSC' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX3' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'LEX3L' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'NIS9' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'NIS8' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'NISK' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'TEN' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'TOYHK' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'TOY6' ); INSERT IGNORE INTO category_sku(cat_id, sku_cd ) VALUES ( 14, 'VOLSC' );