SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, t_object.*
FROM t_object
WHERE t_object.Object_Type <> 'Package' 
AND t_object.Object_ID NOT IN 	(SELECT t_diagramobjects.Object_ID FROM t_diagramobjects) 	
AND t_object.Object_ID NOT IN 		(SELECT t_object.Classifier as Object_ID FROM t_object WHERE t_object.Classifier <> 0)
AND t_object.Object_ID NOT IN 		(SELECT a.Object_ID FROM t_object as a,  t_object as b WHERE b.PDATA1 = a.ea_guid)
AND t_object.Object_ID NOT IN 		(SELECT cLng('0' & t_attribute.Classifier) FROM t_attribute WHERE t_attribute.Classifier <> '0' AND t_attribute.Classifier <> '')
AND t_object.Object_ID NOT IN 		(SELECT cLNG('0' & t_operation.Classifier) FROM t_operation WHERE t_operation.Classifier <> '0' AND t_operation.Classifier <> '')
AND t_object.Object_ID NOT IN 		(SELECT cLNG('0' & t_operationparams.Classifier) FROM t_operationparams WHERE t_operationparams.Classifier <> '0' AND t_operationparams.Classifier <> '')
AND t_object.Object_ID NOT IN 		(SELECT t_connector.Start_Object_ID FROM t_connector)
AND t_object.Object_ID NOT IN 		(SELECT t_connector.End_Object_ID FROM t_connector)
AND t_object.Object_ID NOT IN 		(SELECT t_object.ParentID FROM t_object)
AND t_object.Object_ID  NOT IN 	(SELECT t_object.Object_ID  FROM t_xref, t_object WHERE t_xref.Name = 'MOFProps' AND  t_xref.Description LIKE '*'&t_object.ea_guid&'*' )
AND t_object.ea_guid NOT IN 		(SELECT CStr( "" & t_operation.Behaviour) FROM t_operation WHERE t_operation.Behaviour <> '')
AND t_object.Object_ID NOT IN 		(SELECT cLNG( "0" &t_connector.PDATA1) FROM t_connector WHERE t_connector.Connector_Type = "Association" AND t_connector.SubType = "Class")