Stuff
public text v1 · immutable 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