Skip to main content

WRITTEN by Samantha Bosshart, Saratoga springs Preservation Foundation
Photos provided by Roohan Realty (Unless Noted)

[From the 2025 Home & Garden Magazine]

 

Charles S. Lester Residence,
courtesy of the Joki Collection, Saratoga Springs Public Library.

The stately Colonial Revival residence set back on a large, treed lot on North Broadway that you see today was built in 1915, replacing a landmark, the former residence of Charles S. Lester, a prominent attorney, renowned judge, and businessman. 

In 1875, after acquiring several vacant lots on North Broadway, Lester built a residence at 747 North Broadway, the most northerly building on North Broadway at the time of construction. The large Stick style brick 22-room house was known as Adirondack Villa. The Stick style, popular between 1860 and 1890, is a transitional style that links the preceding Gothic Revival with the subsequent Queen Anne style. Typical of the style, the house had a steeply pitched roof with exposed eaves, front-facing gable, decorative horseshoe wood trusses at the apex of the gables, a tower, and a porch with cross patterned balustrades. It was here that he and his wife Lucy “entertained their friends with gracious hospitality for many years” according to the Saratogian. When the Lesters constructed a new house at 694 North Broadway, they sold the property to Eliza B. Downing, the wife of Augustus C. Downing, in 1886.   

The Downings were a prominent New York family that summered in Saratoga Springs. Six months after acquiring the property Eliza and Augustus C. Downing Sr. conveyed the property to their son, Augustus Jr. He and his wife, Flora, renamed the residence Cornwall Manor, for Augustus’ middle name. The New York Evening Telegram reported on July 27, 1887, that “Mr. Downing has added a spacious ballroom and made many improvements.” The New York Herald reported the Downings “entertain handsomely and give select dancing parties in their large ballroom.”   

On February 28, 1897, the New York Herald listed Cornwall Manor for sale or rent. It was described as

a large modern brick House, with ‘port cochere,’ piazzas on three sides: on first floor, large hall, billiard, reception and ball rooms, parlor, dining room with large butler’s pantry, kitchen and servants’ offices: second floor eight bedrooms, dressing rooms, and baths: third floor, four bedrooms and bathrooms, and three servants’ rooms: plenty of closet room on all floors: house is fully furnished: large coach house, harness room, stalls for five horses, two rooms in loft.

It appears that Edward O. Bartlett, Jr. rented the property and opened “The Manor School for Girls” in 1899. The school was short lived, as by 1901 Bartlett had removed to New Haven, Connecticut and the house was listed as vacant. It appears that the house remained vacant, and its condition deteriorated.

Susan Griffith, who hailed from New York City and summered in Saratoga Springs, was considering building a residence in Saratoga Springs. On October 28, 1913, Lewis M. Jones wrote Miss Griffith about a suitable lot to build, suggesting the Cornwall Manor property.  “The lot, a magnificent corner, is 250 feet front by 300 feet deep to the next street it would make beautiful grounds for a stately home it is well defined by nature, there being many grand and lordly trees upon it.” The asking price was $75,000, but Susan and her sister Margarette acquired it for $40,000 on January 30, 1914. 

On February 12, 1914, the Saratogian announced,

The Misses Margaret(sic) E. and Susan D. Griffith are to become property owners. The Misses Griffith have purchased the property known as “Cornwall Manor” on North Broadway and will occupy it this summer… The Misses Griffith have occupied the residence of the late James Lee Scott on Union Avenue for several summers. They are fond of Saratoga and some time ago gave $30,000 to the Bethesda Church for its music fund.

Immediately following the summer season, the Saratogian reported on September 9, 1914, that E. C. Eaton Wrecking Co. began wrecking Cornwall Manor. A follow up article titled “Saratoga Springs Loses One of Old Landmarks,” announced that a “new handsome modern residence” will be erected on the property.

The unmarried sisters appear to have hired prominent local architect R. Newton Brezee to design their new residence. Typical of the Colonial Revival style, it has a symmetrical facade with a center door with sidelights, an entry porch with columns, and six-over-one double hung windows. The house is unique because it is clad with stucco. 

In 1918, Margarette Griffith began a series of large gifts to Skidmore College. The gifts of Margarette were of “such critical importance” to the college at the time that the trustees voted to name the building that housed the scientific laboratories “Margarette E. Griffith Hall.”  The Saratogian dated September 17, 1929, reported that “she herself greeted the specific use of her name in this way and expressed the strong wish that it should bear simply her family name and it be called Griffith Hall.” 

