Details

Keywords Change this

Observatory

Project timeline

1724 – 1724

Type

Education & Research

Location Change this

Sansad Marg, Connaught Place
110001 New Delhi
India

Architect Change this

Add this

Jantar Mantar Change this

New Delhi, India
Change this
1 of 5

Description Change this

The Jantra Mantra (literally the 'instrument and formula' and often called the Jantar Mantar), is located in the modern city of New Delhi, Delhi. It consists of 13 architectural astronomy instruments, built by Maharaja Jai Singh II of Jaipur, from 1724 onwards, and is one of five built by him, as he was given by Mughal emperor Muhammad Shah the task of revising the calendar and astronomical tables.

The primary purpose of the observatory was to compile astronomical tables, and to predict the times and movements of the sun, moon and planets. Some of these purposes nowadays would be classified as astronomy.

Instruments

There are four distinct instruments within the observatory of Jantar Mantar in New Delhi: the Samrat Yantra, the Ram Yantra, the Jayaprakash, and the Mishra yantras.

The Samrat Yantra, or Supreme Instrument, is a giant triangle that is basically an equal hour sundial. It is 70 feet high, 114 feet long at the base, and 10 feet thick. It has a 128-foot-long (39 m) hypotenuse that is parallel to the Earth's axis and points toward the North Pole. On either side of the triangle is a quadrant with graduations indicating hours, minutes, and seconds. At the time of the Samrat Yantra's construction, sundials already existed, but the Samrat Yantra turned the basic sundial into a precision tool for measuring declination and other related coordinates of various heavenly bodies.

Ram Yantra consists of two large buildings with open top. Both these two buildings form a complete device. The device is used to measure the altitude of stars which is equivalent to the latitude and the longitude on the earth.

The Jayaprakash consists of hollowed out hemispheres with markings on their concave surfaces. Crosswires were stretched between points on their rim. "Jai Prakash Yantra consists of two concave hemispherical structures used for ascertaining the position of the sun and other heavenly bodies. This instrument is an efficient dial, showing at any instant the local time, the sun's declination and the sign of the zodiac." written on the plaque on the site.

The Mishra yantras were able to indicate when it was noon in various cities all over the world and was the only structure in the observatory not invented by Jai Singh II.

In all, between 1727 and 1734, Jai Singh II, built five similar observatories, Yantra Mantras, in west central India, all known by the same name, thus includes ones at Jaipur -Yantra Mantra (Jaipur), Ujjain, Mathura and Varanasi. Today the observatory is mainly a tourist attraction, and is significant in the history of astronomy.

Influence

Jantar Mantar sculptural structures inspired contemporary art and architecture. In 2008 Tatiana Bilbao designed the Observatory House in collaboration with the artist Gabriel Orozco, who visited Jantar Mantar astronomical observatory in 1996.

Comments

Register to join to conversation.

