SELECT
*,'XXXXXXXX' as 'trainNo'
FROM
percartinfo
WHERE
dateAndTime LIKE CONCAT(
"%",(
SELECT
SUBSTRING(( SELECT dateAndTime FROM perTrainInfo WHERE trainNo = "CXXXXXXXX" ORDER BY dateAndTime DESC LIMIT 1 ), 7, 1 )),
"/%",(SELECT SUBSTRING((SELECT dateAndTime FROM perTrainInfo WHERE trainNo="CXXXXXXXX" ORDER BY dateAndTime DESC LIMIT 1),10,1)),
"%/",(SELECT left((SELECT dateAndTime FROM perTrainInfo WHERE trainNo="CXXXXXXXX" ORDER BY dateAndTime DESC LIMIT 1),4)),"%")
