SELECT this_.ID_ORDERS as ID1_17_6_, this_.Timestamp as Timestamp17_6_, this_.MARKETGATEWAY_ORDER_ID as MARKETGA3_17_6_, this_.BROKER_ID as BROKER4_17_6_, this_.INSTRUMENT_ID as INSTRUMENT5_17_6_, this_.INSTRUCTION_ID as INSTRUCT6_17_6_, this_.SIDE as SIDE17_6_, this_.PRICE as PRICE17_6_, this_.QUANTITY as QUANTITY17_6_, this_.CASH_QUANTITY as CASH10_17_6_, this_.VISIBLE_QUANTITY as VISIBLE11_17_6_, this_.TIME_IN_FORCE as TIME12_17_6_, this_.ORDER_TYPE as ORDER13_17_6_, this_.ORDER_DATE as ORDER14_17_6_, this_.EXPIRY_DATE as EXPIRY15_17_6_, this_.MARKETGATEWAY_ROUTING_METHOD as MARKETG16_17_6_, this_.EXCHANGE_FIRM as EXCHANGE17_17_6_, this_.EXCHANGE_USER as EXCHANGE18_17_6_, this_.EXECUTING_TRADER_ID as EXECUTING19_17_6_, this_.EXECUTING_FIRM_ID as EXECUTING20_17_6_, this_.HANDLING_INSTRUCTIONS as HANDLING21_17_6_, this_.ORDER_HANDLING as ORDER22_17_6_, this_.CL_ORDER_ID as CL23_17_6_, this_.ORIG_CL_ORDER_ID as ORIG24_17_6_, this_.HOUSE as HOUSE17_6_, this_.MINIMUM_QUANTITY as MINIMUM26_17_6_, this_.CLIENT_REFERENCE as CLIENT27_17_6_, this_.ORDER_REFERENCE as ORDER28_17_6_, this_.IS_HIDDEN as IS29_17_6_, this_.ORDER_CAPACITY as ORDER30_17_6_, this_.PEG_DIFFERENCE as PEG31_17_6_, this_.EXECUTION_INSTRUCTIONS as EXECUTION32_17_6_, this_.CLEARING_FIRM as CLEARING33_17_6_, this_.CLEARING_ACCOUNT as CLEARING34_17_6_, this_.EXEC_BROKER as EXEC35_17_6_, this_.ORDER_RESTRICTIONS as ORDER36_17_6_, this_.REFERENCE_LAST_PRICE as REFERENCE37_17_6_, this_.REFERENCE_BEST_BID as REFERENCE38_17_6_, this_.REFERENCE_BEST_OFFER as REFERENCE39_17_6_, this_.ORDER_STATUS as ORDER40_17_6_, this_.AVERAGE_PRICE as AVERAGE41_17_6_, this_.QUANTITY_EXECUTED as QUANTITY42_17_6_, this_.QUANTITY_REMAINING as QUANTITY43_17_6_, this_.LAST_ACTION_REJECTED as LAST44_17_6_, this_.LAST_ACTION_REJECTED_REASON as LAST45_17_6_, this_.COMPLETE as COMPLETE17_6_, this_.TEXT as TEXT17_6_, this_.CLIENT_ID as CLIENT48_17_6_, this_.LAST_TRANSACTION_TIME as LAST49_17_6_, this_.MARKETGATEWAY_ID as MARKETG50_17_6_, this_.SECONDARY_ORDER_ID as SECONDARY51_17_6_, this_.IS_TRADE_REPORT as IS52_17_6_, this_.DISPLAY_RANGE as DISPLAY53_17_6_, this_.STP_ACTION as STP54_17_6_, this_.STP_LEVEL as STP55_17_6_, this_.STP_TRADER_GROUP as STP56_17_6_, this_.DISPLAY_INSTRUCTIONS as DISPLAY57_17_6_, this_.NORDIC_AT_MID as NORDIC58_17_6_, this_.ORDER_CLASS as ORDER59_17_6_, this_.MIFID_CLIENT_ID as MIFID60_17_6_, this_.MIFID_CLIENT_SHORT_CODE as MIFID61_17_6_, this_.MIFID_CLIENT_QUALIFIER as MIFID62_17_6_, this_.MIFID_EXEC_DEC_ID as MIFID63_17_6_, this_.MIFID_EXEC_DEC_SHORT_CODE as MIFID64_17_6_, this_.MIFID_EXEC_DEC_QUALIFIER as MIFID65_17_6_, this_.MIFID_INVEST_DEC_ID as MIFID66_17_6_, this_.MIFID_INVEST_DEC_SHORT_CODE as MIFID67_17_6_, this_.MIFID_INVEST_DEC_QUALIFIER as MIFID68_17_6_, broker4_.ID_BROKERS as ID1_5_0_, broker4_.NAME as NAME5_0_, broker4_.EXT_REF_ID as EXT3_5_0_, broker4_.DESCRIPTION as DESCRIPT4_5_0_, broker4_.ENABLED as ENABLED5_0_, broker4_.DMA_HANDLING as DMA6_5_0_, broker4_.CARE_HANDLING as CARE7_5_0_, broker4_.PHONE_HANDLING as PHONE8_5_0_, broker4_.ALGO_HANDLING as ALGO9_5_0_, broker4_.SUPPORTS_TRADE_REPORTS as SUPPORTS10_5_0_, broker4_.DEFAULT_BROKER as DEFAULT11_5_0_, broker4_.GATEWAY_ID as GATEWAY12_5_0_, instrument5_.ID_INSTRUMENTS as ID1_13_1_, instrument5_.SYMBOL as SYMBOL13_1_, instrument5_.MARKET_SYMBOL as MARKET3_13_1_, instrument5_.MARKET_INSTRUMENT_ID as MARKET4_13_1_, instrument5_.SUBMARKET_NAME as SUBMARKET5_13_1_, instrument5_.ORDERBOOK_ID as ORDERBOOK6_13_1_, instrument5_.LIST_NAME as LIST7_13_1_, instrument5_.SOURCE as SOURCE13_1_, instrument5_.ISIN as ISIN13_1_, instrument5_.CUSIP as CUSIP13_1_, instrument5_.SEDOL as SEDOL13_1_, instrument5_.BLOOMBERG_CODE as BLOOMBERG12_13_1_, instrument5_.REUTERS_CODE as REUTERS13_13_1_, instrument5_.CUSTOM_CODE as CUSTOM14_13_1_, instrument5_.EXTERNAL_SYSTEM_ID as EXTERNAL15_13_1_, instrument5_.LONG_NAME as LONG16_13_1_, instrument5_.COUNTRY as COUNTRY13_1_, instrument5_.CURRENCY as CURRENCY13_1_, instrument5_.ISSUER as ISSUER13_1_, instrument5_.ISSUE_DATE as ISSUE20_13_1_, instrument5_.ASSET_CLASS as ASSET21_13_1_, instrument5_.SUB_TYPE as SUB22_13_1_, instrument5_.LISTED as LISTED13_1_, instrument5_.TRADING_LOT as TRADING24_13_1_, instrument5_.EXTERNAL_ID as EXTERNAL25_13_1_, instrument5_.CLEARING_SYSTEM as CLEARING26_13_1_, instrument5_.LIQUIDITY_GROUP_CODE as LIQUIDITY27_13_1_, instrument5_.NUMBER_OF_SETTLEMENT_DAYS as NUMBER28_13_1_, instrument5_.ROUND_LOT_SIZE as ROUND29_13_1_, instrument5_.BLOCK_LOT_SIZE as BLOCK30_13_1_, instrument5_.TRADE_FROM as TRADE31_13_1_, instrument5_.TRADE_THROUGH as TRADE32_13_1_, instrument5_.VALID_FROM as VALID33_13_1_, instrument5_.VALID_THROUGH as VALID34_13_1_, instrument5_.VOL_MIN_ACCEPTORDER as VOL35_13_1_, instrument5_.VOL_MIN_TRADE as VOL36_13_1_, instrument5_.VALID as VALID13_1_, instrument5_.LAST_UPDATED as LAST38_13_1_, instrument5_.EXCHANGE_ID as EXCHANGE39_13_1_, instrument5_.ID_CODE as ID40_13_1_, instrument5_.MIC_CODE as MIC41_13_1_, instrument5_.TICK_SIZE_TABLE_ID as TICK42_13_1_, instrument5_.CUT_OFF_TIME as CUT43_13_1_, instrument5_.NUMBER_OF_SETTLEMENT_DAYS_SELL as NUMBER44_13_1_, instrument5_.COMMISSION_BUY as COMMISSION45_13_1_, instrument5_.COMMISSION_SELL as COMMISSION46_13_1_, instrument5_.IS_INTERNAL_FUND as IS47_13_1_, instrument5_.IS_PROFESSIONAL_ONLY as IS48_13_1_, trader2_.ID_USERS as ID1_27_2_, trader2_.NAME as NAME27_2_, trader2_.USERNAME as USERNAME27_2_, trader2_.PASSWORD as PASSWORD27_2_, trader2_.PASSWORD_SALT as PASSWORD5_27_2_, trader2_.EMAIL as EMAIL27_2_, trader2_.PHONE_NUMBER as PHONE7_27_2_, trader2_.MOBILE_PHONE_NUMBER as MOBILE8_27_2_, trader2_.ACTIVE_DIRECTORY_USERNAME as ACTIVE9_27_2_, trader2_.FEE_TYPE as FEE10_27_2_, trader2_.IS_ACTIVE as IS11_27_2_, trader2_.IS_ACTIVE_DIRECTORY_USER as IS12_27_2_, trader2_.USERGROUP_ID as USERGROUP13_27_2_, trader2_.TRADER_TYPE as TRADER14_27_2_, trader2_.LAST_MODIFIED as LAST15_27_2_, trader2_.COMMENTS as COMMENTS27_2_, trader2_.DERIVATIVES_ACCESS_TYPE as DERIVAT17_27_2_, trader2_.LIVEMARKETDATA_USERNAME as LIVEMAR18_27_2_, trader2_.SSN as SSN27_2_, tradingdes1_.ID_USERGROUPS as ID1_24_3_, tradingdes1_.NAME as NAME24_3_, tradingdes1_.DESCRIPTION as DESCRIPT3_24_3_, tradingdes1_.ENABLED as ENABLED24_3_, tradingdes1_.GROUP_ROLE as GROUP5_24_3_, tradingdes1_.ACCESSRULE_LIST_ID as ACCESSRULE6_24_3_, tradingdes1_.HAS_DIRECT_MARKET_ACCESS as HAS7_24_3_, executions8_.ORDER_ID as ORDER4_8_, executions8_.ID_EXECUTION as ID1_8_, executions8_.ID_EXECUTION as ID1_11_4_, executions8_.Timestamp as Timestamp11_4_, executions8_.EXECUTION_ID as EXECUTION3_11_4_, executions8_.ORDER_ID as ORDER4_11_4_, executions8_.TRADES_ID as TRADES5_11_4_, executions8_.MARKETGATEWAY_ORDER_ID as MARKETGA6_11_4_, executions8_.CL_ORDER_ID as CL7_11_4_, executions8_.ORIG_CL_ORDER_ID as ORIG8_11_4_, executions8_.EXECUTED_PRICE as EXECUTED9_11_4_, executions8_.EXECUTED_QUANTITY as EXECUTED10_11_4_, executions8_.AVERAGE_PRICE as AVERAGE11_11_4_, executions8_.CUMULATED_QUANTITY as CUMULATED12_11_4_, executions8_.REMAINING_QUANTITY as REMAINING13_11_4_, executions8_.ORDER_PRICE as ORDER14_11_4_, executions8_.ORDER_QUANTITY as ORDER15_11_4_, executions8_.ORDER_CASH_QUANTITY as ORDER16_11_4_, executions8_.ORDER_QUANTITY_VISIBLE as ORDER17_11_4_, executions8_.EXECUTION_TYPE as EXECUTION18_11_4_, executions8_.EXEC_TRANS_TYPE as EXEC19_11_4_, executions8_.ORDER_STATUS as ORDER20_11_4_, executions8_.TRADE_DATE as TRADE21_11_4_, executions8_.TRANSACTION_TIME as TRANSAC22_11_4_, executions8_.EXECUTION_REPORT_DATE as EXECUTION23_11_4_, executions8_.ORIGINAL_MESSAGE as ORIGINAL24_11_4_, executions8_.CLIENT_REFERENCE as CLIENT25_11_4_, executions8_.COUNTERPARTY as COUNTER26_11_4_, executions8_.CLEARING_ACCOUNT as CLEARING27_11_4_, executions8_.CLEARING_FIRM as CLEARING28_11_4_, executions8_.ORDER_CAPACITY as ORDER29_11_4_, executions8_.ORDER_RESTRICTIONS as ORDER30_11_4_, executions8_.PEG_DIFFERENCE as PEG31_11_4_, executions8_.EXECUTION_INSTRUCTIONS as EXECUTION32_11_4_, executions8_.EXEC_RESTATEMENT_REASON as EXEC33_11_4_, executions8_.EXEC_BROKER as EXEC34_11_4_, executions8_.TEXT as TEXT11_4_, executions8_.TRADE_ID as TRADE36_11_4_, executions8_.CLIENT_ID as CLIENT37_11_4_, executions8_.SECONDARY_ORDER_ID as SECONDARY38_11_4_, executions8_.SEQUENCE_NUMBER as SEQUENCE39_11_4_, executions8_.BACKOFFICE_EXTERNAL_REF as BACKOFFICE40_11_4_, executions8_.DISPLAY_RANGE as DISPLAY41_11_4_, executions8_.STP_ACTION as STP42_11_4_, executions8_.STP_LEVEL as STP43_11_4_, executions8_.STP_TRADER_GROUP as STP44_11_4_, executions8_.DISPLAY_INSTRUCTIONS as DISPLAY45_11_4_, traderepor9_.ID_TRADE_REPORTS as ID1_22_5_, traderepor9_.Timestamp as Timestamp22_5_, traderepor9_.TRADE_REPORT_STATUS as TRADE3_22_5_, traderepor9_.AVERAGE_PRICE as AVERAGE4_22_5_, traderepor9_.CL_ORDER_ID as CL5_22_5_, traderepor9_.CUMULATED_QUANTITY as CUMULATED6_22_5_, traderepor9_.CURRENCY as CURRENCY22_5_, traderepor9_.EXECUTION_ID as EXECUTION8_22_5_, traderepor9_.ORDER_ID as ORDER9_22_5_, traderepor9_.ORDER_REFERENCE as ORDER10_22_5_, traderepor9_.ORDER_STATUS as ORDER11_22_5_, traderepor9_.SIDE as SIDE22_5_, traderepor9_.INSTRUMENT_ID as INSTRUMENT13_22_5_, traderepor9_.TEXT as TEXT22_5_, traderepor9_.EXECUTION_TYPE as EXECUTION15_22_5_, traderepor9_.REMAINING_QUANTITY as REMAINING16_22_5_, traderepor9_.TRADE_REPORT_ID as TRADE17_22_5_, traderepor9_.TRANSACTION_TIME as TRANSAC18_22_5_, traderepor9_.SETTLEMENT_DATE as SETTLEMENT19_22_5_, traderepor9_.SECURITY_DESCRIPTION as SECURITY20_22_5_, traderepor9_.COUNTERPARTY as COUNTER21_22_5_, traderepor9_.PRICE_TYPE as PRICE22_22_5_, traderepor9_.TRANSACTION_BKD_TIME as TRANSAC23_22_5_, traderepor9_.ORDER_CAPACITY as ORDER24_22_5_, traderepor9_.CLEARING_INSTRUCTION as CLEARING25_22_5_, traderepor9_.TRADE_TYPE as TRADE26_22_5_, traderepor9_.PUBLISH_TRADE_INDICATOR as PUBLISH27_22_5_, traderepor9_.TRADE_REPORT_TYPE as TRADE28_22_5_, traderepor9_.TRADE_MATCH_ID as TRADE29_22_5_, traderepor9_.SECONDARY_TRADEREPORT_REF_ID as SECONDARY30_22_5_, traderepor9_.TRADE_ID as TRADE31_22_5_, traderepor9_.OWN_TIMESTAMP as OWN32_22_5_, traderepor9_.COUNTERPARTY_TIMESTAMP as COUNTER33_22_5_, traderepor9_.LOCKED_IN as LOCKED34_22_5_, traderepor9_.REVERSAL_INDICATOR as REVERSAL35_22_5_, traderepor9_.PROCESS_CODE as PROCESS36_22_5_, traderepor9_.ORIGINAL_MESSAGE as ORIGINAL37_22_5_, traderepor9_.USER_ID as USER38_22_5_, traderepor9_.EXECUTING_FIRM as EXECUTING39_22_5_, traderepor9_.HOUSE as HOUSE22_5_, traderepor9_.CLEARING_ACCOUNT as CLEARING41_22_5_, traderepor9_.CLEARING_FIRM as CLEARING42_22_5_, traderepor9_.CONTRA_ORDER_RESTRICTIONS as CONTRA43_22_5_, traderepor9_.CONTRA_TRADE_PA as CONTRA44_22_5_, traderepor9_.DELAYED_DISSEMINATION as DELAYED45_22_5_, traderepor9_.EXEC_TRANS_TYPE as EXEC46_22_5_, traderepor9_.EXPIRE_DATE as EXPIRE47_22_5_, traderepor9_.INTERNAL as INTERNAL22_5_, traderepor9_.MIC_CODE as MIC49_22_5_, traderepor9_.ORDER_RESTRICTIONS as ORDER50_22_5_, traderepor9_.PARTY_ROLE as PARTY51_22_5_, traderepor9_.SETTLEMENT_BROKER_CODE as SETTLEMENT52_22_5_, traderepor9_.EXCHANGE_USER_NAME as EXCHANGE53_22_5_, traderepor9_.MARKETGATEWAY_ID as MARKETG54_22_5_, traderepor9_.EXEC_BROKER as EXEC55_22_5_, traderepor9_.CL_REF_ID as CL56_22_5_, traderepor9_.RFQ_REFERENCE_NO as RFQ57_22_5_, traderepor9_.CLEARING_PRICE as CLEARING58_22_5_, traderepor9_.OVERRIDE_FLAG as OVERRIDE59_22_5_, traderepor9_.CONTRA_CLEARING_ACCOUNT as CONTRA60_22_5_, traderepor9_.TRD_REPORT_STATUS as TRD61_22_5_, traderepor9_.TRADING_SESSION_ID as TRADING62_22_5_, traderepor9_.TRADE_REPORT_REF_ID as TRADE63_22_5_, traderepor9_.TRADING_SESSION_SUB_ID as TRADING64_22_5_, traderepor9_.TRADE_LINK_ID as TRADE65_22_5_, traderepor9_.DISSEMINATION_TIME as DISSEMI66_22_5_, traderepor9_.LOCKED_IN_STATUS as LOCKED67_22_5_, traderepor9_.BREAK_INDICATOR as BREAK68_22_5_, traderepor9_.MEMO as MEMO22_5_, traderepor9_.REQUESTED as REQUESTED22_5_, traderepor9_.INCLUDE_FEE_IN_PRICE as INCLUDE71_22_5_, traderepor9_.FEE_TYPE as FEE72_22_5_, traderepor9_.FEE as FEE22_5_, traderepor9_.ALLOCATION_PRICE as ALLOCATION74_22_5_, traderepor9_.TOTAL_FEE as TOTAL75_22_5_, traderepor9_.TOTAL_PAYMENT as TOTAL76_22_5_, traderepor9_.INITIAL_ORDERINSTRUCTION_ID as INITIAL77_22_5_, traderepor9_.STRAIGHT_THROUGH_PROCESSING as STRAIGHT78_22_5_, traderepor9_.REFERENCE_ID as REFERENCE79_22_5_, traderepor9_.CLIENT_REFERENCE as CLIENT80_22_5_, traderepor9_.EXECUTION_METHOD as EXECUTION81_22_5_, traderepor9_.CLEARING_ACCOUNT_TYPE as CLEARING82_22_5_, traderepor9_.TRADE_PRICE_CONDITION as TRADE83_22_5_, traderepor9_.TRADE_CLEARING_INSTRUCTIONS as TRADE84_22_5_, traderepor9_.CONNECTION_ID as CONNECTION85_22_5_, traderepor9_.STATUS as STATUS22_5_
FROM ORDERS this_
left outer join BROKERS broker4_ on this_.BROKER_ID=broker4_.ID_BROKERS
left outer join INSTRUMENTS instrument5_ on this_.INSTRUMENT_ID=instrument5_.ID_INSTRUMENTS
inner join USERS trader2_ on this_.EXECUTING_TRADER_ID=trader2_.ID_USERS
inner join USERGROUPS tradingdes1_ on this_.EXECUTING_FIRM_ID=tradingdes1_.ID_USERGROUPS
left outer join EXECUTIONS executions8_ on this_.ID_ORDERS=executions8_.ORDER_ID
left outer join TRADE_REPORTS traderepor9_ on this_.ID_ORDERS=traderepor9_.ORDER_ID
WHERE this_.ORDER_DATE >= '2017-05-01'
and this_.ORDER_DATE <= '2017-12-04'
and tradingdes1_.NAME in ('admin', 'Traders', 'KodiakStaff', 'jupiter', 'gamma')
