Skip to main content

Written by Carol Godette  |  Photos provided (Unless Noted)

The triangle-shaped parcel of land at the five-point intersection of South Broadway, Circular Street, and Ballston Avenue has had many reincarnations, each defining and mirroring an era in Saratoga's rich history. 

Saratoga had been inhabited by the Algonkian people known as the Mohicans for over 10,000 years. The Iroquoian-speaking Mohawks arrived around 1500 years ago, and the Algonkian-speaking Abenaki arrived about 1600. But we have no record of their early activity on this triangle before their forced removal. 

John Bevan's c1850 map labels the area of 209 South Broadway, which was at that time part of the vast urban estate of Dr. John Clarke, "Indian Camp." Margaret Bruchac's educational guide for the 2019 Saratoga Native American Festival elaborates on the term in this excerpt:

Saratoga Springs and Ballston Spa became popular destination resorts for American and European tourists who came to stay at the grand hotels, drink the spring waters, and promenade around the towns and parks. With encouragement from residents, "Indian Camps" were set up in town parks, and Native artisans - mostly Mohawk, Mohican, Oneida, and Abenaki - began regular jaunts to these locales every spring to publicly market their wares through the summer and fall.

Native American researcher Gerry Biron's blog identifies an 1848 encampment "located where Broadway and Ballston Avenue meet." 

Historical accounts of the smell of ash splint baskets filling the air; the sight of colorful beaded souvenirs, bows, and leather moccasins displayed in the wooden booths; and the sounds of rifle range competitions leave me longing for time travel!  

The parcel appears to have been vacant decades after the encampment moved to Congress Park.

This late 1800s lithograph illustrates the Indian Encampments that were popular tourist attractions.

Bevan’s c. 1850 map illustrates the five point intersection of 209 South Broadway.
Note the label of “Indian Camp.”

Waiting for Rebirth

At the turn of the century, Saratoga was the go-to destination for wealthy tourists. "The Broadway/Ballston Avenue corner was a particularly desirable residential location." Area businessman Julius Jackson capitalized on this trend by hiring architect R. Newton Brezee, known for his Queen Anne-style homes, to construct a three-story cottage on the site. As a result, the Jackson family could enjoy a panoramic view of tourists motoring by, either on their way to Saratoga Lake, the county seat in Ballston Spa, the world-famous racetrack or the grand hotels of Broadway from the home's wrap-around porch. The heralded red-shingled, green-roofed cottage with stables was the "show place" of its surrounding residential neighborhood in 1902. The iconic home was featured in the 1905 Souvenir edition of The Saratogian.

After the 1915 opening of the Lincoln Baths, the neighborhood's character changed. Hotels and boarding houses replaced elegant cottages. Mr. Jackson died in 1919. When his widow tried to sell the property in 1935, she was only offered $15,000 for a $26,000 assessed house. Her most viable option came from Sinclair Oil Company, which was interested in leasing the property. However, their offer required rezoning the parcel of land. Heated arguments from neighbors ensued. Jackson's attorney argued, "The property ceased to be of value as a residence after the erection of a boarding house with projecting 'sleepers' on the property adjoining Mrs. Jackson's residence."

Nearby St. Peter's Church and hotel owners banded together to protest the rezoning. Dense traffic, property devaluation, and development were their primary concerns. Finally, in 1935, after much debate, the City rezoned 209 Broadway. Sadly Brezee's iconic home was razed, setting the stage for commercial development in the surrounding neighborhood.

Another rebirth

In the mid-30s, few people had cars, so filling stations were not profitable. However, oil companies felt they paid for themselves due to their "advertising value." So, regardless of profitability, in 1936, the South Broadway corner became a Sinclair Filling Station. Over the next fifty years, many owners and gas companies operated out of the service station… Bigsbee's, Perry's, Gentile's, Sousa's, and Crown Oil. Finally, with the advent of several nearby gas stations, Crown Oil decided to close the station in 1999. The gas station was razed, tanks removed, and successful remediation of the pollutants under DEC supervision was completed. 

R. Newton Brezee was architect for 50 beloved buildings in Saratoga Springs. He built this for Julius Jackson in 1902. It is one of his two structures that were demolished.
The Sinclair Filling Station took over 209 South Broadway in 1936. Photo courtesy of the George S. Bolster Collection, Saratoga History Museum

