SELECT maintbl.*, DATE_FORMAT(maintbl.licenseDate, '%m/%d/%Y') AS date2, DATE_FORMAT(maintbl.lastMBCaction, '%m/%d/%Y') AS date3,  DATE_FORMAT(maintbl.recordAddedOn, '%m/%d/%Y') AS date4,  DATE_FORMAT(maintbl.recordModifiedOn, '%m/%d/%Y') AS date5, gendertbl.drgender, regiontbl.region, boardtbl.board FROM maintbl INNER JOIN gendertbl ON maintbl.genderID = gendertbl.genderID INNER JOIN regiontbl ON maintbl.regionID = regiontbl.regionID INNER JOIN boardtbl ON boardtbl.boardID = maintbl.boardID WHERE mainID = ? AND DisplayOnPage = 0<BR><BR>