SELECT SQL_CALC_FOUND_ROWS tblinvtype.typeId, tblinvtype.typeName, markers.description, markers.image, markers.lat, markers.lng, markers.tel, markers.email FROM tblbranch LEFT OUTER JOIN tblinvtype ON tblbranch.foreignKey = tblinvtype.typeId LEFT OUTER JOIN markers ON tblinvtype.typeId = markers.`type` WHERE markers.city = 'LeMars' LIMIT 1<BR><BR>