Search Results For Company: NAES

Episcopal Schools

Search Results

Your search has returned 5 record(s). Displaying 1 to 5.

denotes School Exploratory Committee.

School Details
Boys Home of Virginia 414 Boys' Home Road Covington, VA 24426 Phone: 540-965-7700 · Fax: 540-965-7702 Grades: 1-12 · Type: Boarding Only · Student Body: Male Enrollment: 38 students A successful man has to start somewhere... Young men who come to Boys' Home have great promise, but have had limited opportunities to be successful. The mission encompasses their mental, physical, social and spiritual potentials. The population fluctuates between 35-45 young men, ages 6-18. Our cultural diversity is enriched by children from rural areas, those from cities or students who immigrated with their families to this country. No child is turned away because of the family's financial situation; extensive scholarships are available. www.boyshomeofva.org
Episcopal High School 1200 N. Quaker Lane Alexandria, VA 22302 Phone: 703-933-3000 · Fax: 703-933-3017 Grades: 9-12 · Type: Boarding Only · Student Body: Co-ed Enrollment: 425 students Guided by its founding principles of honor, academic distinction, spiritual growth, and community, Episcopal High School prepares young people with the intellectual and moral courage to pursue lives of ethical leadership and service as citizens of an increasingly connected world. www.episcopalhighschool.org
St. Andrew's School 350 Noxontown Road Middletown, DE 19709-1605 Phone: 302-378-9511 · Fax: 302-378-7120 Grades: 9-12 · Type: Boarding Only · Student Body: Co-ed Enrollment: 315 students Through intensive collaboration with great teachers, St. Andrew's students begin their study and appreciation of the accumulated wisdom of human culture, sharpen their analytical skills and develop their performance in oral, written and quantitative expression. Chapel services each week explore and define the values that hold St. Andrew's community together every day. www.standrews-de.org
St. Paul's School 325 Pleasant Street Concord, NH 03301-2591 Phone: 603-229-4600 · Fax: 603-225-0487 Grades: 9-12 · Type: Boarding Only · Student Body: Co-ed Enrollment: 536 students www.sps.edu
Saint Thomas Choir School 202 W. 58th Street New York, NY 10019-1406 Phone: 212-247-3311 · Fax: 212-247-3393 Grades: 4-8 · Type: Boarding Only · Student Body: Male Enrollment: 23 students www.choirschool.org

Back To Search

Total Time

Count

Avg Time

Query

0.037

1 call
292 rows

0.037

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (1458678267904334, 5604932403391, 5604932321550, 5604932394133, 63578400882894, 5604932321805, 5604932324027, 5604932321931, 5604932322021, 5604932323065, 5604932322985, 5604932322728, 5604932371336, 5604932323902, 5604932323366, 5604932323225, 5604932323741, 5604932322277, 5604932324302, 7290548071170110, 5604932415680, 5604932397599, 55804510076985, 284636072642373, 5604932379913, 5604932324526, 5604932324806, 5604932408043, 63591285784593, 63582695850050, 63831803953203, 5604932394093, 63578400882772, 5604932403401, 4460602709771724, 5604932325158, 5604932392515, 5604932325327, 5604932325441, 653930245652498, 5604932392677, 5604932412646, 5604932325633, 5604932392727, 5604932380094, 5604932386528, 5604932392688, 5604932325875, 5604932403306, 5604932326041, 5604932326234, 5604932394103, 5604932326...2394123, 5604932415712, 5604932415702, 5604932340851, 5604932340982, 5604932341206, 784110704394702, 5604932341759, 5604932381883, 3701596089221421, 5604932342346, 63578400882812, 5604932392579, 63818919051315, 5604932415690, 5604932392491, 63840393887781, 5604932342690, 45749991636998, 63582695850070, 5604932391478, 63728724738073, 63720134803493, 63586990817494, 5604932415458, 63591285784712, 63737314672698, 5604932343030, 5604932415481, 5604932343227, 19975892893731, 5604932343404, 17459042058246, 5604932382367, 5604932382188, 63733019705420, 5604932343785, 4941059226337297, 5604932344270, 709442697953380, 5604932344471, 5604932345688, 5604932392635, 5604932341178, 5604932331381, 5604932331367, 5604932346092, 5604932392648, 5604932392563, 5604932346214, 5604932346368, 63582695850126, 5604932394083, 5604932345039, 5604932346595, 5604932395705, 5604932346993, 5010577566990688, 5604932347458, 5604932348767, 5604932348432, 5604932348278, 5604932347982, 5604932347811, 5604932347698, 5604932410877, 5604932349764, 5604932350013, 5604932349920, 5604932349283, 5604932349485, 5604932411359, 5604932350421, 5604932350558, 5604932408264, 5604932351093, 5604932351147, 5604932351283, 186629213913100, 5604932352005, 5604932352094, 183150290403607, 4436520828141925, 5604932352356, 5604932352534, 5604932352902, 5604932353098, 5604932400141, 5604932353501, 5604932353295, 2062550669721696, 5604932353393, 5604932398051, 5604932353869, 5604932354142, 5604932354294, 5604932354699, 5604932354793, 5604932389444, 5604932355410, 5604932356012, 5604932390012, 5604932356166, 5604932355833, 5604932356722, 169745697472539, 5604932358594, 5604932357091, 5604932357377, 5604932358517, 5604932357620, 5604932357793, 3251986027774014, 5604932358321, 5604932345154, 213099097358444, 25854607905259521, 5604932358550, 5604932388804, 5604932358282, 5604932359011, 5604932358947, 5604932359814, 7119462343901194, 5604932361333, 5604932390507, 5604932360169, 5604932391839, 5604932361542, 5604932360968, 5604932360223, 5604932359699, 5604932392001, 371123829080173, 5604932361100, 5604932362461, 5604932362563, 5604932362961, 5604932391706, 5604932363128, 5604932365154, 5604932363496, 5604932364331, 5604932365249, 5604932364020, 5604932364898, 5604932364713, 5604932364413, 367344257859921, 5604932365300, 5604932365347, 5604932365596, 225515847811311, 5604932365991, 5604932366137, 5604932366485, 5604932366626, 5604932366784, 5604932367061, 5604932366935, 5604932391975, 5604932345343, 5604932368271, 5604932368140, 5604932368484, 5604932368331, 5604932395264, 808055147069664, 5604932383686, 5604932369066, 5604932369425, 5604932368614, 5604932369917, 5604932370362, 5604932370091, 5604932370795, 5604932370473, 5604932370588, 5604932371535, 5604932371149, 5604932371744, 4879641194005336, 5604932371961, 5604932370954, 5604932370854, 5604932372168, 5604932371261, 5604932372790, 5604932373172, 3937737686122610, 5604932373665, 5604932374044, 5604932373571, 5604932374308, 5604932413655, 5604932374792, 5604932374941, 5604932345555, 5604932375061, 5604932375627, 5604932375497, 5604932376938, 5604932376155, 5604932376007, 5604932375890, 5604932376651, 5604932376833, 5604932376539, 5604932327881, 5604932377066, 5604932377132, 5604932377220, 5604932377417, 3479507625313538, 5604932377009, 19570615484678145, 5604932377800, 5604932377956, 5604932378043, 5604932379076, 5604932379191, 5604932378514, 5604932379537, 5604932345997, 63720134803528, 5815385719370, 5604932426360, 5604932392977, 5152062379656628, 11954019266199556, 5604932379791, 174714974634173, 5604932384713, 5604932385006, 279181464175123, 5604932393951, 7053740754339438, 5604932393224, 5604932391038, 5604932385724, 5604932404161, 5604932395628, 5604932386407, 5604932386950, 5604932386784, 5604932387095, 5604932386285, 256096014958914, 20480117759279105, 5604932394113, 5604932423824, 5604932387803, 63586990817403, 5604932388158)) AND `Relationship`.`relationType` IN (1, 2, 3, 4)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.032

