SELECT l.iId as id, l.sLocation as location, l.sDetails as details, DATE_FORMAT(l.dEditedOn, '%b %e, %Y') as updated, l.bDisplayNumber, l.sAgeRange, u.sPhone
FROM tListing as l, tUsers as u
WHERE l.bArchived = 0 AND l.iProvider = u.iId
ORDER BY l.dEditedOn DESC