Waiting for a new life

In 2012, Sustainable Saratoga's Urban Forestry Project was working on a tree inventory to donate to the City. It hosted a public brainstorming session on greening our city landscape with large trees. They asked Saratogians to identify locations where large-growing shade trees would have the most significant beautifying impact. What was the winner? The barren former gas station parcel at 209 South Broadway. At the time, Tom Denny, chair of Sustainable Saratoga's tree effort, recalled that "people asked why one of our prominent intersections needed to look so bad." But little could be done as the parcel was privately owned.

In 2016, Mayor Joanne Yepsen persuaded the landowner, David Eshaghian of Crown Oil, to give this property to the City. The Mayor brought Eshaghian's generous offer to the City Council but could not get a majority vote to accept the donation. It remained vacant. 

As Saratoga continues to develop rapidly in the 21st century, particularly after the isolation experienced during the pandemic, residents increasingly value the small green spaces scattered through the urban core. During the pandemic isolation, Tom Denny began to think 209's desired transformation could be achieved through private efforts.  

In late summer 2021, Yepsen and Denny contacted landowner Eshaghian. He agreed to donate the land to a non-profit if the Saratogians could form one. SoBro Conservancy of Saratoga was incorporated in the fall of 2021, was approved by the IRS as a 501(c)(3) tax-exempt charity in the Spring of 2022 and took ownership of 209 South Broadway at closing on July 14, 2021. 

Shanti Nagle’s of Design Wild’s plans for SoBro garden.
SoBro Conservancy was one of Ben & Jerry’s nonprofit partners on Free Cone Day. The organization received half of the day’s tips and enjoyed the opportunity to share with others their vision of a pollinator green space.

The vision is to transform this barren, compacted land into a vibrant green habitat for pollinators and songbirds while beautifying one of Saratoga's most critical commercial gateways. "The green space will create both beauty and native habitat," says Tom. "The habitat will benefit the area's bees, butterflies, and birds, which benefit humans, while beauty and educational efforts will benefit neighboring businesses and schools. Gardens were once only planted for beauty. In the 21st century, we ask them to contribute to the food web, to help stave off the extinction of insects on which the world depends, and to educate about these issues."

The SoBro Conservancy board and their passionate team of experienced pollinator gardeners are excited to meet the challenges of remediating this degraded site. They are confident that more and more people will join the project to bring success. Already the project has attracted collaborations with our local Department of Public Works, students from Skidmore and the high school, staff of local non-profits and the State Park, members of the City Council, and a broad range of talented volunteers.  

This spot should have a long life in its newest form. Fortunately, the generous donation requires that this parcel remain a green space for 99 years. Therefore, the latest incarnation of 209 South Broadway will ensure this spot will thrive for many years!

Follow SoBro Conservancy's efforts on their website: sobroconservancy.org

Many thanks to Mitch Cohen for his research contributions.

