 		cataloged_item related_cat_item,
 		collection related_coll,
 		specimen_part,
-		coll_object part_object,
-		coll_object_remark parts_coll_object_remark,
-	 	coll_object parts_coll_object,
-		specimen_part s_part
+		coll_object part_object
 	WHERE 
 		cataloged_item.collection_id = collection.collection_id AND
 		cataloged_item.collection_object_id = identification.collection_object_id AND

		is_tissue,
		part_disposition,
		part_condition,
		lot_count,
		parts_coll_object_remark.coll_object_remarks
	order by
		part_name
</cfquery>

									<td>#part_condition#</td>
									<td>#part_disposition#</td>
									<td>#lot_count#</td>
									<td><cfif #is_tissue# is 1>yes<cfelse>no</cfif></td>
								</tr>
							</cfloop>
						</table>