1 call
5 rows

0.032

SELECT DISTINCT hex(`directoryContact`.`IndividualId`) AS directoryContact___IndividualId, `directoryContact`.`EthnicityId` AS directoryContact___EthnicityId, `directoryContact`.`firstName` AS directoryContact___firstName, `directoryContact`.`lastName` AS directoryContact___lastName, `directoryContact`.`prefix` AS directoryContact___prefix, `directoryContact`.`suffix` AS directoryContact___suffix, `directoryContact`.`title` AS directoryContact___title, `directoryContact`.`mxxUpdatedBy` AS directoryContact___mxxUpdatedBy, `directoryContact`.`enteredBy` AS directoryContact___enteredBy, `directoryContact`.`gender` AS directoryContact___gender, `directoryContact`.`SalaryId` AS directoryContact___SalaryId, `directoryContact`.`ssn` AS directoryContact___ssn, `directoryContact`.`middleInitial` AS directoryContact___middleInitial, `directoryContact`.`email` AS directoryContact___email, `directoryContact`.`alternateEmail` AS directoryContact___alternateEmail, `directoryContact`.`emailFromThirdP...604932423860, 5604932426108, 5604932417369, 5604932417024, 5604932416971, 12677901644201985, 17626545782784, 885918609179126, 102984725823569, 256783209726525, 5604932417134, 5604932417107, 5604932416911, 5604932416984, 5604932416935, 256091719992165, 174693499797583, 5604932417180, 62105227100163, 5604932410043, 62075162329099, 6455335845996, 710499259908097, 5604932421480, 5604932420736, 5604932421883, 5604932424096, 5604932423943, 5604932416641, 5604932416595, 5604932425359, 5604932417803, 5604932417544, 5604932416738, 5604932417849, 5604932417792, 5604932424823, 7290509416464467, 5604932422017, 5604932418320, 6970083381346312, 5604932418470, 5604932418902, 5604932417286, 5604932418957, 6459630813277, 5604932416716, 5604932400545, 5604932424063, 5604932417555, 5604932417451, 5604932417438, 5604932417427, 5604932420434, 6459630813273, 5604932421675, 5604932425097, 5604932422122, 5604932416214, 5604932416606, 5604932424502, 5604932420572, 5604932417746, 5604932418260, 5604932418435, 5604932389770, 5604932325046, 5604932364583, 1589356942852097, 5604932404358, 362817362329662, 5604932416861, 26456998543414, 5604932426534, 5604932424881, 5604932418110, 5604932418097, 5604932418013, 5604932417986, 5604932417964, 5604932416874, 5604932418064, 5604932418173, 5604932418282, 5604932424917, 5604932418459, 5604932418529, 5604932426086, 5604932418494, 5604932418483, 5604932417566, 5604932425124, 4801876516143818, 4990863667101761, 5604932418564, 5604932422190, 384317968614318, 291675524038686, 213086212459500, 5604932419066, 33616709025878, 5604932425691, 5604932419129, 5604932419265, 5604932419545, 5604932419468, 5604932419347, 5604932419312, 5604932419252, 5604932419230, 12601434046539, 5010560387122277, 5604932419556, 5604932419594, 5604932419633, 5604932419644, 5604932419668, 5604932424542, 186624918945870, 5604932419807, 183158880337945, 4436525123109674, 5604932419868, 5604932419950, 5604932420007, 5604932426347, 5604932420092, 5604932420034, 5604932419996, 5604932419985, 5604932426130, 5604932420128, 5604932420224, 5604932420213, 5604932420294, 5604932424834, 5604932420353, 5604932420340, 169749992439911, 5604932420747, 5604932424684, 5604932420725, 5604932420676, 5604932420534, 5604932420497, 2531668472627213, 28826897072783361, 5604932420447, 5604932420821, 5604932420665, 5604932420807, 5604932421261, 5604932417613, 5604932424895, 5604932421220, 5604932421176, 5604932421165, 5604932421049, 5604932421038, 5604932420975, 5604932420962, 7119526768410630, 5604932421398, 5604932421411, 5604932421504, 5604932425084, 5604932421537, 5604932421804, 5604932421790, 5604932421777, 5604932421766, 5604932421722, 5604932421697, 5604932421664, 5604932421624, 5604932426584, 225515847811319, 5604932424017, 5604932421933, 5604932421946, 5604932422004, 5604932421993, 5604932425556, 5604932422206, 5604932422179, 5604932422157, 5604932416258, 808037967201007, 5604932422239, 5604932422330, 5604932422283, 5604932422468, 5604932422430, 5604932422769, 5604932422722, 5604932422683, 5604932422661, 5604932422636, 5604932422623, 5604932422599, 5604932422575, 5604932422517, 5604932422479, 5604932419583, 5604932422780, 4323150871396472, 7386630784548884, 5604932372920, 5604932373056, 5604932422954, 5604932423050, 5604932423014, 5604932422930, 5604932426620, 5604932423119, 5604932419055, 5604932423232, 5604932423388, 5604932423359, 5604932423324, 5604932423300, 5604932423243, 5604932423210, 5604932416887, 5604932423421, 5604932423459, 5604932423432, 5604932423410, 5604932423399, 5604932423503, 5604932423554, 5604932423529, 2946489298977089, 5604932423568, 5604932423719, 5604932423636, 5604932417732, 5604932419928, 293432165662789, 5604932425303, 5604932423871, 5604932425666, 5604932424991, 5604932424553, 5604932424367, 5604932424270, 5604932423144, 6399501271045, 279202939011404, 5604932424223, 5604932418775, 2088475092320265, 5604932421686, 5604932416690))) AND IFNULL(`Company`.`silent`, 2)!='1')) ORDER BY `Company`.`alphaSort`, `Company`.`name` LIMIT 0, 100

0.006

1 call
551 rows

0.006

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`status`=1) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.005

1 call
2 rows

0.005

SELECT DISTINCT hex(`SocialNetworking`.`SocialNetworkingId`) AS `SocialNetworkingId`, `SocialNetworking`.`socialnetwork`, `SocialNetworking`.`url`, `SocialNetworking`.`usertext` FROM (Company, SocialNetworking) WHERE `SocialNetworking`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x5190001406A

0.004

1 call
296 rows

0.004

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (1458678267904334, 5604932403391, 5604932321550, 5604932394133, 63578400882894, 5604932321805, 5604932324027, 5604932321931, 5604932322021, 5604932323065, 5604932322985, 5604932322728, 5604932371336, 5604932323902, 5604932323366, 5604932323225, 5604932323741, 5604932322277, 5604932324302, 7290548071170110, 5604932415680, 5604932397599, 55804510076985, 284636072642373, 5604932379913, 5604932324526, 5604932324806, 5604932408043, 63591285784593, 63582695850050, 63831803953203, 5604932394093, 63578400882772, 5604932403401, 4460602709771724, 5604932325158, 5604932392515, 5604932325327, 5604932325441, 653930245652498, 5604932392677, 5604932412646, 5604932325633, 5604932392727, 5604932380094, 5604932386528, 5604932392688, 5604932325875, 5604932403306, 5604932326041, 5604932326234, 5604932394103, 5604932326...45, 5604932416798, 5604932416296, 5604932426715, 5604932423860, 5604932426108, 5604932417369, 5604932417024, 5604932416971, 12677901644201985, 17626545782784, 885918609179126, 102984725823569, 256783209726525, 5604932417134, 5604932417107, 5604932416911, 5604932416984, 5604932416935, 256091719992165, 174693499797583, 5604932417180, 62105227100163, 5604932410043, 62075162329099, 6455335845996, 710499259908097, 5604932421480, 5604932420736, 5604932421883, 5604932424096, 5604932423943, 5604932416641, 5604932416595, 5604932425359, 5604932417803, 5604932417544, 5604932416738, 5604932417849, 5604932417792, 5604932424823, 7290509416464467, 5604932422017, 5604932418320, 6970083381346312, 5604932418470, 5604932418902, 5604932417286, 5604932418957, 6459630813277, 5604932416716, 5604932400545, 5604932424063, 5604932417555, 5604932417451, 5604932417438, 5604932417427, 5604932420434, 6459630813273, 5604932421675, 5604932425097, 5604932422122, 5604932416214, 5604932416606, 5604932424502, 5604932420572, 5604932417746, 5604932418260, 5604932418435, 5604932389770, 5604932325046, 5604932364583, 1589356942852097, 5604932404358, 362817362329662, 5604932416861, 26456998543414, 5604932426534, 5604932424881, 5604932418110, 5604932418097, 5604932418013, 5604932417986, 5604932417964, 5604932416874, 5604932418064, 5604932418173, 5604932418282, 5604932424917, 5604932418459, 5604932418529, 5604932426086, 5604932418494, 5604932418483, 5604932417566, 5604932425124, 4801876516143818, 4990863667101761, 5604932418564, 5604932422190, 384317968614318, 291675524038686, 213086212459500, 5604932419066, 33616709025878, 5604932425691, 5604932419129, 5604932419265, 5604932419545, 5604932419468, 5604932419347, 5604932419312, 5604932419252, 5604932419230, 12601434046539, 5010560387122277, 5604932419556, 5604932419594, 5604932419633, 5604932419644, 5604932419668, 5604932424542, 186624918945870, 5604932419807, 183158880337945, 4436525123109674, 5604932419868, 5604932419950, 5604932420007, 5604932426347, 5604932420092, 5604932420034, 5604932419996, 5604932419985, 5604932426130, 5604932420128, 5604932420224, 5604932420213, 5604932420294, 5604932424834, 5604932420353, 5604932420340, 169749992439911, 5604932420747, 5604932424684, 5604932420725, 5604932420676, 5604932420534, 5604932420497, 2531668472627213, 28826897072783361, 5604932420447, 5604932420821, 5604932420665, 5604932420807, 5604932421261, 5604932417613, 5604932424895, 5604932421220, 5604932421176, 5604932421165, 5604932421049, 5604932421038, 5604932420975, 5604932420962, 7119526768410630, 5604932421398, 5604932421411, 5604932421504, 5604932425084, 5604932421537, 5604932421804, 5604932421790, 5604932421777, 5604932421766, 5604932421722, 5604932421697, 5604932421664, 5604932421624, 5604932426584, 225515847811319, 5604932424017, 5604932421933, 5604932421946, 5604932422004, 5604932421993, 5604932425556, 5604932422206, 5604932422179, 5604932422157, 5604932416258, 808037967201007, 5604932422239, 5604932422330, 5604932422283, 5604932422468, 5604932422430, 5604932422769, 5604932422722, 5604932422683, 5604932422661, 5604932422636, 5604932422623, 5604932422599, 5604932422575, 5604932422517, 5604932422479, 5604932419583, 5604932422780, 4323150871396472, 7386630784548884, 5604932372920, 5604932373056, 5604932422954, 5604932423050, 5604932423014, 5604932422930, 5604932426620, 5604932423119, 5604932419055, 5604932423232, 5604932423388, 5604932423359, 5604932423324, 5604932423300, 5604932423243, 5604932423210, 5604932416887, 5604932423421, 5604932423459, 5604932423432, 5604932423410, 5604932423399, 5604932423503, 5604932423554, 5604932423529, 2946489298977089, 5604932423568, 5604932423719, 5604932423636, 5604932417732, 5604932419928, 293432165662789, 5604932425303, 5604932423871, 5604932425666, 5604932424991, 5604932424553, 5604932424367, 5604932424270, 5604932423144, 6399501271045, 279202939011404, 5604932424223, 5604932418775)) AND `Relationship`.`relationType` IN (1, 2, 3, 4)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.004

1 call
296 rows

0.004

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (1458678267904334, 5604932403391, 5604932321550, 5604932394133, 63578400882894, 5604932321805, 5604932324027, 5604932321931, 5604932322021, 5604932323065, 5604932322985, 5604932322728, 5604932371336, 5604932323902, 5604932323366, 5604932323225, 5604932323741, 5604932322277, 5604932324302, 7290548071170110, 5604932415680, 5604932397599, 55804510076985, 284636072642373, 5604932379913, 5604932324526, 5604932324806, 5604932408043, 63591285784593, 63582695850050, 63831803953203, 5604932394093, 63578400882772, 5604932403401, 4460602709771724, 5604932325158, 5604932392515, 5604932325327, 5604932325441, 653930245652498, 5604932392677, 5604932412646, 5604932325633, 5604932392727, 5604932380094, 5604932386528, 5604932392688, 5604932325875, 5604932403306, 5604932326041, 5604932326234, 5604932394103, 5604932326... 5604932423860, 5604932426108, 5604932417369, 5604932417024, 5604932416971, 12677901644201985, 17626545782784, 885918609179126, 102984725823569, 256783209726525, 5604932417134, 5604932417107, 5604932416911, 5604932416984, 5604932416935, 256091719992165, 174693499797583, 5604932417180, 62105227100163, 5604932410043, 62075162329099, 6455335845996, 710499259908097, 5604932421480, 5604932420736, 5604932421883, 5604932424096, 5604932423943, 5604932416641, 5604932416595, 5604932425359, 5604932417803, 5604932417544, 5604932416738, 5604932417849, 5604932417792, 5604932424823, 7290509416464467, 5604932422017, 5604932418320, 6970083381346312, 5604932418470, 5604932418902, 5604932417286, 5604932418957, 6459630813277, 5604932416716, 5604932400545, 5604932424063, 5604932417555, 5604932417451, 5604932417438, 5604932417427, 5604932420434, 6459630813273, 5604932421675, 5604932425097, 5604932422122, 5604932416214, 5604932416606, 5604932424502, 5604932420572, 5604932417746, 5604932418260, 5604932418435, 5604932389770, 5604932325046, 5604932364583, 1589356942852097, 5604932404358, 362817362329662, 5604932416861, 26456998543414, 5604932426534, 5604932424881, 5604932418110, 5604932418097, 5604932418013, 5604932417986, 5604932417964, 5604932416874, 5604932418064, 5604932418173, 5604932418282, 5604932424917, 5604932418459, 5604932418529, 5604932426086, 5604932418494, 5604932418483, 5604932417566, 5604932425124, 4801876516143818, 4990863667101761, 5604932418564, 5604932422190, 384317968614318, 291675524038686, 213086212459500, 5604932419066, 33616709025878, 5604932425691, 5604932419129, 5604932419265, 5604932419545, 5604932419468, 5604932419347, 5604932419312, 5604932419252, 5604932419230, 12601434046539, 5010560387122277, 5604932419556, 5604932419594, 5604932419633, 5604932419644, 5604932419668, 5604932424542, 186624918945870, 5604932419807, 183158880337945, 4436525123109674, 5604932419868, 5604932419950, 5604932420007, 5604932426347, 5604932420092, 5604932420034, 5604932419996, 5604932419985, 5604932426130, 5604932420128, 5604932420224, 5604932420213, 5604932420294, 5604932424834, 5604932420353, 5604932420340, 169749992439911, 5604932420747, 5604932424684, 5604932420725, 5604932420676, 5604932420534, 5604932420497, 2531668472627213, 28826897072783361, 5604932420447, 5604932420821, 5604932420665, 5604932420807, 5604932421261, 5604932417613, 5604932424895, 5604932421220, 5604932421176, 5604932421165, 5604932421049, 5604932421038, 5604932420975, 5604932420962, 7119526768410630, 5604932421398, 5604932421411, 5604932421504, 5604932425084, 5604932421537, 5604932421804, 5604932421790, 5604932421777, 5604932421766, 5604932421722, 5604932421697, 5604932421664, 5604932421624, 5604932426584, 225515847811319, 5604932424017, 5604932421933, 5604932421946, 5604932422004, 5604932421993, 5604932425556, 5604932422206, 5604932422179, 5604932422157, 5604932416258, 808037967201007, 5604932422239, 5604932422330, 5604932422283, 5604932422468, 5604932422430, 5604932422769, 5604932422722, 5604932422683, 5604932422661, 5604932422636, 5604932422623, 5604932422599, 5604932422575, 5604932422517, 5604932422479, 5604932419583, 5604932422780, 4323150871396472, 7386630784548884, 5604932372920, 5604932373056, 5604932422954, 5604932423050, 5604932423014, 5604932422930, 5604932426620, 5604932423119, 5604932419055, 5604932423232, 5604932423388, 5604932423359, 5604932423324, 5604932423300, 5604932423243, 5604932423210, 5604932416887, 5604932423421, 5604932423459, 5604932423432, 5604932423410, 5604932423399, 5604932423503, 5604932423554, 5604932423529, 2946489298977089, 5604932423568, 5604932423719, 5604932423636, 5604932417732, 5604932419928, 293432165662789, 5604932425303, 5604932423871, 5604932425666, 5604932424991, 5604932424553, 5604932424367, 5604932424270, 5604932423144, 6399501271045, 279202939011404, 5604932424223, 5604932418775, 2088475092320265, 5604932421686, 5604932416690)) AND `Relationship`.`relationType` IN (1, 2, 3, 4)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.004

8 calls
54 rows

0.000

SELECT * FROM StateProvince ORDER BY orderindex, id

0.004

1 call
1 row

0.004

SELECT COUNT(DISTINCT `Company`.`CompanyId`) AS count FROM (Company, Membership) WHERE (((`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`MembershipTypeId`=1) AND `Membership`.`status`=1) AND ((`Company`.`companyStatusId`=0x1 AND (`Company`.`dayBoarding`=2 AND `Company`.`CompanyId` IN (1458678267904334, 5604932403391, 5604932321550, 5604932394133, 63578400882894, 5604932321805, 5604932324027, 5604932321931, 5604932322021, 5604932323065, 5604932322985, 5604932322728, 5604932371336, 5604932323902, 5604932323366, 5604932323225, 5604932323741, 5604932322277, 5604932324302, 7290548071170110, 5604932415680, 5604932397599, 55804510076985, 284636072642373, 5604932379913, 5604932324526, 5604932324806, 5604932408043, 63591285784593, 63582695850050, 63831803953203, 5604932394093, 63578400882772, 5604932403401, 4460602709771724, 5604932325158, 5604932392515, 5604932325327, 5604932325441, 653930245652498, 5604932392677, 5604932412646, 5604932325633, 5604932392727, 56049323... 5604932426545, 5604932416798, 5604932416296, 5604932426715, 5604932423860, 5604932426108, 5604932417369, 5604932417024, 5604932416971, 12677901644201985, 17626545782784, 885918609179126, 102984725823569, 256783209726525, 5604932417134, 5604932417107, 5604932416911, 5604932416984, 5604932416935, 256091719992165, 174693499797583, 5604932417180, 62105227100163, 5604932410043, 62075162329099, 6455335845996, 710499259908097, 5604932421480, 5604932420736, 5604932421883, 5604932424096, 5604932423943, 5604932416641, 5604932416595, 5604932425359, 5604932417803, 5604932417544, 5604932416738, 5604932417849, 5604932417792, 5604932424823, 7290509416464467, 5604932422017, 5604932418320, 6970083381346312, 5604932418470, 5604932418902, 5604932417286, 5604932418957, 6459630813277, 5604932416716, 5604932400545, 5604932424063, 5604932417555, 5604932417451, 5604932417438, 5604932417427, 5604932420434, 6459630813273, 5604932421675, 5604932425097, 5604932422122, 5604932416214, 5604932416606, 5604932424502, 5604932420572, 5604932417746, 5604932418260, 5604932418435, 5604932389770, 5604932325046, 5604932364583, 1589356942852097, 5604932404358, 362817362329662, 5604932416861, 26456998543414, 5604932426534, 5604932424881, 5604932418110, 5604932418097, 5604932418013, 5604932417986, 5604932417964, 5604932416874, 5604932418064, 5604932418173, 5604932418282, 5604932424917, 5604932418459, 5604932418529, 5604932426086, 5604932418494, 5604932418483, 5604932417566, 5604932425124, 4801876516143818, 4990863667101761, 5604932418564, 5604932422190, 384317968614318, 291675524038686, 213086212459500, 5604932419066, 33616709025878, 5604932425691, 5604932419129, 5604932419265, 5604932419545, 5604932419468, 5604932419347, 5604932419312, 5604932419252, 5604932419230, 12601434046539, 5010560387122277, 5604932419556, 5604932419594, 5604932419633, 5604932419644, 5604932419668, 5604932424542, 186624918945870, 5604932419807, 183158880337945, 4436525123109674, 5604932419868, 5604932419950, 5604932420007, 5604932426347, 5604932420092, 5604932420034, 5604932419996, 5604932419985, 5604932426130, 5604932420128, 5604932420224, 5604932420213, 5604932420294, 5604932424834, 5604932420353, 5604932420340, 169749992439911, 5604932420747, 5604932424684, 5604932420725, 5604932420676, 5604932420534, 5604932420497, 2531668472627213, 28826897072783361, 5604932420447, 5604932420821, 5604932420665, 5604932420807, 5604932421261, 5604932417613, 5604932424895, 5604932421220, 5604932421176, 5604932421165, 5604932421049, 5604932421038, 5604932420975, 5604932420962, 7119526768410630, 5604932421398, 5604932421411, 5604932421504, 5604932425084, 5604932421537, 5604932421804, 5604932421790, 5604932421777, 5604932421766, 5604932421722, 5604932421697, 5604932421664, 5604932421624, 5604932426584, 225515847811319, 5604932424017, 5604932421933, 5604932421946, 5604932422004, 5604932421993, 5604932425556, 5604932422206, 5604932422179, 5604932422157, 5604932416258, 808037967201007, 5604932422239, 5604932422330, 5604932422283, 5604932422468, 5604932422430, 5604932422769, 5604932422722, 5604932422683, 5604932422661, 5604932422636, 5604932422623, 5604932422599, 5604932422575, 5604932422517, 5604932422479, 5604932419583, 5604932422780, 4323150871396472, 7386630784548884, 5604932372920, 5604932373056, 5604932422954, 5604932423050, 5604932423014, 5604932422930, 5604932426620, 5604932423119, 5604932419055, 5604932423232, 5604932423388, 5604932423359, 5604932423324, 5604932423300, 5604932423243, 5604932423210, 5604932416887, 5604932423421, 5604932423459, 5604932423432, 5604932423410, 5604932423399, 5604932423503, 5604932423554, 5604932423529, 2946489298977089, 5604932423568, 5604932423719, 5604932423636, 5604932417732, 5604932419928, 293432165662789, 5604932425303, 5604932423871, 5604932425666, 5604932424991, 5604932424553, 5604932424367, 5604932424270, 5604932423144, 6399501271045, 279202939011404, 5604932424223, 5604932418775, 2088475092320265, 5604932421686, 5604932416690))) AND IFNULL(`Company`.`silent`, 2)!='1'))