8.015MBMemory Usage145msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.21
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.42
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "8" "id" => "527" "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" => 1748854671 "last" => 1748854671...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.49ms)
  • afterInitialise (1.96MB) (32.01ms)
  • afterRoute (375.45KB) (7.1ms)
  • beforeRenderComponent com_content (49.12KB) (1.14ms)
  • Before Access::preloadComponents (all components) (43.72KB) (1.88ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.45ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (18μs)
  • After Access::preloadPermissions (com_content) (514.33KB) (1.26ms)
  • Before Access::getAssetRules (id:692 name:com_content.article.527) (18.65KB) (29μs)
  • After Access::getAssetRules (id:692 name:com_content.article.527) (11.38KB) (113μs)
  • afterRenderComponent com_content (1.67MB) (55.36ms)
  • afterDispatch (29.42KB) (1.51ms)
  • beforeRenderRawModule mod_finder () (370.82KB) (14.11ms)
  • afterRenderRawModule mod_finder () (1.95MB) (9.5ms)
  • beforeRenderModule mod_finder () (704B) (12μs)
  • afterRenderModule mod_finder () (1.44KB) (330μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (423μs)
  • afterRenderRawModule mod_menu () (12.58KB) (1.15ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.63KB) (180μs)
  • beforeRenderRawModule mod_custom () (920B) (124μs)
  • afterRenderRawModule mod_custom () (320.03KB) (2.29ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (3.15KB) (82μs)
  • beforeRenderRawModule mod_menu () (24B) (147μs)
  • afterRenderRawModule mod_menu () (552B) (509μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (92μs)
  • beforeRenderRawModule mod_custom () (920B) (98μs)
  • afterRenderRawModule mod_custom () (1.03KB) (267μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (1.23KB) (75μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (114μs)
  • afterRenderRawModule mod_menu () (4.45KB) (522μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (1.34KB) (87μs)
  • beforeRenderRawModule mod_finder () (96B) (10μs)
  • afterRenderRawModule mod_finder () (7.24KB) (1.13ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.34KB) (111μs)
  • beforeRenderRawModule mod_custom () (288B) (12μs)
  • afterRenderRawModule mod_custom () (912B) (256μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (1.23KB) (66μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (219μs)
  • afterRenderRawModule mod_custom () (1008B) (197μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.77KB) (52μs)
  • beforeRenderRawModule mod_custom () (472B) (70μs)
  • afterRenderRawModule mod_custom () (1008B) (156μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (44μs)
  • afterRender (306.95KB) (5.28ms)
  • 1 x afterRenderComponent com_content (1.67MB) (38.3%)
    55.36ms
    1 x afterInitialise (1.96MB) (22.15%)
    32.01ms
    1 x beforeRenderRawModule mod_finder () (370.82KB) (9.76%)
    14.11ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (6.57%)
    9.50ms
    1 x afterRoute (375.45KB) (4.91%)
    7.10ms
    1 x afterRender (306.95KB) (3.65%)
    5.28ms
    1 x afterLoad (444.73KB) (2.41%)
    3.49ms
    1 x afterRenderRawModule mod_custom () (320.03KB) (1.58%)
    2.29ms
    1 x Before Access::preloadComponents (all components) (43.72KB) (1.3%)
    1.88ms
    1 x afterDispatch (29.42KB) (1.05%)
    1.51ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.01%)
    1.45ms
    1 x After Access::preloadPermissions (com_content) (514.33KB) (0.87%)
    1.26ms
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.8%)
    1.15ms
    1 x beforeRenderComponent com_content (49.12KB) (0.79%)
    1.14ms
    1 x afterRenderRawModule mod_finder () (7.24KB) (0.78%)
    1.13ms
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.36%)
    522μs
    1 x afterRenderRawModule mod_menu () (552B) (0.35%)
    509μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.29%)
    423μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.24%)
    353μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.23%)
    330μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.18%)
    267μs
    1 x afterRenderRawModule mod_custom () (912B) (0.18%)
    256μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.15%)
    222μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.15%)
    219μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.12%)
    180μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.1%)
    147μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.1%)
    141μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.08%)
    114μs
    1 x After Access::getAssetRules (id:692 name:com_content.article.527) (11.38KB) (0.08%)
    113μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.08%)
    111μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.06%)
    92μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    87μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.06%)
    82μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    70μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    52μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    44μs
    1 x Before Access::getAssetRules (id:692 name:com_content.article.527) (18.65KB) (0.02%)
    29μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    20μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    18μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    17μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    13μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    10μs
53 statements were executed, 5 of which were duplicates, 48 unique13.35ms876.02KB
  • SELECT @@SESSION.sql_mode;128μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?180μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 191μ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)212μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`131μ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` = :guest213μ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"211μ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"78μ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"62μ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"59μ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"58μ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"54μ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"128μ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"67μ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"58μ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"73μ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"56μ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"56μ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"57μ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"61μ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"54μ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"68μ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"56μ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"62μ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"59μ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"55μ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"55μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`687μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'89μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1202μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'167μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1134μ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)530μs9.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` = 0558μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.01ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '527'320μ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)410μs70.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`313μ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)249μ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`251μ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 ASC368μ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 DESC1.38ms3.47KBParams/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`308μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 119 AND `component_type` = "menu"542μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 527 AND `component_type` = "content"277μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1332μ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)306μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1719μs688.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 ASC682μ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)300μ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` = 1260μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?164μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?350μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy