SELECT `_id`,`ShiftDate` 'Date', `StartVoucherNo` 'From' , `StopVoucherNo` 'To',`SalesValue` Sales,  `CashSales` 'Cash Sales', `CardSales` 'Card', `CreditSales` 'Credit',`PaymentCash`'Payment Cash', (SELECT name from  Employee_Details  where _id = shift.cashierID) as Cashier,`paxCount` PAX , `ShiftStart_DateTime` 'Start' , `ShiftEnd_DateTime` 'END',`TotalCash`'Total Cash' , `CasinCounter` 'Cash In Counter' , `TillDifference` 'Till Difference' , `Narration`,CashWithDrawn 'Cash WithDrawn'   FROM $trans_db.`shifttable` shift  where  ( `ShiftDate`>=str_to_date('$fromDateTime','%Y-%m-%d %H:%i:%s') and `ShiftDate`<= str_to_date('$toDateTime','%Y-%m-%d %H:%i:%s'))