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
Location Details Age Range Last Updated Contact