public static function getChats($message_hash, $data) { if ($data == '') { Conversation::updateConversation($message_hash); } $result = DB::Select("SELECT target_user_id as recipient_id,source_user_id as sender_id,(SELECT CONCAT(firstname,' ', lastname) \n FROM accounts_dbx WHERE account_id = mradi_messages.source_user_id) AS sender,CONCAT(firstname,' ', lastname) as recipient,\n `time_sent`,`mradi_messages`.`message`,(case when time_read is not null then 1 else 0 end)as time_read FROM `mradi_messages` \n LEFT JOIN `accounts_dbx` ON `accounts_dbx`.`account_id` = `mradi_messages`.`target_user_id`\n WHERE message_hash = ? AND `mradi_messages`.`status` IN (0,1) order by time_sent asc", array($message_hash)); return $result; }