SELECT `comp_financial_year`.*, concat(period, " [", date_format(startDate, "%d-%m-%Y"), " - ", date_format(endDate, "%d-%m-%Y"), "]") as financialPeriod, concat(period, " [ As at ", date_format(endDate, "%d-%m-%Y"), "]") as financialPeriodAsat
FROM (`comp_financial_year`)
WHERE `companyID` =  '3'
AND `financialYear` =  '2015'
ORDER BY `financialYear`, `period`