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 Cast(t_attribute.Classifier as INT) FROM t_attribute WHERE t_attribute.Classifier <> '0' AND t_attribute.Classifier <> '')
AND t_object.Object_ID NOT IN 	(SELECT Cast(t_operation.Classifier as INT) FROM t_operation WHERE t_operation.Classifier <> '0' AND t_operation.Classifier <> '')
AND t_object.Object_ID NOT IN 	(SELECT Cast(t_operationparams.Classifier as INT) 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 Cast(t_operation.Behaviour as nvarchar(max)) FROM t_operation WHERE Cast(t_operation.Behaviour as nvarchar(max)) <> '')
AND t_object.Object_ID NOT IN 	(SELECT Cast(t_connector.PDATA1 as INT) FROM t_connector WHERE t_connector.Connector_Type = 'Association' AND t_connector.SubType = 'Class')