query
RESULTSET	query   CDR_DSTCOMPANYTYPE CDR_RECORDID FSL_MAPPRIORITY FSL_MASTERLINKYN 1 B 342796 1 Y 2 S 371144 2 N 3 S 284504 3 N 4 S 285031 4 N
CACHED	false
EXECUTIONTIME	10
SQL	SELECT cdr_recordID, cdr_dstcompanytype, fsl_mapPriority, fsl_masterLinkYN FROM tbl_CDR_Distributors WHERE OwnerID = ? AND FSL_TableCode = ? AND fsl_dstid = ? ORDER BY COALESCE(FSL_mapPriority,99999) ASC, cdr_RecordID ASC
SQLPARAMETERS	array 1 1382 2 MFR 3 7063

query
RESULTSET	query   CDR_DSTCOMPANYTYPE CDR_RECORDID FSL_MAPPRIORITY FSL_MASTERLINKYN 1 B 342796 1 Y
CACHED	false
EXECUTIONTIME	0
SQL	select * from qmd_get_cdrrecordIDs where cdr_dstcompanytype = 'B' order by cdr_recordId

1

query
RESULTSET	query   CDR_DSTCOMPANYTYPE CDR_RECORDID FSL_MAPPRIORITY FSL_MASTERLINKYN 1 S 371144 2 N 2 S 284504 3 N 3 S 285031 4 N
CACHED	false
EXECUTIONTIME	0
SQL	select * from qmd_get_cdrrecordIDs where cdr_recordId not in ( 342796 )