743 North Broadway past and present.
Top photo: Circa 1938, courtesy of the George S. Bolster Collection, Saratoga Springs History Museum
Griffith Hall, Skidmore College, 62 Circular Street, Photo courtesy of Skidmore College

Following Margarette’s passing in 1925, Susan continued to make generous gifts to the college, making contributions to the endowment, organ, and other funds to provide for the enlargement and remodeling of Griffith Hall in 1929. Upon completion of the enlargement and remodel of the scientific labs, trustees voted to carry out Margarette’s original wish and included all of the college’s scientific laboratories under the name Griffith Hall. The college president at the time, Henry T. Moore, characterized Susan’s service “a personal record of generosity to Skidmore which is second only to Mrs. Scribner herself” – an impressive statement considering Mrs. Scribner was the founder of the college. 

Susan passed away in 1938 and bequeathed her residence at 743 North Broadway to the Presbyterian Hospital of New York. In 1942, it was sold to James Beverley, president of the Ballston-Stillwater Knitting Company and his wife Caroline. In 1950, the property was advertised for public auction. It was described as “one of the finest homes in Saratoga Springs, 15 rooms, year around, excellent condition,” and  advertised as three building lots, approximately 100’ x 150’. The starting bids were $2,000,000 and $1,000,000. Ultimately, the property was not subdivided.   

Robert B. and Sally Harvey acquired the property on August 10, 1950, and two weeks later sold it to Arthur Kerney, who later became mayor of Saratoga Springs, and his wife Phyllis. In 1957, Christopher T. Chenery purchased 743 North Broadway to be his summer residence. That same year, he bought an additional property, increasing the frontage of North Broadway to 400’. 

Chenery, born in Richmond, Virginia, founded and served as president of the Federal Water Service Corporation which was superseded by Southern Natural Gas Company.  He also invested in offshore drilling in the Gulf of Mexico.  However, his true passion was horses, and he established the famed Meadow Stud, credited with breeding 43 stakes winners. Chenery was one of three men appointed by The Jockey Club in the early 1950s to restructure New York racing, establishing what became the New York Racing Association. In 1960, he transferred 743 North Broadway to Meadow Stud.

In 1968, Chenery became ill, and his daughter, Penny Chenery, took charge of Meadow Stud.  Penny is best known for her role in breeding and racing Secretariat. In 1972, Secretariat won Horse of the Year. In January 1973, her father passed away. That year, Secretariat went on to win the Triple Crown, the first horse to do so in 25 years.  Secretariat set and still holds the fastest time record in all three races. His most famous loss was Onion that year at Saratoga Race Course. Secretariat is still widely regarded as one of the greatest racehorses of all time. 

In 1975, 743 North Broadway was sold to Wade Mack, a one-time registrar and Dean of Faculty of Skidmore College, and his wife Patrice. The following year, John Behrmann, a dentist, and his wife Linda purchased it. In 1980, William S. Farish III acquired the property for a summer residence.  William is a former ambassador to the United Kingdom and thoroughbred breeder, owner, and founder of Lanes End Farm, which has sold more than 350 stakes winners. 

Continuing the horse racing tradition, Ann and William Pape purchased 743 North Broadway in 2010. William has been involved in steeplechase racing for more than 50 years. He is one of the leading owners and has served as president of the National Steeplechase Association. The Papes have taken great care and made significant investment to preserve the house. After owning the property for 15 years, it is now on the market. The Foundation hopes that the new owner will continue to be a good steward for generations to come.    

