Review Profile Changes
Unknown column 'Bellamya_chinensis' in 'where clause':
SELECT C.CHANGE_ID, C.FISH_ID, C.MEMBER_ID, C.FIELD_NAME, C.APPROVED_FLAG, C.LOG_TYPE_IND, P.SCI_NAME, P.MARINE_FLAG, P.CATEGORY_ID, U.USER_NAME FROM FISHPROFILE_CHANGELOG C INNER JOIN FISHPROFILE P ON C.FISH_ID=P.FISH_ID LEFT OUTER JOIN MEMBER U ON C.MEMBER_ID=U.USER_ID WHERE C.FISH_ID=Bellamya_chinensis UNION SELECT C.CHANGE_ID, C.FISH_ID, C.MEMBER_ID, C.FIELD_NAME, C.APPROVED_FLAG, C.LOG_TYPE_IND, P.COMMON_NAME, "1", "corals", U.USER_NAME FROM FISHPROFILE_CHANGELOG C INNER JOIN CORALPROFILE P ON P.CORAL_ID=C.FISH_ID LEFT OUTER JOIN MEMBER U ON C.MEMBER_ID=U.USER_ID WHERE C.FISH_ID=Bellamya_chinensis UNION SELECT C.CHANGE_ID, C.FISH_ID, C.MEMBER_ID, C.FIELD_NAME, C.APPROVED_FLAG, C.LOG_TYPE_IND, P.SCI_NAME, "0", "crustaceans", U.USER_NAME FROM FISHPROFILE_CHANGELOG C INNER JOIN CRUSTACEANPROFILE P ON P.CRUST_ID=C.FISH_ID LEFT OUTER JOIN MEMBER U ON C.MEMBER_ID=U.USER_ID WHERE C.FISH_ID=Bellamya_chinensis UNION SELECT C.CHANGE_ID, C.FISH_ID, C.MEMBER_ID, C.FIELD_NAME, C.APPROVED_FLAG, C.LOG_TYPE_IND, P.COMMON_NAME, "0", "diseases", U.USER_NAME FROM FISHPROFILE_CHANGELOG C INNER JOIN DISEASEPROFILE P ON P.DISEASE_ID=C.FISH_ID LEFT OUTER JOIN MEMBER U ON C.MEMBER_ID=U.USER_ID WHERE C.FISH_ID=Bellamya_chinensis UNION SELECT C.CHANGE_ID, C.FISH_ID, C.MEMBER_ID, C.FIELD_NAME, C.APPROVED_FLAG, C.LOG_TYPE_IND, P.COMMON_NAME, "0", "plants", U.USER_NAME FROM FISHPROFILE_CHANGELOG C INNER JOIN PLANTPROFILE P ON P.PLANT_ID=C.FISH_ID LEFT OUTER JOIN MEMBER U ON C.MEMBER_ID=U.USER_ID WHERE C.FISH_ID=Bellamya_chinensis ORDER BY CHANGE_ID DESC
|
| No changes have been made to this profile. |