(default) 55 queries took 275 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `associates`662
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
3SHOW FULL COLUMNS FROM `images`22222
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
5SHOW FULL COLUMNS FROM `sources`772
6SHOW FULL COLUMNS FROM `timelines`662
7SHOW FULL COLUMNS FROM `hp_features`442
8SHOW FULL COLUMNS FROM `architects_architectures`552
9SHOW FULL COLUMNS FROM `comments`16162
10SHOW FULL COLUMNS FROM `wall_posts`772
11SHOW FULL COLUMNS FROM `profile_visits`442
12SHOW FULL COLUMNS FROM `login_tokens`772
13SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
14SHOW FULL COLUMNS FROM `watched_objects`662
15SHOW FULL COLUMNS FROM `comments_users`662
16SHOW FULL COLUMNS FROM `tags`552
17SHOW FULL COLUMNS FROM `architectures_tags`662
18SHOW FULL COLUMNS FROM `architects_tags`662
19SHOW FULL COLUMNS FROM `versions`882
20SHOW FULL COLUMNS FROM `architecture_types`332
21SHOW FULL COLUMNS FROM `architecture_conditions`332
22SHOW FULL COLUMNS FROM `architecture_partners`662
23SHOW FULL COLUMNS FROM `partner_roles`222
24SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
25SHOW FULL COLUMNS FROM `likes`552
26SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification`, `Role`.`id`, `Role`.`name`, `Role`.`permissions`, `Role`.`description`, `Role`.`created`, `Role`.`modified` FROM `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `login` = 'guest@architectuul.com' LIMIT 11121
27SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
28SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
29UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-10-17 19:44:40', `modified` = '2019-10-17 19:44:40' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
30SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 1119
31SELECT `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date`, `ArchitectureType`.`id`, `ArchitectureType`.`title`, `ArchitectureCondition`.`title`, `Country`.`name` FROM `architectures` AS `Architecture` LEFT JOIN `architecture_types` AS `ArchitectureType` ON (`Architecture`.`architecture_type_id` = `ArchitectureType`.`id`) LEFT JOIN `architecture_conditions` AS `ArchitectureCondition` ON (`Architecture`.`architecture_condition_id` = `ArchitectureCondition`.`id`) LEFT JOIN `countries` AS `Country` ON (`Architecture`.`country_id` = `Country`.`id`) WHERE `Architecture`.`slug` = 'jantar-mantar' AND `Architecture`.`deleted` = 0 LIMIT 1115
32SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-3c20-413c-a191-0acfb372233b' 112
33SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '49369489-1e74-43e9-b926-47361030b5da' 112
34SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('4ebd0b24-5cec-4a9d-ad92-03126d7b5f76') 224
35SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('4ebd0b24-5cec-4a9d-ad92-03126d7b5f76') 002
36SELECT `Tag`.`slug`, `Tag`.`name`, `ArchitecturesTag`.`id`, `ArchitecturesTag`.`architecture_id`, `ArchitecturesTag`.`tag_id`, `ArchitecturesTag`.`old_id`, `ArchitecturesTag`.`old_building_id`, `ArchitecturesTag`.`old_tag_id` FROM `tags` AS `Tag` JOIN `architectures_tags` AS `ArchitecturesTag` ON (`ArchitecturesTag`.`architecture_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 115
37SELECT `Architect`.`title`, `Architect`.`slug`, `ArchitectsArchitecture`.`id`, `ArchitectsArchitecture`.`architect_id`, `ArchitectsArchitecture`.`architecture_id`, `ArchitectsArchitecture`.`_order`, `ArchitectsArchitecture`.`created` FROM `architects` AS `Architect` JOIN `architects_architectures` AS `ArchitectsArchitecture` ON (`ArchitectsArchitecture`.`architecture_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 004
38SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created`, `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `images` AS `Image` LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE `foreign_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 5528
39SELECT `Version`.`id`, `Version`.`version_id`, `Version`.`user_id`, `Version`.`model`, `Version`.`foreign_id`, `Version`.`result`, `Version`.`comment`, `Version`.`created` FROM `versions` AS `Version` WHERE `Version`.`foreign_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' ORDER BY `Version`.`version_id` desc LIMIT 1002
40SELECT `Version`.`id`, `Version`.`version_id`, `Version`.`user_id`, `Version`.`model`, `Version`.`foreign_id`, `Version`.`result`, `Version`.`comment`, `Version`.`created`, `User`.`username`, `User`.`slug` FROM `versions` AS `Version` LEFT JOIN `users` AS `User` ON (`Version`.`user_id` = `User`.`id`) WHERE `Version`.`foreign_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' AND `Version`.`version_id` IS NULL LIMIT 1002
41SELECT `Article`.`id`, `Article`.`aiid`, `Article`.`foreign_id`, `Article`.`model`, `Article`.`title`, `Article`.`clean_title`, `Article`.`also_known_as`, `Article`.`clean_also_known_as`, `Article`.`architects`, `Article`.`clean_architects`, `Article`.`description`, `Article`.`tags`, `Article`.`location`, `Article`.`is_featured`, `Article`.`views`, `Article`.`views_last_day`, `Article`.`views_last_week`, `Article`.`views_last_month`, `Article`.`last_viewed`, `Article`.`created`, `Article`.`modified`, `Article`.`deleted`, `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `articles` AS `Article` LEFT JOIN `architectures` AS `Architecture` ON (`Article`.`foreign_id` = `Architecture`.`id`) WHERE `Article`.`foreign_id` <> '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'Observatory') OR (`Article`.`tags` LIKE '%, Observatory') OR (`Article`.`tags` LIKE '%, Observatory, %') OR (`Article`.`tags` LIKE 'Observatory, %')) ORDER BY Rand() ASC LIMIT 22228
42SELECT `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4b46391b-2d98-4296-b40a-0a6bb372233b' 112
43SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('4b46391b-2d98-4296-b40a-0a6bb372233b') ORDER BY `_order` asc, `created` asc 5525
44SELECT `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4ebcfc6a-3000-4584-a07a-02dd6d7b5f76' 112
45SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('4ebcfc6a-3000-4584-a07a-02dd6d7b5f76') ORDER BY `_order` asc, `created` asc 121226
46SELECT DISTINCT CommentsUser.comment_id, CommentsUser.parent_id, Comment.body, Comment.last_message_id, `Comment`.`id` FROM `comments_users` AS `CommentsUser` LEFT JOIN `comments` AS `Comment` ON (`CommentsUser`.`comment_id` = `Comment`.`id`) WHERE `CommentsUser`.`foreign_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' ORDER BY `Comment`.`id` desc 002
47SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' 112
48SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' 112
49UPDATE `architectures` SET `id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76', `views` = 7555, `views_last_day` = 131, `views_last_week` = 209, `views_last_month` = 284, `last_viewed` = '2019-10-17 19:44:40', `modified` = '2015-04-30 14:20:47' WHERE `architectures`.`id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76'13
50SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76' AND `Architecture`.`deleted` <> 1 LIMIT 1112
51SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' AND `Architecture`.`deleted` <> 1 115
52UPDATE `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) LEFT JOIN `countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`User`.`state_id` = `State`.`id`) SET `User`.`architecture_count` = 169 WHERE `User`.`id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76'02
53UPDATE `articles` AS `Article` LEFT JOIN `architects` AS `Architect` ON (`Article`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Article`.`foreign_id` = `Architecture`.`id`) SET `Article`.`views` = "7555", `Article`.`views_last_day` = "131", `Article`.`views_last_week` = "209", `Article`.`views_last_month` = "284", `Article`.`last_viewed` = "2019-10-17 19:44:40" WHERE `foreign_id` = '4ebd0b24-5cec-4a9d-ad92-03126d7b5f76'125
54SELECT `Architect`.`slug` FROM `architects` AS `Architect` WHERE `title` = 'Tatiana Bilbao' AND `Architect`.`deleted` <> 1 LIMIT 1113
55SELECT `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `title` = 'Observatory House' AND `Architecture`.`deleted` <> 1 LIMIT 1113