SELECT n.`id`, u.`Username`, ue.`Username` As EditordUsername, DATE_FORMAT(DATE(PostedOn),'%d/%m/%Y') AS `Date`, DATE_FORMAT(TIME(PostedOn),'%r') AS `Time`, DATE_FORMAT(DATE(UpdatedDate),'%d/%m/%Y') AS `UDate`, DATE_FORMAT(TIME(UpdatedDate),'%r') AS `UTime`, n.`Header`, n.`Article`, n.`Updated` FROM news n LEFT JOIN userdetails u ON n.`UserID` = u.`UserID` LEFT JOIN userdetails ue ON n.`UpdateUserID` = u.`UserID` WHERE n.Visiable = 1 Order BY n.`PostedOn` DESC