query
RESULTSET	query   CAMPUS_HOUSING CAMPUS_SETTING CHO_ADDRESS CHO_ADDRESS2 CHO_ANNUALSALES CHO_CAPACITY CHO_CITY CHO_COMMENTS CHO_COORDINATES CHO_COUNTRYID CHO_COUNTYNAME CHO_CRMACTIVE CHO_CUISINEID CHO_DBANAME CHO_DISTRIBMETHOD CHO_EXCHSYMBOL CHO_FAX CHO_FAXAC CHO_IMAGEID CHO_KEYWORDS CHO_LASTUPDATEDBY CHO_LASTUPDATENOTES CHO_LOCALECODE CHO_LOGOID CHO_MENUCYCLE CHO_MENULINK CHO_MENUPLANDEADLINE CHO_MGMTTYPE CHO_NAME CHO_PARENTCO CHO_PHONE CHO_PHONEAC CHO_PROFILE CHO_PROFILEREADY CHO_PUBTRADE CHO_RECORDSOURCE CHO_SEGMENTID CHO_STATE CHO_TYPE CHO_UNITSLASTYEAR CHO_UNITSNEXTYEAR CHO_UNITSTHISYEAR CHO_URL CHO_ZIPCODE COMPAREDIFF COMPAREID COMPARESTATUS CONFIRMEDYN DUNSID EAI_BATCHID EAI_IMPORTID EAI_LINENUMBER EMAILDOMAIN ENRL_FULL ENRL_PART ENRL_TOTAL FAC_FULL FAC_PART FAC_TOTAL FSL_CHOID GS1_GLN HOTELYN IPEDS_ID LASTUPDATE LEVEL MEAL_PLAN_PROVIDED NCES_DISTRICTID NCES_SCHOOLID NUMBEDS NUMRESIDENTS NUMSCHOOLS NUMSTUDENTS NUMTEACHERS NUM_OF_MEALS_WEEKLY OPERATORID OWNERID OWNERSHIP OWNERTYPE PRINCIPALOPERATORID PROVIDERID RESTAURANTS STATE_DISTRICTID STATUS TYPE
CACHED	false
EXECUTIONTIME	427
SQL	SELECT * FROM tbl_IMPORT_1FSOperators imp WHERE eai_batchId = 2993045 and not exists ( select * from tbl_1FS_MappingQueue mq where mq.operatorOwnerId = imp.ownerId and mq.operatorOwnerType = imp.ownerType and mq.operatorId = imp.operatorId )