failure on:
SELECT LEDGER_NUM, LEDGER_PAGE_NUM, PATRON_NUM, DATE_FORMAT(DATE_JOINED,'%W, %M %D,%Y') AS DATE_JOINED,CONCAT('View Page') AS LINK,CONCAT_WS(' ',PAT_PREFIX.TITLE_TEXT, FIRST_NAME, MIDDLE_NAME, LAST_NAME, PAT_SUFFIX.TITLE_TEXT) AS PAT_NAME,CONCAT_WS(', ',LAST_NAME,FIRST_NAME) AS ALPHA_NAME,NICKNAME,RESIDENCE,(IF(GUARANTOR_FIRST IS NOT NULL,CONCAT_WS(' ',G_PREFIX.TITLE_TEXT, GUARANTOR_FIRST, GUARANTOR_MIDDLE, GUARANTOR_LAST, G_SUFFIX.TITLE_TEXT),GUARANTOR_FULL_NAME)) AS GUAR_NAME,GUARANTOR_RESIDENCE,G_REL.RELATIONSHIP_NAME AS GUAR_RELATIONSHIP,PATRON_BBR.ADDITIONAL_INFO as BBR_INFO,CONCAT_WS(' ',MCD_PREFIX.TITLE_TEXT, MCD_FIRST_NAME, MCD_MIDDLE_NAME, MCD_LAST_NAME, MCD_SUFFIX.TITLE_TEXT) AS MCD_NAME,MCD_ADDRESS,MCD_OCCUPATION,MCD_YEAR.MCD_YEAR_VALUE AS MCD_YEAR,PATRON_MCD.MCD_ADDITIONAL_INFO AS MCD_INFO,IF(CENSUS_FIRST_NAME IS NOT NULL, CONCAT_WS(' ',CENSUS_PRE.TITLE_TEXT, CENSUS_FIRST_NAME, CENSUS_MIDDLE_NAME, CENSUS_LAST_NAME, CENSUS_SUF.TITLE_TEXT),CENSUS_FULL_NAME) AS CENSUS_NAME,RACE_NAME, GENDER,BIRTH_YEAR,PAT_BIRTH.BIRTHPLACE_NAME AS PATRON_BIRTHPLACE,F_BIRTH.BIRTHPLACE_NAME AS FATHER_BIRTHPLACE,M_BIRTH.BIRTHPLACE_NAME AS MOTHER_BIRTHPLACE,YEARS_MARRIED,MARITAL_STATUS,RESIDENTIAL_STATUS_NAME AS RESIDENTIAL_STATUS,NUM_BOARDERS,NUM_SERVANTS,YEAR_OF_IMMIGRATION,NATURALIZATION_STATUS,PROFESSION_TITLE AS OCCUPATION,CENSUS_OCCUPATION_NOTE,OCCUPATION_CLASSIFICATION.OCCUPATION_GROUP, OCCUPATION_CLASSIFICATION.OCCUPATION_RANK, CENSUS_ADDITIONAL_INFO AS CENSUS_INFO FROM PATRON_BBR LEFT JOIN PATRON_MCD USING(PATRON_MCD_ID) LEFT JOIN PATRON_CENSUS USING (PATRON_CENSUS_ID) LEFT JOIN NAME_TITLE AS PAT_PREFIX ON NAME_PREFIX_ID=PAT_PREFIX.NAME_TITLE_ID LEFT JOIN NAME_TITLE AS PAT_SUFFIX ON NAME_SUFFIX_ID=PAT_SUFFIX.NAME_TITLE_ID LEFT JOIN NAME_TITLE AS G_PREFIX ON GUARANTOR_PREFIX_ID=G_PREFIX.NAME_TITLE_ID LEFT JOIN NAME_TITLE AS G_SUFFIX ON GUARANTOR_SUFFIX_ID=G_SUFFIX.NAME_TITLE_ID LEFT JOIN RELATIONSHIP AS G_REL ON GUARANTOR_RELATIONSHIP_ID=RELATIONSHIP_ID LEFT JOIN NAME_TITLE AS MCD_PREFIX ON MCD_NAME_PREFIX_ID=MCD_PREFIX.NAME_TITLE_ID LEFT JOIN NAME_TITLE AS MCD_SUFFIX ON MCD_NAME_SUFFIX_ID=MCD_SUFFIX.NAME_TITLE_ID LEFT JOIN MCD_YEAR USING(MCD_YEAR_ID) LEFT JOIN NAME_TITLE AS CENSUS_PRE ON CENSUS_NAME_PREFIX_ID=CENSUS_PRE.NAME_TITLE_ID LEFT JOIN NAME_TITLE AS CENSUS_SUF ON CENSUS_NAME_SUFFIX_ID=CENSUS_SUF.NAME_TITLE_ID LEFT JOIN RACE USING(RACE_ID) LEFT JOIN BIRTHPLACE AS PAT_BIRTH USING(BIRTHPLACE_ID) LEFT JOIN BIRTHPLACE AS F_BIRTH ON FATHER_BIRTHPLACE_ID=F_BIRTH.BIRTHPLACE_ID LEFT JOIN BIRTHPLACE AS M_BIRTH ON MOTHER_BIRTHPLACE_ID=M_BIRTH.BIRTHPLACE_ID LEFT JOIN RESIDENTIAL_STATUS USING (RESIDENTIAL_STATUS_ID) LEFT JOIN PROFESSION ON CENSUS_OCCUPATION_ID=PROFESSION_ID LEFT JOIN OCCUPATION_CLASSIFICATION USING(OCCUPATION_CLASSIFICATION_ID) WHERE PATRON_BBR_ID=3641