Post Vars:
Table 'docline.PUBLIC_STATE_ETC_CODES' doesn't exist,
Query String: /* Query defined in members.init.php. Base public query. */ SELECT DISTINCT pld.LIBID, pld.INST_INST as INST, pld.DEPT_INST as DEPT, IF(pld.STREET2_INST IS NOT NULL, CONCAT(pld.STREET_INST, ', ', pld.STREET2_INST), pld.STREET_INST) AS STREET, pld.CITY_INST as CITY, pld.STATE_ETC_CODE_INST as STATE, pld.ZIP_MAIL_CODE_INST as ZIP, sec.NAME AS STATE_NAME, pld.LIB_TYPE_CODE, pld.LIB_CLOSED_YN, pld.NNLM_MEMBERSHIP, pld.LIB_LEVEL_CODE, pld.MEDLINEPLUS_YN FROM docline.PUBLIC_LIBRARY_DOCUSERS pld LEFT JOIN docline.PUBLIC_LIBRARY_CONTACTS plc ON (plc.LIBID = pld.LIBID) LEFT JOIN docline.PUBLIC_STATE_ETC_CODES sec ON(pld.STATE_ETC_CODE = sec.STATE_ETC_CODE) WHERE (pld.LIB_CLOSED_YN != 'Y') AND (pld.NNLM_MEMBERSHIP != 'N') AND ( pld.NNLM_MEMBERSHIP = 'A' OR pld.NNLM_MEMBERSHIP = 'F') AND pld.LIB_CLOSED_YN != 'Y' AND pld.DEMO_LIB_YN = 'N' ORDER BY pld.STATE_ETC_CODE, pld.CITY, pld.INST