0.003

12 calls
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.003

3 calls
241 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.003

1 call
7 rows

0.003

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Address`.`BranchId`=`Branch`.`BranchId` AND `Branch`.`BranchId`=0x5190000CB06 ORDER BY `Address`.`zip`

0.003

1 call
10 rows

0.003

SELECT * FROM ECUSAProvince ORDER BY orderindex, id

0.003

1 call
2 rows

0.003

0.002

1 call
6 rows

0.002

SELECT * FROM CategoryOfSchool ORDER BY orderindex, id

0.002

1 call
11 rows

0.002

SELECT * FROM SocialNetwork ORDER BY orderindex, id

0.002

1 call
2 rows

0.002

1 call
3 rows

0.002

SELECT * FROM CompanyStatus ORDER BY orderindex, id

0.002

1 call
7 rows

0.002

SELECT * FROM SchoolRegion ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

COMMIT

0.002

1 call
0 rows

0.002

SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x5190001406A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex

0.002

5 calls
1 row

0.000

SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x3

0.002

1 call
2 rows

0.002

1 call
2 rows

0.002

1 call
2 rows

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Website, Company) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x5190001406A

0.002

5 calls
1 row

0.000

SELECT DISTINCT hex(`SocialNetwork`.`SocialNetworkId`) AS `SocialNetworkId`, `SocialNetwork`.`icon` FROM (SocialNetwork) WHERE `SocialNetwork`.`SocialNetworkId`=0x2

0.002

3 calls
117 rows

0.001

SELECT * FROM Diocese ORDER BY orderindex, id

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Company, Branch) WHERE `Branch`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x5190001406A ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.002

1 call
2 rows

0.002

0.001

1 call
0 rows

0.001

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x5190001406A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.001

2 calls
6 rows

0.001

SELECT * FROM MembershipType ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x5190000CAB4=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.001

1 call
1 row

0.001

1 call
1 row

0.001

5 calls
1 row

0.000

SELECT version from databasemap;

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Company) WHERE `Company`.`highResImageId`=`File`.`FileId` AND `Company`.`CompanyId`=0x67966A00000001

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (File, Company) WHERE `Company`.`promoImageId`=`File`.`FileId` AND `Company`.`CompanyId`=0x67966A00000001

0.001

3 calls
3 rows

0.000

SELECT * FROM DayBoarding ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Relationship`.`RelationshipId`) AS `RelationshipId`, `Relationship`.`relationType` FROM (Relationship, Company) WHERE `Relationship`.`childCompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x5190001406A

0.001

1 call
175 rows

0.001

SELECT * FROM webselect

0.001

3 calls
4 rows

0.000

SELECT * FROM StudentBodyGender ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Membership`.`MembershipId`) AS `MembershipId`, `Membership`.`MembershipTypeId`, `Membership`.`joined`, `Membership`.`expires`, `Membership`.`billingCycle`, `Membership`.`billingStart`, `Membership`.`renewalNoticeSent`, `Membership`.`dateRenewed`, `Membership`.`dateRenewallLetterSent`, `Membership`.`lastRenewallLentDate`, `Membership`.`dateCanncelled`, `Membership`.`cancelReason`, `Membership`.`enteredBy`, `Membership`.`updatedBy`, `Membership`.`dateofPaymeny`, `Membership`.`balanceDue`, `Membership`.`renewalAmount`, `Membership`.`paidDues`, `Membership`.`renewalStatus`, `Membership`.`memberSinceDate`, `Membership`.`status`, `Membership`.`marketingCode`, `Membership`.`memberRecordComment` FROM (Company, Membership) WHERE `Company`.`MembershipId`=`Membership`.`MembershipId` AND `Company`.`CompanyId`=0x67966A00000001

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000003 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000005 ORDER BY `Address`.`zip`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`maritalStatus`, `Individual`.`hasChildren`, `Individual`.`degreeLevel`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`interestInMentoring`, `Individual`.`availableToSpeak`, `Individual`.`ageGroup`, `Individual`.`officeType`, `Individual`.`otherJobFunction`, `Individual`.`formalSalutation`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`donorInterests`, `Individual`.`episcopalianSchoolAlumnus`, `Individual`.`schoolAttended`, `Individual`.`relatedToStudent`, `Individual`.`schoolStudentAttends`, `Individual`.`religiousAffiliation`, `Individual`.`networkFormat`, `Individual`.`SACompanyName`, `Individual`.`dontSnailmail`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`orderOfMinistry`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`muhlenbergSocietyDonor`, `Individual`.`congressParty`, `Individual`.`donorSalutation`, `Individual`.`donorEnvelopeName`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`includeOnMemberOnlyComms`, `Individual`.`ancestryEthnicitiesOther`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, Company) WHERE `Company`.`CompanyId`=0x67966A00000001 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x51900014096 ORDER BY `Address`.`zip`

