SELECT SQL_CALC_FOUND_ROWS NJdirectory.NJdirectoryID, NJdirectory.NJdirTITLE, NJdirectory.NJdirADDRESS1, NJdirectory.NJdirADDRESS2, NJdirectory.NJdirTOWNID, NJdirectory.NJdirPOSTCODE, NJdirectory.NJdirPHONE1, NJdirectory.NJdirPHONE2, NJdirectory.NJdirEMAIL1, NJdirectory.NJdirEMAIL2, NJdirectory.NJdirWEBSITE, NJdirectory.NJdirFACEBOOK, NJdirectory.NJdirTWITTER, NJdirectory.NJdirINSTAGRAM, NJdirectory.NJdirPINTEREST, NJdirectory.NJdirFLICKR, NJdirectory.NJdirYOUTUBE, NJdirectory.NJdirSUMMARY, NJdirectory.NJdirCHARITYNO, NJdirectory.NJdirCOMPANYNO, NJdirectory.NJdirIMGLOGO, NJtown.NJtownNAME, NJtown.NJregionID, NJregion.NJregionNAME, NJregion.countryID, NJcountries.countryNAME FROM NJdirectory INNER JOIN NJtown ON NJdirectory.NJdirTOWNID = NJtown.NJtownID INNER JOIN NJregion ON NJtown.NJregionID = NJregion.NJregionID INNER JOIN NJcountries ON NJregion.countryID = NJcountries.countryID WHERE NJdirectory.NJdirectoryID = 227 LIMIT 1<BR><BR>