Home : Manufacturer List - View all Sponsors

View All Manufacturers

Go To: # A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Sponsors


Debugging Information
ColdFusion Server Enterprise 10,0,19,298511
Template /avcat/ctl8438/index.cfm
Time Stamp 23-Jun-17 02:52 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.198.147.79
Host Name 54.198.147.79


Execution Time

Total Time Avg Time Count Template
957 ms 957 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl8438/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
939 ms 939 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
863 ms 863 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfm
297 ms 3 ms 107 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMasterQuery() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
188 ms 2 ms 107 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMLCS() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
40 ms 40 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkNumber() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
28 ms 28 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header.cfm
25 ms 25 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav.cfm
20 ms 20 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl8438/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
20 ms 20 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
16 ms 16 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
15 ms 8 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(J) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(B) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(F) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(H) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(I) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(M) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(N) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
14 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(X) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(A) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(C) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(G) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(O) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(P) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(Q) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(R) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(T) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(U) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(W) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
13 ms 7 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(Z) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(D) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(E) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(K) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(L) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(S) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(V) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
12 ms 6 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | checkLetter(Y) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
10 ms 10 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfm
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(I) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(G) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(N) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(P) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(8438, 5) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(C) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(D) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(F) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(G) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(H) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(J) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(L) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(M) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(N) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(O) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(V) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(W) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByNumber() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(B) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(C) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(D) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(E) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(H) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(I) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(J) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(K) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(M) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(Q) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(R) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(S) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(U) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(Y) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(Z) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getCountryOptions(Select Country) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(A) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(B) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(E) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(K) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(P) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(Q) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(R) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(S) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(T) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(U) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(X) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(Y) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getAllByLetter(Z) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(A) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(F) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(L) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(O) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(T) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(V) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(W) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByLetter(X) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getMCSsByNumber() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getPINOptions(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldURLs(all, 5) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionRRC(8438, RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailPIN(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getFeaturedDetail(203110) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getFeaturedDetail(203130) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getFeaturedDetail(203203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getFeaturedDetail(300825) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203110) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203130) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(300825) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldDomain(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | setCurrentCatID([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | getBotWords() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getBasicUserInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getStateOptions(Select State, ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/avcat/ctl8438/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getLanguageID(en-gb) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleLanguage(5) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | createDynamicListArray(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(8438) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | startSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateReturnToURL(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/avcat/ctl8438/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getExclusionKeyList() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base.cfc | createFacebookMetaData([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc | setRange(all) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/manufacturersall/mans.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bad-css.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bottom-nav.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-pardot-doubleclick.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-google-analytics-code.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-javascript-caller.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-region-selector.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/zip-modal.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/exitmessage/exitmessage.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products-content.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
8 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
986 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=48, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 14:52:33.033
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8955, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:52:33.033
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
LOCAL.R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:52:33.033
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	[LOCAL].Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:52:33.033
			{ CALL ctlGetPINOptions(
				?
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

qmlcFind (Datasource=Ava_Fenster, Time=4ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:52:33.033
			SELECT	Catalog.catalog_id,
					Catalog_type_id
			FROM	Catalog
			WHERE	Catalog_url_id = ?
					AND (Catalog_type_id = 'mcs' OR catalog_type_id = 'mlc')
					AND Market_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = all
Parameter #2(cf_sql_integer) = 5

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8953, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:52:33.033
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:52:33.033
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

MasterGetCatalogDetailPIN (Datasource=Ava_Fenster, Time=0ms, Records=9, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:52:33.033
			{ CALL GetCatalogDetailALL_PIN }
		
LOCAL.R (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:52:33.033
	     	SELECT	CATALOG_ADDRESS1 ,
					CATALOG_ADDRESS2 ,
					CATALOG_ADDRESS3 ,
					CATALOG_CITY ,
					CATALOG_COMPANY_ID ,
					CATALOG_COUNTRY ,
					CATALOG_DISPLAY_NAME ,
					CATALOG_EMAIL_ADDRESS ,
					CATALOG_ID ,
					CATALOG_PHONE ,
					CATALOG_POSTCODE ,
					CATALOG_STATE_PROVINCE ,
					CATALOG_TYPE_ID ,
					CATALOG_URL ,
					CATALOG_URL_ID ,
					CATEGORY_TREE_ID ,
					COMPANY_DESCRIPTION ,
					CURRENCY_ID	 ,
					MARKET_ID ,
					PROFILE_ID ,
					VISION_IMPORT_ID
			FROM	MasterGetCatalogDetailPIN
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=4, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:52:33.033
			{ CALL GETAds (
				? ,
				'GroupB' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:52:33.033
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203203

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:52:33.033
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203130

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:52:33.033
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 300825

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:52:33.033
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203110

LOCAL.Q (Datasource=Ava_Fenster, Time=34ms, Records=456) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		IsNumber
			FROM 		[LOCAL].MasterQuery
			WHERE 		IsNumber = 1
		
LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=4, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			{ CALL GETAds (
				? ,
				'GroupB' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=68) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = A

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = B

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=42) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = D

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=20) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = F

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = G

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = H

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=10) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = I

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=7) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = J

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=15) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = K

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=20) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = L

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = M

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=17) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = N

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = O

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=27) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = P

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Q

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=18) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = R

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=33) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = S

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=22) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = T

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = U

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=14) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = V

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=15) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = W

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = X

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Y

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:33.033
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Z

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		ISNUMBER = 1
						AND CATALOG_TYPE_ID = 'MCS'
		
LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		ISNUMBER = 1
		
LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=68) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = A

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=28) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = A

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=68) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = A

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = B

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=11) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = B

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = B

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=42) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=17) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=42) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = C

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = D

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=7) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = D

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = D

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=20) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=9) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=20) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = E

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = F

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = F

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = F

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = G

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=6) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = G

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = G

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = H

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = H

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = H

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=10) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = I

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = I

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=10) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = I

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=7) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = J

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = J

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=7) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = J

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=15) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = K

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=6) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = K

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=15) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = K

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=20) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = L

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=6) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = L

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=20) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = L

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = M

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=5) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = M

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=23) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = M

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=17) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = N

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = N

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=17) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = N

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = O

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = O

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=8) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = O

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=27) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = P

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=10) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = P

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=27) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = P

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Q

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Q

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Q

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=18) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = R

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=5) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = R

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=18) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = R

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=33) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = S

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=11) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = S

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=33) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = S

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=22) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = T

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=7) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = T

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=22) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = T

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = U

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = U

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = U

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=14) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = V

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = V

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=14) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = V

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=15) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = W

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=4) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = W

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=15) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = W

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = X

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = X

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=3) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = X

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Y

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Y

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Y

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		FirstCharacter
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Z