0.001

1 call
1 row

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5190000CB06 ORDER BY `Address`.`zip`

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5190000CB06 ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x51900001A1D ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`maritalStatus`, `Individual`.`hasChildren`, `Individual`.`degreeLevel`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`interestInMentoring`, `Individual`.`availableToSpeak`, `Individual`.`ageGroup`, `Individual`.`officeType`, `Individual`.`otherJobFunction`, `Individual`.`formalSalutation`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`donorInterests`, `Individual`.`episcopalianSchoolAlumnus`, `Individual`.`schoolAttended`, `Individual`.`relatedToStudent`, `Individual`.`schoolStudentAttends`, `Individual`.`religiousAffiliation`, `Individual`.`networkFormat`, `Individual`.`SACompanyName`, `Individual`.`dontSnailmail`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`orderOfMinistry`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`muhlenbergSocietyDonor`, `Individual`.`congressParty`, `Individual`.`donorSalutation`, `Individual`.`donorEnvelopeName`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`includeOnMemberOnlyComms`, `Individual`.`ancestryEthnicitiesOther`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, Company) WHERE `Company`.`CompanyId`=0x67966A00000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x5190000701C ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x5190000CB07 ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x519000030DA ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x51900014096 ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x519000030DB ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x519000030DA ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`maritalStatus`, `Individual`.`hasChildren`, `Individual`.`degreeLevel`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`interestInMentoring`, `Individual`.`availableToSpeak`, `Individual`.`ageGroup`, `Individual`.`officeType`, `Individual`.`otherJobFunction`, `Individual`.`formalSalutation`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`donorInterests`, `Individual`.`episcopalianSchoolAlumnus`, `Individual`.`schoolAttended`, `Individual`.`relatedToStudent`, `Individual`.`schoolStudentAttends`, `Individual`.`religiousAffiliation`, `Individual`.`networkFormat`, `Individual`.`SACompanyName`, `Individual`.`dontSnailmail`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`orderOfMinistry`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`muhlenbergSocietyDonor`, `Individual`.`congressParty`, `Individual`.`donorSalutation`, `Individual`.`donorEnvelopeName`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`includeOnMemberOnlyComms`, `Individual`.`ancestryEthnicitiesOther`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, Company) WHERE `Company`.`CompanyId`=0x67966A00000001 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x519000030DA ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x51900014097 ORDER BY `Address`.`zip`

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x519000019C9=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x46A980000047C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`shippingAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5190000701B ORDER BY `Address`.`zip`

0.000

1 call
54 rows

0.000

select id, abbreviation from StateProvince

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address) WHERE `Address`.`AddressId`=0x51900001A1E ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x51900014097 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x10A91E00000039 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-27 19:03:57',`mxxCreatedBy`=NULL, `PageRequestId`=0x67966A00000000, `path`='forms/CompanyFormPublic/search', `formName`='naes_CompanyFormPublic', `site`='www', `clientAcronym`='NAES', `pid`='3353806', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.naes.maxx.matrixdev.net', `dbThreadId`='50537', `startTime`='2026-02-27 19:03:57', `sessionId`=0x4CE87DE3FA8A8CA6, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_dayBoarding\\':\\'2\\', \\'action\\':\\'find\\'}', `clientIPAddr`='216.73.216.211'

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xC857E0000000E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5190000CB06 ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x5190000308A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x51900006FE0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x51900001A1D ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A0000000B ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x51900001A1D ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5190000701B ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x51900014096 ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000008 ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x519000030DB AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x12448500000064 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x193AE700000001 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000011 ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x4735F00000460 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x5190000CB07 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Branch) WHERE `Branch`.`primaryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x5190000701B ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A0000000F AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Company, Country, Company2Country) WHERE (0x5190000CAB4=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Country`.`CompanyId` AND `Company2Country`.`CountryId`=`Country`.`CountryId`) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000023 ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x51900006FE0=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x5190000308A=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A0000001D ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000014 ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x5190000701C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Company, Company2Service, Service) WHERE (0x519000019C9=`Company`.`CompanyId` AND `Company`.`CompanyId`=`Company2Service`.`CompanyId` AND `Company2Service`.`ServiceId`=`Service`.`ServiceId`) ORDER BY orderindex

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000012 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x1E7BA00000228 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000009 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A0000001B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x119A1C00000293 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000017 ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Address, Individual) WHERE `Individual`.`mainAddressId`=`Address`.`AddressId` AND `Individual`.`IndividualId`=0x67966A00000020 ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A0000000C AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x51900001A1E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000018 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000021 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A00000024 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x67966A0000001E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

715979 function calls (707218 primitive calls) in 0.993 seconds Ordered by: cumulative time List reduced from 2380 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.997 0.997 /data/naes/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 0.707 0.707 /data/naes/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 0.665 0.665 /data/naes/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.665 0.665 /data/naes/current/naes_org/sites/www/forms/naes_CompanyFormPublic.py:13(search) 1 0.000 0.000 0.665 0.665 /data/naes/current/generic/sites/www/forms/CompanyFormPublic.py:87(search) 1 0.001 0.001 0.652 0.652 /data/naes/current/libs/framework/WebForm.py:1089(search) 1 0.000 0.000 0.476 0.476 /data/naes/current/libs/framework/WebForm.py:1505(mungeResultsAfterSearch) 2 0.000 0.000 0.306 0.153 /data/naes/current/libs/utils/decoratorutils.py:300(wrapper) 1 0.000 0.000 0.275 0.275 /data/naes/current/libs/framework/WebManager.py:88(createNewHandler) 1 0.000 0.000 0.275 0.275 /data/naes/current/libs/framework/WebSite.py:91(__init__) 1 0.000 0.000 0.261 0.261 /data/naes/current/libs/framework/WebForm.py:3254(processCursorForSearch) 50/5 0.001 0.000 0.261 0.052 /data/naes/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 5 0.000 0.000 0.261 0.052 /data/naes/current/libs/framework/DGEGroup.py:43(getDataDictionary) 357/168 0.005 0.000 0.210 0.001 {built-in method builtins.exec} 1 0.000 0.000 0.209 0.209 /data/naes/current/libs/framework/WebForm.py:1653(outputSearchResults) 207/129 0.001 0.000 0.205 0.002 :1165(_find_and_load) 177 0.001 0.000 0.203 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 207/129 0.001 0.000 0.202 0.002 :1120(_find_and_load_unlocked) 177 0.001 0.000 0.201 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.186 0.186 /data/naes/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.185 0.185 /data/naes/current/libs/framework/WebApp.py:212(wrapHTML) 177 0.001 0.000 0.181 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 177 0.180 0.001 0.180 0.001 {function Connection.query at 0xe5aefe456020} 275 0.001 0.000 0.173 0.001 /data/naes/current/libs/framework/DGEAttribute.py:110(getDataDictionary) 25/20 0.000 0.000 0.166 0.008 /data/naes/current/libs/framework/DGEMethod.py:107(getDataDictionary) 351 0.002 0.000 0.160 0.000 /data/naes/current/libs/framework/DGEAttribute.py:206(getValue) 224/144 0.001 0.000 0.160 0.001 :666(_load_unlocked) 222/144 0.001 0.000 0.154 0.001 :934(exec_module) 112 0.001 0.000 0.153 0.001 /data/naes/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 1 0.004 0.004 0.148 0.148 /data/naes/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups) 458/264 0.000 0.000 0.134 0.001 :233(_call_with_frames_removed) 1 0.000 0.000 0.128 0.128 /data/naes/current/libs/framework/DisplayGroup.py:311(initialize) 67 0.001 0.000 0.122 0.002 /data/naes/current/libs/utils/htmlTools.py:100(cleanHTML) 35 0.000 0.000 0.108 0.003 /data/naes/current/generic/classes/Address.py:340(generatePrettyHTML) 1 0.000 0.000 0.097 0.097 /data/naes/current/libs/framework/WebForm.py:2983(fillCursor) 5/1 0.000 0.000 0.096 0.096 /data/naes/current/libs/PLayer/PersistentBroker.py:769(processCriteria) 9812/9386 0.006 0.000 0.096 0.000 /data/naes/current/libs/framework/BaseHandler.py:1471(mxxImporter) 1 0.000 0.000 0.094 0.094 /data/naes/current/libs/framework/baseScrapeAndDrape.py:718(process) 1 0.000 0.000 0.091 0.091 /data/naes/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 10 0.000 0.000 0.091 0.009 /data/naes/current/generic/classes/Address.py:226(getPrintPrettyHTML) 1 0.000 0.000 0.090 0.090 /data/naes/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.090 0.090 /data/naes/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 9838/9391 0.008 0.000 0.090 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.089 0.089 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.089 0.089 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.089 0.089 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.088 0.088 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.088 0.088 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.003 0.003 0.088 0.088 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 2 0.001 0.000 0.083 0.041 /data/naes/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML) 8 0.005 0.001 0.081 0.010 /data/naes/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile) 843/630 0.002 0.000 0.080 0.000 /data/naes/current/libs/PLayer/PersistentObject.py:2704(__getattr__) 95/82 0.000 0.000 0.079 0.001 /data/naes/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 8 0.058 0.007 0.076 0.009 /data/naes/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 166 0.001 0.000 0.075 0.000 /usr/lib/python3.11/re/__init__.py:272(_compile) 151 0.000 0.000 0.075 0.000 /usr/lib/python3.11/re/__init__.py:225(compile) 39 0.000 0.000 0.073 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 205 0.042 0.000 0.061 0.000 :1054(_find_spec) 5/1 0.000 0.000 0.055 0.055 /data/naes/current/libs/PLayer/PersistentBroker.py:899(_preprocessCriteria) 52 0.000 0.000 0.053 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 356/332 0.001 0.000 0.053 0.000 /data/naes/current/libs/framework/LazyDict.py:186(__getitem__) 5 0.000 0.000 0.053 0.011 /data/naes/current/generic/sites/www/forms/CompanyFormPublic.py:176(_getDGByName) 5 0.000 0.000 0.053 0.011 /data/naes/current/libs/framework/WebSite.py:972(getDGByName) 5 0.000 0.000 0.053 0.011 /data/naes/current/libs/framework/LazyDict.py:172(get) 21/2 0.001 0.000 0.053 0.026 /data/naes/current/libs/framework/BaseHandler.py:481(_createDisplayGroup) 39 0.000 0.000 0.052 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 35 0.000 0.000 0.052 0.001 /data/naes/current/libs/PLayer/PersistentObject.py:2884(_loadListAssoc) 20 0.001 0.000 0.052 0.003 /data/naes/current/libs/framework/DGEAssocList.py:451(getDataDictionary) 35 0.001 0.000 0.051 0.001 /data/naes/current/libs/PLayer/PersistentObject.py:2930(_loadAssocListSQL) 134/20 0.001 0.000 0.048 0.002 /data/naes/current/libs/framework/DisplayGroup.py:631(_createDGE) 312/132 0.001 0.000 0.046 0.000 /data/naes/current/libs/PLayer/PersistentObject.py:108(new_init) 29 0.000 0.000 0.044 0.002 /data/naes/current/libs/framework/BaseHandler.py:1340(importModule) 25 0.001 0.000 0.044 0.002 /data/naes/current/libs/framework/WebSite.py:1133(_loadModule) 172/142 0.000 0.000 0.044 0.000 /data/naes/current/generic/classes/Company.py:364(__getattr__) 1 0.000 0.000 0.044 0.044 /data/naes/current/libs/framework/WebManInterface.py:92(createBroker) 1 0.000 0.000 0.043 0.043 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 111 0.042 0.000 0.043 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 267/249 0.000 0.000 0.043 0.000 /data/naes/current/libs/PLayer/PersistentBroker.py:77(__new__) 1400 0.006 0.000 0.042 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 19012/18586 0.008 0.000 0.041 0.000 {built-in method builtins.getattr} 3 0.000 0.000 0.040 0.013 /data/naes/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 3 0.000 0.000 0.040 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 3 0.000 0.000 0.040 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 222 0.002 0.000 0.040 0.000 :1007(get_code) 3 0.000 0.000 0.039 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 6 0.000 0.000 0.039 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 6 0.001 0.000 0.039 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 28 0.000 0.000 0.039 0.001 /data/naes/current/libs/framework/BaseHandler.py:1314(getModuleFromBase) 1 0.012 0.012 0.039 0.039 /data/naes/current/libs/PLayer/PersistentBroker.py:441(retrieveClassMaps) 1 0.000 0.000 0.039 0.039 /data/naes/current/libs/framework/DGEEmail.py:1() 70 0.003 0.000 0.039 0.001 /data/naes/current/libs/framework/DGESelect.py:120(getDataDictionary) 51 0.001 0.000 0.037 0.001 /data/naes/current/libs/PLayer/PersistentBroker.py:335(processSql) 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 2 0.000 0.000 0.035 0.018 /data/naes/current/libs/framework/WebForm.py:2893(getSearchRSDG) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1() 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1() 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 807/39 0.005 0.000 0.034 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 3 0.000 0.000 0.034 0.011 /data/naes/current/libs/framework/DisplayGroup.py:835(_createDGEGroup)