query
RESULTSET	query   BROKERID BROKEROFFICEID CMINDEX CUSTOMERMANAGERLEVEL CUSTOMERMANAGERLEVELRANK CUSTOMERMANAGERUSERID EMAIL FIRSTNAME FSPRO_USERID LASTNAME PHONE SETMETHOD TERRITORYID TERRITORYNAME TITLE brokerName 1 0 0 1 T 100 3103170 jamie.trainis@affinitysales.com Jamie 3103170 Trainis [empty string] 1 4938 AMW - Minnesota Market Manager [empty string] 2 0 0 2 T 101 2915493 derek.chojnacki@affinitysales.com Derek 2915493 Chojnacki 716-857-0270 1 4938 AMW - Minnesota Director of Sales Planning & Analytics [empty string] 3 0 0 1 T 200 2915493 derek.chojnacki@affinitysales.com Derek 2915493 Chojnacki 716-857-0270 0 3219 Affinity Group Midwest Director of Sales Planning & Analytics [empty string] 4 0 0 2 T 201 64465 neil.gladstone@affinitysales.com Neil 64465 Gladstone [empty string] 0 3219 Affinity Group Midwest Vice President of Strategy & Analytics [empty string] 5 0 0 1 T 300 64465 neil.gladstone@affinitysales.com Neil 64465 Gladstone [empty string] 0 4208 Affinity Group Corporate Vice President of Strategy & Analytics [empty string]
CACHED	false
EXECUTIONTIME	0
SQL	select BROKERID,BROKEROFFICEID,CMINDEX,CUSTOMERMANAGERLEVEL,CUSTOMERMANAGERLEVELRANK,CUSTOMERMANAGERUSERID,SETMETHOD,TERRITORYID,TERRITORYNAME, EMAIL,FIRSTNAME,FSPRO_USERID,LASTNAME,PHONE,TITLE from qmd_chain, qmd_customerManagerDetails where qmd_chain.customerManagerUserId = qmd_customerManagerDetails.fspro_userId order by customerManagerLevelRank