124 Unused Placeholders Deleted
query
RESULTSET
query
  CHO_ADDRESS CHO_CITY CHO_ID CHO_NAME CHO_RECORDSOURCE CHO_STATE CHO_ZIPCODE
1 1044 Garden St Greensburg 643108 Customer FNOXBR Alex Zientara on 10/19/2021 PA 15601
2 1898 E Colton Ave Redlands 816657 Customer Ceuwol Gerry D'Amelio on 12/16/2022 CA 92374
3 350 S Pacific Hwy Woodburn 828969 Customer Cuuaqp Chris Walck on 02/21/2023 OR 97071
4 125 Fort Mill Pkwy Fort Mill 882645 Customer Hcevnb MIchael Conner on 11/04/2023 SC 29715
5 800 Supreme Dr Bensenville 903738 Customer Fosvpz Gerry D'Amelio on 02/06/2024 IL 60106
6 1200 Hoover Ave Allentown 924694 Customer Jhuyvr Meghan Kidd on 05/14/2024 PA 18109
7 1200 Hoover Ave Allentown 933252 Customer Dwwumt MIchael Conner on 06/10/2024 PA 18109
8 1051 Amboy Ave Perth Amoby 953835 Customer Iswtul Gerry D'Amelio on 08/28/2024 NJ 08861
9 111 Alliant Dr Houston 962919 Customer Gpzjfn Michael Conner on 10/01/2024 TX 77032
10 7950 Spence Rd Fairburn 962920 Customer Hofcdr Michael Conner on 10/01/2024 GA 30213
11 1051 Amboy Ave Perth Amboy 965574 Customer Ehydff Gerry D'Amelio on 10/15/2024 NJ 08861
12 1051 Amboy Ave Perth Amboy 965575 Customer Gglwad Gerry D'Amelio on 10/15/2024 NJ 08861
13 10211 N i 35th Service Rd Oklahoma City 965876 Customer Cjdwhf Michael Conner on 10/17/2024 OK 73131
14 15155 NORTHAM ST LA MIRADA 966922 CUSTOMER FWCTCX 1FS Profile Database Management CA 90638
15 15155 Northam St LA Mirada 966954 Customer Ctjhid Meghan Kidd on 10/23/2024 CA 90638
16 15155 Northam St LA Mirada 966972 Customer Ijtpvb Meghan Kidd on 10/23/2024 CA 90638
17 15155 Northam St LA Mirada 967002 Customer Fohxtf Meghan Kidd on 10/24/2024 CA 90638
18 300 Lawrence Dr Livermore 969130 Customer Fkemvv Gerry D'Amelio on 11/04/2024 CA 94551
19 5425 S Williamson Blvd Port Orange 973784 Customer Clxyzn Gerry D'Amelio on 12/04/2024 FL 32128
20 120 Longs Pond Rd Lexington 973787 Customer Hyeevn Gerry D'Amelio on 12/04/2024 SC 29072
21 3520 E Francis Ave Spokane 973788 Customer Iyecff Gerry D'Amelio on 12/04/2024 WA 99217
22 8543 Page Ave Saint Louis 977488 Customer Csrmpj Gerry D'Amelio on 12/30/2024 MO 63114
23 15155 Northam St LA Mirada 977497 Customer Cnpled Gerry D'Amelio on 12/30/2024 CA 90638
24 3520 E Francis Ave Spokane 977498 Customer Ddehfb Gerry D'Amelio on 12/30/2024 WA 99217
25 800 Supreme Dr Bensenville 987810 Customer Gkyxjb Aaron Campbell on 03/03/2025 IL 60106
26 350 S Pacific Hwy Woodburn 996646 Customer Gwdyux Aaron Campbell on 03/31/2025 OR 97071
27 111 Alliant Dr Houston 998746 Customer Bcjqtb Gerry D'Amelio on 04/09/2025 TX 77032
28 111 Alliant Dr Houston 998747 Customer Htassl Gerry D'Amelio on 04/09/2025 TX 77032
29 950 S Shiloh Rd Garland 998748 Customer Ioxrpv Gerry D'Amelio on 04/09/2025 TX 75042
30 350 S Pacific Hwy Woodburn 1000597 Customer Fopifb Aaron Campbell on 04/28/2025 OR 97071
31 4650 W Buckeye Rd Phoenix 1005003 Customer Emncrz Aaron Campbell on 05/23/2025 AZ 85043
32 237 Otrobando Ave Norwich 1005537 Customer Iuwyhr Gerry D'Amelio on 05/28/2025 CT 06360
33 2255 High Hill Rd Bridgeport 1005539 Customer Grmpml Gerry D'Amelio on 05/28/2025 NJ 08104
34 1051 Amboy Ave Perth Amboy 1009277 Customer Ikxdwh Aaron Campbell on 06/18/2025 NJ 08861
35 11994 Livingston Rd Manassas 1011036 Customer Bmjbwd Michael Conner on 07/02/2025 VA 20109
36 350 S Pacific Hwy Woodburn 1014949 Customer Dadpql Michael Conner on 07/31/2025 OR 97071
37 350 S Pacific Hwy Woodburn 1014960 Customer Dpamux Michael Conner on 07/31/2025 OR 97071
38 350 S Pacific Hwy Woodburn 1014963 Customer Dwaonv Michael Conner on 07/31/2025 OR 97071
39 4455 Winters Ave Mcclellan Park 1014965 Customer Hcyczn Michael Conner on 07/31/2025 CA 95652
40 4455 Winters Ave Mcclellan Park 1014966 Customer Hjhcxz Michael Conner on 07/31/2025 CA 95652
41 350 S Pacific Hwy Woodburn 1014968 Customer Hpvuup Michael Conner on 07/31/2025 OR 97071
42 4455 Winters Ave Mcclellan Park 1014970 Customer Ivccih Michael Conner on 07/31/2025 CA 95652
43 300 LAWRENCE DR LIVERMORE 1015184 CUSTOMER CGHLFR Sam Kautz on 08/01/2025 CA 94551
44 300 LAWRENCE DR LIVERMORE 1015185 CUSTOMER CMOWAX Sam Kautz on 08/01/2025 CA 94551
45 300 LAWRENCE DR LIVERMORE 1015186 CUSTOMER COOBKH Sam Kautz on 08/01/2025 CA 94551
46 300 LAWRENCE DR LIVERMORE 1015211 CUSTOMER DKLAHR Sam Kautz on 08/01/2025 CA 94551
47 4455 WINTERS AVE MCCLELLAN PARK 1015214 CUSTOMER DXVRCH Sam Kautz on 08/01/2025 CA 95652
48 300 LAWRENCE DR LIVERMORE 1015215 CUSTOMER EPHGHJ Sam Kautz on 08/01/2025 CA 94551
49 350 S PACIFIC HWY WOODBURN 1015216 CUSTOMER ESSJHR Sam Kautz on 08/01/2025 OR 97071
50 850 N HILLS BLVD RENO 1015217 CUSTOMER FHACNV Sam Kautz on 08/01/2025 NV 89506
51 350 S PACIFIC HWY WOODBURN 1015218 CUSTOMER FNUMIP Sam Kautz on 08/01/2025 OR 97071
52 300 LAWRENCE DR LIVERMORE 1015219 CUSTOMER GJGBJR Sam Kautz on 08/01/2025 CA 94551
53 300 LAWRENCE DR LIVERMORE 1015220 CUSTOMER GRZQNV Sam Kautz on 08/01/2025 CA 94551
54 300 LAWRENCE DR LIVERMORE 1015221 CUSTOMER GYUAIP Sam Kautz on 08/01/2025 CA 94551
55 300 LAWRENCE DR LIVERMORE 1015223 CUSTOMER HBAMTJ Sam Kautz on 08/01/2025 CA 94551
56 300 LAWRENCE DR LIVERMORE 1015225 CUSTOMER IBLJAT Sam Kautz on 08/01/2025 CA 94551
57 4455 WINTERS AVE MCCLELLAN PARK 1015226 CUSTOMER IDEWLZ Sam Kautz on 08/01/2025 CA 95652
58 300 LAWRENCE DR LIVERMORE 1015227 CUSTOMER IMAATJ Sam Kautz on 08/01/2025 CA 94551
59 300 LAWRENCE DR LIVERMORE 1015228 CUSTOMER IUXSSL Sam Kautz on 08/01/2025 CA 94551
60 4455 WINTERS AVE MCCLELLAN PARK 1015229 CUSTOMER IZDKMP Sam Kautz on 08/01/2025 CA 95652
61 300 LAWRENCE DR LIVERMORE 1015621 CUSTOMER JBGSQX Sam Kautz on 08/05/2025 CA 94551
62 300 Lawrence Dr Livermore 1015659 Customer Bbjqct Gerry D'Amelio on 08/05/2025 CA 94551
63 300 Lawrence Dr Livermore 1015660 Customer Bdonkh Gerry D'Amelio on 08/05/2025 CA 94551
64 300 Lawrence Dr Livermore 1015661 Customer Cbqjpf Gerry D'Amelio on 08/05/2025 CA 94551
65 300 Lawrence Dr Livermore 1015662 Customer Ccbtln Gerry D'Amelio on 08/05/2025 CA 94551
66 300 Lawrence Dr Livermore 1015663 Customer Ciminf Gerry D'Amelio on 08/05/2025 CA 94551
67 4455 Winters Ave Mcclellan Park 1015665 Customer Cmqled Gerry D'Amelio on 08/05/2025 CA 95652
68 850 N Hills Blvd Reno 1015689 Customer Ctjfvr Gerry D'Amelio on 08/05/2025 NV 89506
69 300 Lawrence Dr Livermore 1015692 Customer Dirmwl Gerry D'Amelio on 08/05/2025 CA 94551
70 300 Lawrence Dr Livermore 1015696 Customer Dtkhjz Gerry D'Amelio on 08/05/2025 CA 94551
71 300 Lawrence Dr Livermore 1015699 Customer Dxztxf Gerry D'Amelio on 08/05/2025 CA 94551
72 300 Lawrence Dr Livermore 1015700 Customer Eeitvr Gerry D'Amelio on 08/05/2025 CA 94551
73 350 S Pacific Hwy Woodburn 1015701 Customer Ermdox Gerry D'Amelio on 08/05/2025 OR 97071
74 350 S Pacific Hwy Woodburn 1015702 Customer Erxnlf Gerry D'Amelio on 08/05/2025 OR 97071
75 300 Lawrence Dr Livermore 1015703 Customer Etyhxv Gerry D'Amelio on 08/05/2025 CA 94551
76 4455 Winters Ave Mcclellan Park 1015705 Customer Evqgfv Gerry D'Amelio on 08/05/2025 CA 95652
77 350 S Pacific Hwy Woodburn 1015706 Customer Fckqap Gerry D'Amelio on 08/05/2025 OR 97071
78 300 Lawrence Dr Livermore 1015708 Customer Ftxuix Gerry D'Amelio on 08/05/2025 CA 94551
79 4455 Winters Ave Mcclellan Park 1015709 Customer Gcyqol Gerry D'Amelio on 08/05/2025 CA 95652
80 4455 Winters Ave Mcclellan Park 1015710 Customer Glwinn Gerry D'Amelio on 08/05/2025 CA 95652
81 300 Lawrence Dr Livermore 1015711 Customer Gsfilz Gerry D'Amelio on 08/05/2025 CA 94551
82 4455 Winters Ave Mcclellan Park 1015713 Customer Gwlagd Gerry D'Amelio on 08/05/2025 CA 95652
83 300 Lawrence Dr Livermore 1015714 Customer Hbepoh Gerry D'Amelio on 08/05/2025 CA 94551
84 300 Lawrence Dr Livermore 1015715 Customer Hfdahb Gerry D'Amelio on 08/05/2025 CA 94551
85 4455 Winters Ave Mcclellan Park 1015716 Customer Hhldwx Gerry D'Amelio on 08/05/2025 CA 95652
86 300 Lawrence Dr Livermore 1015717 Customer Hjubxn Gerry D'Amelio on 08/05/2025 CA 94551
87 850 N Hills Blvd Reno 1015718 Customer Hlthgx Gerry D'Amelio on 08/05/2025 NV 89506
88 4455 Winters Ave Mcclellan Park 1015719 Customer Hlyzfb Gerry D'Amelio on 08/05/2025 CA 95652
89 300 Lawrence Dr Livermore 1015720 Customer Hnwplf Gerry D'Amelio on 08/05/2025 CA 94551
90 300 Lawrence Dr Livermore 1015722 Customer Iazzel Gerry D'Amelio on 08/05/2025 CA 94551
91 4455 Winters Ave Mcclellan Park 1015724 Customer Jkbwyh Gerry D'Amelio on 08/05/2025 CA 95652
92 300 Lawrence Dr Livermore 1022264 Customer Hcslbj Gerry D'Amelio on 09/04/2025 CA 94551
93 4455 Winters Ave Mcclellan Park 1024403 Customer Bqgnhf Meghan Kidd on 09/22/2025 CA 95652
94 10211 N i 35th Service Rd Oklahoma City 1025281 CUSTOMER HZPHEP Sam Kautz on 09/25/2025 OK 73131
95 10211 N i 35th Service Rd Oklahoma 1028305 Customer Ixtbrf Gerry D'Amelio on 10/06/2025 OK 73131
96 300 Lawrence Dr Livermore 1028710 Customer Diluyh Gerry D'Amelio on 10/08/2025 CA 94551
97 4455 Winters Ave Mcclellan Park 1028711 Customer Dtlwnf Gerry D'Amelio on 10/08/2025 CA 95652
98 950 S Shiloh Rd Garland 1029135 Customer Cdztpj Michael Conner on 10/09/2025 TX 75042
99 950 S Shiloh Rd Garland 1029137 Customer Czwsmt Michael Conner on 10/09/2025 TX 75042
100 950 S Shiloh Rd Garland 1029139 Customer Eadlzf Michael Conner on 10/09/2025 TX 75042
101 950 S Shiloh Rd Garland 1029140 Customer Eplszz Michael Conner on 10/09/2025 TX 75042
102 950 S Shiloh Rd Garland 1029142 Customer Ghfqut Michael Conner on 10/09/2025 TX 75042
103 950 S Shiloh Rd Garland 1038308 Customer Gjkoch Michael Conner on 11/11/2025 TX 75042
104 125 Fort Mill Pkwy Fort Mill 1042163 Customer Bbiroh Michael Conner on 12/03/2025 SC 29715
105 8543 Page Ave Saint Louis 1042165 Customer Drelnz Michael Conner on 12/03/2025 MO 63114
106 800 Fiber Optic Dr North Little Rock 1042166 Customer Giblfr Michael Conner on 12/03/2025 AR 72117
107 5900 E Holmes Rd Memphis 1042169 Customer Hzvjal Michael Conner on 12/03/2025 TN 38141
108 800 Fiber Optic Dr North Little Rock 1042172 Customer Jawcap Michael Conner on 12/03/2025 AR 72117
109 10211 N i 35 Service Rd Okalhaoma City 1042614 Customer Gciofn Gerry D'Amelio on 12/05/2025 OK 73131
110 5425 S Williamson Blvd Port Orange 1047864 Customer FDGYQT Gerry D'Amelio on 01/05/2026 FL 32128
111 12301 Cumberland Rd Fishers 1047865 Customer IKPWYT Gerry D'Amelio on 01/05/2026 IN 46038
112 125 Fort Mill Pkwy Fort Mill 1047916 Customer Bxfqlr Michael Conner on 01/06/2026 SC 29715
113 8543 Page Ave Saint Louis 1047921 Customer Cvhmqp Michael Conner on 01/06/2026 MO 63114
114 535 Dry Valley Rd Cookeville 1047923 Customer Dnfcsh Michael Conner on 01/06/2026 TN 38506
115 535 Dry Valley Rd Cookeville 1047928 Customer Dpprxz Michael Conner on 01/06/2026 TN 38506
116 10211 N i 35 Service Rd Oklahoma City 1047929 Customer Ebtfxv Michael Conner on 01/06/2026 OK 73131
117 535 Dry Valley Rd Cookeville 1047936 Customer Gwsyhv Michael Conner on 01/06/2026 TN 38506
118 10211 N i 35 Service Rd Oklahoma City 1047943 Customer Iqhhqt Michael Conner on 01/06/2026 OK 73131
119 535 Dry Valley Rd Cookeville 1047945 Customer Jhkubb Michael Conner on 01/06/2026 TN 38506
120 125 Fort Mill Pkwy Fort Mill 1047950 Customer Jjtril Michael Conner on 01/06/2026 SC 29715
121 535 Dry Valley Rd Cookeville 1047953 Customer Jkjuzz Michael Conner on 01/06/2026 TN 38506
122 1200 Hoover Ave Allentown 1048001 Customer Hdmpid Michael Conner on 01/06/2026 PA 18109
123 535 Dry Valley Rd Cookeville 1048006 Customer Cridux Michael Conner on 01/06/2026 TN 38506
124 535 Dry Valley Rd Cookeville 1048014 Customer Gxzkzj Michael Conner on 01/06/2026 TN 38506
CACHED false
EXECUTIONTIME 212
SQL select cho_id, cho_name, cho_address, cho_city, cho_state, cho_zipCode, cho_recordSource from tbl_CHO_Operators where cho_name like 'CUSTOMER ______' and not exists ( select * from tbl_OPR_CLientOperators with (nolock) where ownerId > 0 and fsl_choId = cho_id ) order by cho_id
Rolling Back