7.951MBMemory Usage110msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.23
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.4.5
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "11" "id" => "834" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1752606122 "last" => 1752606122...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (2.46ms)
  • afterInitialise (1.96MB) (26.39ms)
  • afterRoute (375.45KB) (4.2ms)
  • beforeRenderComponent com_content (49.04KB) (721μs)
  • Before Access::preloadComponents (all components) (43.72KB) (1.31ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.83ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (16μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (1.9ms)
  • Before Access::getAssetRules (id:1009 name:com_content.article.834) (18.65KB) (46μs)
  • After Access::getAssetRules (id:1009 name:com_content.article.834) (11.38KB) (154μs)
  • afterRenderComponent com_content (1.59MB) (45.53ms)
  • afterDispatch (29.42KB) (911μs)
  • beforeRenderRawModule mod_finder () (376.02KB) (8.74ms)
  • afterRenderRawModule mod_finder () (1.95MB) (7.33ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (127μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (174μs)
  • afterRenderRawModule mod_menu () (12.58KB) (556μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (119μs)
  • beforeRenderRawModule mod_custom () (920B) (62μs)
  • afterRenderRawModule mod_custom () (320.1KB) (918μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (53μs)
  • beforeRenderRawModule mod_menu () (24B) (68μs)
  • afterRenderRawModule mod_menu () (552B) (319μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (57μs)
  • beforeRenderRawModule mod_custom () (920B) (49μs)
  • afterRenderRawModule mod_custom () (1.03KB) (121μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (69μs)
  • afterRenderRawModule mod_menu () (4.45KB) (338μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (66μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (498μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (76μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (117μs)
  • beforeRenderModule mod_custom () (704B) (16μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (4.23KB) (133μs)
  • afterRenderRawModule mod_custom () (1008B) (108μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (42μs)
  • beforeRenderRawModule mod_custom () (472B) (52μs)
  • afterRenderRawModule mod_custom () (1008B) (109μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (39μs)
  • afterRender (306.95KB) (2.81ms)
  • 1 x afterRenderComponent com_content (1.59MB) (41.3%)
    45.53ms
    1 x afterInitialise (1.96MB) (23.94%)
    26.39ms
    1 x beforeRenderRawModule mod_finder () (376.02KB) (7.93%)
    8.74ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (6.65%)
    7.33ms
    1 x afterRoute (375.45KB) (3.81%)
    4.20ms
    1 x afterRender (306.95KB) (2.55%)
    2.81ms
    1 x afterLoad (444.73KB) (2.23%)
    2.46ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.73%)
    1.90ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.66%)
    1.83ms
    1 x Before Access::preloadComponents (all components) (43.72KB) (1.18%)
    1.31ms
    1 x afterRenderRawModule mod_custom () (320.1KB) (0.83%)
    918μs
    1 x afterDispatch (29.42KB) (0.83%)
    911μs
    1 x beforeRenderComponent com_content (49.04KB) (0.65%)
    721μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.5%)
    556μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.45%)
    498μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.31%)
    338μs
    1 x afterRenderRawModule mod_menu () (552B) (0.29%)
    319μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.2%)
    217μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.16%)
    174μs
    1 x After Access::getAssetRules (id:1009 name:com_content.article.834) (11.38KB) (0.14%)
    154μs
    1 x beforeRenderRawModule mod_custom () (4.23KB) (0.12%)
    133μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.12%)
    127μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.11%)
    121μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.11%)
    119μs
    1 x afterRenderRawModule mod_custom () (912B) (0.11%)
    117μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.1%)
    111μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.1%)
    110μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    76μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.06%)
    69μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.06%)
    68μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    66μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    57μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    53μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    52μs
    1 x Before Access::getAssetRules (id:1009 name:com_content.article.834) (18.65KB) (0.04%)
    46μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    42μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    39μs
    5 x beforeRenderModule mod_custom () (704B) (0.03%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    16μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
53 statements were executed, 5 of which were duplicates, 48 unique28.75ms914.27KB
  • SELECT @@SESSION.sql_mode;111μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?668μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 187μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)552μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`358μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest450μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_k2" AND e.type = "component"504μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_virtuemart" AND e.type = "component"131μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_easyblog" AND e.type = "component"84μs1.13KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jomclassifieds" AND e.type = "component"78μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_hikashop" AND e.type = "component"79μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rseventspro" AND e.type = "component"105μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_zoo" AND e.type = "component"264μs536B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jticketing" AND e.type = "component"87μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_icagenda" AND e.type = "component"80μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eventbooking" AND e.type = "component"85μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eshop" AND e.type = "component"80μs1.76KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rsblog" AND e.type = "component"79μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_mijovideos" AND e.type = "component"95μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_opencart" AND e.type = "component"89μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jcart" AND e.type = "component"76μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_djclassifieds" AND e.type = "component"78μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"81μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_phocacart" AND e.type = "component"84μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jshopping" AND e.type = "component"77μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_igallery" AND e.type = "component"81μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_dpcalendar" AND e.type = "component"76μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`852μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'75μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1437μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'207μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1118μs536B/plugins/system/yooessentials/modules/platform-joomla/src/Database.php:52Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41)1.21ms9.94KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.08ms49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`898μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '834'766μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)1.04ms70.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`629μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)617μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`296μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC594μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `jos_content` AS `a` LEFT JOIN `jos_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC9.55ms41.72KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`298μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 119 AND `component_type` = "menu"1.14ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 834 AND `component_type` = "content"145μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1299μs592B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)532μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 12.25ms688.52KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC280μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)120μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1428μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?82μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?192μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy