SELECT `eu_cinfo` . `catalog`, `eu_cinfo` . `date1`, `eu_cinfo` . `date2`, `eu_descript`.`descript`
FROM `eu_cinfo` , `eu_descript`
WHERE `eu_descript`.`num` = `eu_cinfo`.`name` AND `eu_descript`.`descript` LIKE ?
ORDER BY `date1`
HERE.
B6060408A - 1984011 - 1989023 - COLT/LANCER(EUR)
B6067404A - 1988041 - 1995073 - COLT/LANCER(EUR)
B6068005A - 1991121 - 1996123 - COLT/LANCER(EUR)
B606F003A - 1995111 - 2003063 - COLT/LANCER(EUR)
C601H401D - 2004041 - 2012123 - COLT<5DOOR>(EUR/NEDCAR)
C601H201D - 2005011 - 2012123 - COLT<3DOOR>(EUR/NEDCAR)
C601H608D - 2006031 - 2008073 - COLT(EUR/PF)
C60CU404D - 2023091 - 2024121 - COLT(EUR)
C60CV404D - 2023091 - 2024121 - COLT HYBRID(EUR)