query
RESULTSET
query
  col_1 col_10 col_11 col_12 col_13 col_14 col_15 col_16 col_17 col_18 col_19 col_2 col_3 col_4 col_5 col_6 col_7 col_8 col_9
1 systemId systemId_dupe Comments2 CRM Activity2 companyName_dupe companyAddress_dupe companyCity_dupe companyState_dupe companyZipCode_dupe DupeScore Note Comments CRM Activity companyName companyAddress companyCity companyState companyZipCode Full Lookup
2 12318837 12319513 MERGE/DROP N LOCAL GOAT 2167 PARKWAY PIGEON FORGE TN 37863 3 Address + City + State KEEP N BILLY GOAT TAVERN 2167 PARKWAY PIGEON FORGE TN 37862 2167 PARKWAY - PIGEON FORGE - TN
3 12181018 12181016 MERGE/DROP N Breeze Snack Bar 16701 Front Beach Rd Panama City Beach FL 32413 3 Address + City + State KEEP N Breeze Snack Bar - Thomas Dr 16701 Front Beach Rd Panama City Beach FL 32408 16701 Front Beach Rd - Panama City Beach - FL
4 12249422 12239302 KEEP Y The CabbyShack 30 Town Wharf Plymouth MA 02360 3 Address + City + State MERGE/DROP N CabbyShack 30 town wharf Plymouth MA 02081 30 town wharf - Plymouth - MA
5 12264999 12243858 MERGE/DROP N Hot Table Panini Cafes (11) 1500 Main Street Springfield MA 01115 3 Address + City + State KEEP N Hot Table Sandwich Shop 1500 Main Street Springfield MA 01103 1500 Main Street - Springfield - MA
6 12266492 12266493 MERGE/DROP N Maggie Mcfly'S Springfield 6797 Springfield Mall Springfield VA 22150 3 Address + City + State KEEP N Maggie Mcfly'S 6797 Springfield Mall Springfield VA 22105 6797 Springfield Mall - Springfield - VA
7 12333702 12333701 MERGE/DROP N OSO 5749 BAY LA LAUNCH AVENUE ORANGE BEACH AL 36561 3 Address + City + State KEEP N OSO RESTAURANT 5749 BAY LA LAUNCH AVENUE ORANGE BEACH AL 36530 5749 BAY LA LAUNCH AVENUE - ORANGE BEACH - AL
8 12248487 12277985 MERGE/DROP N PREP Kitchen USA 3300 Marjan Drive Atlanta GA 30301 3 Address + City + State KEEP N Prep Atlanta 3300 Marjan Drive Atlanta GA 30340 3300 Marjan Drive - Atlanta - GA
9 12181990 12269017 MERGE/DROP N San Jose 7961 Skyland Ridge Pkwy Raleigh NC 27604 3 Address + City + State KEEP N San Jose Skyland 7961 Skyland Ridge Pkwy Raleigh NC 27617 7961 Skyland Ridge Pkwy - Raleigh - NC
10 12181053 12240131 MERGE/DROP N CANE GARDEN 1726 BAILEY TRL THE VILLAGES FL 32162 3 Name + Address + State KEEP N Cane Garden 1726 Bailey Trl Winter Garden FL 34787 [empty string]
11 12263468 11861512 MERGE/DROP N Elderberry's 3555 Electric Rd Roanoke VA 24018 3 Name + City + Zip KEEP N Elderberry'S 3555 ELECTRIC RD UNIT E Roanoke VA 24018 Elderberry'S - Roanoke - 24018
12 12249790 12166007 MERGE/DROP N taco boy 217 Huger St. Charleston SC 29403 3 Name + City + Zip KEEP N Taco Boy 217 Huger Street Charleston SC 29403 Taco Boy - Charleston - 29403
13 12270798 12166011 MERGE/DROP N Tiestos restaurante 411 W Main St Patchogue NY 11763 3 Name + City + Zip KEEP N Tiestos Restaurante 411 W Main St, Patchogue, NY 11772 Patchogue NY 11763 Tiestos Restaurante - Patchogue - 11763
14 12268969 12166064 MERGE/DROP N SALT on the Water 3100 Whaleneck Drive Merrick NY 11566 3 Name + City + Zip KEEP N Salt On The Water 3100 Whaleneck Drive Merrick, NY 11566 Merrick NY 11566 Salt On The Water - Merrick - 11566
15 12321447 12166125 MERGE/DROP N Veleros Cantina & Restaurant 7840 US # 41 Schererville IN 46375 3 Name + City + Zip KEEP N Veleros Cantina & Restaurant 7840 US Highway 41 Schererville IN 46375 Veleros Cantina & Restaurant - Schererville - 46375
CACHED false
EXECUTIONTIME 2
SQL select * from qmd_records where COL_1 > 0 and COL_2 > 0
query
RESULTSET
query
  OPERATORID