LOCAL.Q (Datasource=Ava_Fenster, Time=1ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ?
						AND CATALOG_TYPE_ID = 'MCS'
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Z

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=456, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 	DISTINCT 
					CATALOG.Catalog_ID AS Child_Catalog_ID , 
					CATALOG.Catalog_Company_ID , 
					CATALOG.Catalog_Display_Name , 
					CATALOG.Catalog_Type_ID , 
					Catalog.Catalog_URL_ID ,
					UPPER(LEFT(Catalog.Catalog_Display_Name, 1)) AS FirstCharacter ,
					ISNUMERIC(LEFT(Catalog.Catalog_Display_Name, 1)) AS IsNumber
			FROM 	CATALOG_MANUFACTURER_LINE 
					INNER JOIN MANUFACTURER_LINE 
						ON CATALOG_MANUFACTURER_LINE.Manufacturer_Line_ID = MANUFACTURER_LINE.Manufacturer_Line_ID 
					INNER JOIN CATALOG 
						ON MANUFACTURER_LINE.Manufacturer_ID = CATALOG.Catalog_Company_ID 
							AND CATALOG.Market_ID = MANUFACTURER_LINE.Market_ID
			WHERE 	CATALOG.Catalog_Type_ID IN ('MLC','MCS')
					AND CATALOG_MANUFACTURER_LINE.Catalog_ID = ?
			ORDER BY CATALOG.Catalog_Display_Name

		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8438

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=2) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT 		CATALOG_COMPANY_ID , 
						CATALOG_DISPLAY_NAME ,
						CATALOG_TYPE_ID , 
						CATALOG_URL_ID ,
						CHILD_CATALOG_ID ,
						FIRSTCHARACTER ,
						ISNUMBER
			FROM 		[LOCAL].MasterQuery
			WHERE 		FirstCharacter = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Z

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203130

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 300825

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203203

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\manufacturersall\mans.cfc @ 14:52:34.034
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203110

LOCAL.GetCountries (Datasource=Ava_Fenster, Time=5ms, Records=244) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base.cfc @ 14:52:34.034
			SELECT 		Country_Code_ID ,
						Country_Abbr , 
						Country
			FROM 		Country_Code
			ORDER BY 	Country
		


Stored Procedures

GetCatalogDetail (Datasource=Ava_Fenster, Time=3ms) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 14:52:33.033

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  8438    
    
resultsets
nameresultset
 LOCAL.Q  1


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\avcatalogs\avcat\CTL8438\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=audiovisual.cbcitelecom.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL8438\index.cfm
QUERY_STRING=manufacturer=all
REMOTE_ADDR=54.198.147.79
REMOTE_HOST=54.198.147.79
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/ctl8438/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=297523755
CFTOKEN=c8042b5ae9c6d8fa-5EF86CB9-5056-A129-7602490B9240F7EE
USERINFO=0,0
Session Variables:
opts=Struct (42)
sessionid=3D0182CCC86BD0E49035C5FD0CDFBA83.cfusion
urltoken=CFID=297523755&CFTOKEN=c8042b5ae9c6d8fa-5EF86CB9-5056-A129-7602490B9240F7EE&jsessionid=3D0182CCC86BD0E49035C5FD0CDFBA83.cfusion
userinfo=Struct (14)
userinfomrc=Struct (2)
userinforrcpvd=Struct (0)
URL Parameters:
manufacturer=all
Debug Rendering Time: 110 ms