1 12318837
CACHED false
EXECUTIONTIME 24
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12318837 and companyName = 'BILLY GOAT TAVERN' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12319513 and companyName = 'LOCAL GOAT'
query
RESULTSET
query
  OPERATORID
1 12181018
CACHED false
EXECUTIONTIME 20
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12181018 and companyName = 'Breeze Snack Bar - Thomas Dr' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12181016 and companyName = 'Breeze Snack Bar'
query
RESULTSET
query
  OPERATORID
1 12239302
CACHED false
EXECUTIONTIME 30
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12249422 and companyName = 'CabbyShack' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12239302 and companyName = 'The CabbyShack'
query
RESULTSET
query
  OPERATORID
1 12264999
CACHED false
EXECUTIONTIME 34
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12264999 and companyName = 'Hot Table Sandwich Shop' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12243858 and companyName = 'Hot Table Panini Cafes (11)'
query
RESULTSET
query
  OPERATORID
1 12266492
CACHED false
EXECUTIONTIME 29
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12266492 and companyName = 'Maggie Mcfly''S' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12266493 and companyName = 'Maggie Mcfly''S Springfield'
query
RESULTSET
query
  OPERATORID
1 12333702
CACHED false
EXECUTIONTIME 29
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12333702 and companyName = 'OSO RESTAURANT' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12333701 and companyName = 'OSO'
query
RESULTSET
query
  OPERATORID
1 12248487
CACHED false
EXECUTIONTIME 32
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12248487 and companyName = 'Prep Atlanta' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12277985 and companyName = 'PREP Kitchen USA'
query
RESULTSET
query
  OPERATORID
1 12181990
CACHED false
EXECUTIONTIME 27
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12181990 and companyName = 'San Jose Skyland' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12269017 and companyName = 'San Jose'
query
RESULTSET
query
  OPERATORID
1 12181053
CACHED false
EXECUTIONTIME 23
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12181053 and companyName = 'Cane Garden' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12240131 and companyName = 'CANE GARDEN'
query
RESULTSET
query
  OPERATORID
1 12263468
CACHED false
EXECUTIONTIME 23
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12263468 and companyName = 'Elderberry''S' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 11861512 and companyName = 'Elderberry''s'
query
RESULTSET
query
  OPERATORID
1 12249790
CACHED false
EXECUTIONTIME 26
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12249790 and companyName = 'Taco Boy' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12166007 and companyName = 'taco boy'
query
RESULTSET
query
  OPERATORID
1 12270798
CACHED false
EXECUTIONTIME 26
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12270798 and companyName = 'Tiestos Restaurante' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12166011 and companyName = 'Tiestos restaurante'
query
RESULTSET
query
  OPERATORID
1 12268969
CACHED false
EXECUTIONTIME 32
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12268969 and companyName = 'Salt On The Water' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12166064 and companyName = 'SALT on the Water'
query
RESULTSET
query
  OPERATORID
CACHED false
EXECUTIONTIME 28
SQL select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12321447 and companyName = 'Veleros Cantina & Restaurant' union select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = 2252 and fsltablecode = 'MFR' and operatorId = 12166125 and companyName = 'Veleros Cantina & Restaurant'