Details

Keywords Change this

Housing, Collective Housing, Colour, Cooperatives

Project timeline

1998 – 2008

Type

Residential

Location Change this

Senegal
1601 Tyre
Lebanon

Architect Change this

Team

Design Team: Hashim Sarkis, Anuraj Shah And Erkin Ozay (Project Coordinators), Ziad Jamaleddine, Paul Kaloustian, Brian Mulder, David Hill, Mete Sonmez, Ryan Bollom, Ezra Block, Cynthia Gunadi, Scott Hagen, Cheyne Owens

Client Change this

Al Baqaa Housing Cooperative And The Association For The Development Of Rural Areas In Southern Lebanon

Partners Change this

Structural engineers
Mohamed Chahine And Mounir Mabsout

Electrical engineers
Aurora

Project management
Mohamed Chahine

Housing for the Fishermen of Tyre Change this

Tyre, Lebanon
by Hashim Sarkis Change this
1 of 15

Description Change this

The fishermen’s community of Tyre, a city of 25,000 residents on the southern coast of Lebanon, has been suffering from a housing shortage and overcrowding. Fishermen of Tyre belong to one of the most marginalizedsocio-economic groups in the country. Their families have no access to health and social insurance programs or retirement support schemes. An obsolete technology coupled with military and security considerations limit the possibility of fishing far beyond the seashore and thus result in serious overfishing. A continuous drop in the catch has yielded a systematic decline in the average income of many fishermen (15 USD per day decreasing to less than 7 USD during the winter season and bad weather). The fishermen’s families in Tyre were did not to benefit from the construction boom that the region witnessed during the last three decades, due to their lack of financial resources or urban regulation and constraints in the old city quarters. Their small, old and damp houses have become overcrowded. Public health experts testify to the high levels of asthmatic and rheumatic problems amongst the members of this community. In 1998, fishermen families from the city of Tyre organized themselves into the cooperative Al Baqaa. Through their partnership with the Association for Rural Development in south Lebanon (ADR) they were able to join efforts with the Greek Catholic Archdiocese of Tyre, the Spanish Agency for International Cooperation, as well as generous Lebanese locals and expatriates to support a social housing project.

Housing

The project aims to provide housing to 80 families of young fishermen and at the same time to provide public spaces that serve as a platform for developing other productive, social as well as educational activities. Construction funding came from various local and international organizations. The new site measured 0.7 hectare agricultural field outside Tyre, surrounded by tobacco fields, citrus orchards, a hospital, and chaotic development that mushroomed illegally during the war. A new master plan for Tyre allowed development in this area and replaced the agricultural road with a main road between Tyre and its hinterland. Most of the surrounding agricultural property was already being subdivided for speculative construction.

Trees

The form is made of an extended building (7.6 meters deep) that wraps on itself creating an internal road and a courtyard.The internal road prolongs the side street, provides access to the units and connects the two main access points. The complex preserves the scale of the agricultural field as a collective open space. The open space provides a common public garden and a playground. The courtyard is made up of two parts: a paved area with a collective water tank underneath and a planted area. This difference in treatment creates a difference in temperature, thereby increasing air movement during the hot summer days and enhancing cross-ventilation in the units. Instead of framing the parts with trees, trees are used to mark the entrances to the paths between buildings. The landscape filters through these gaps between the buildings to the exterior, and thereby the connection between the interior open space and the street is emphasized. The trees are linked to the agricultural landscape: olives, a local variety of the ficus, poplars, palms and oranges are used. The oranges are reminiscent of the orange groves in the area and the poplars of the tree edges that defined waterways and created windbreaks. Each main floor unit has as mall garden that can be used for planting. The roof can also be used for planting, in particular the trellises, which can be used for grapevines – a very typical feature of the region’s houses.

Cars

Car ownership is low among the co-op members. One parking space for every two units is sufficient. A common van is used to commute to the port. Most cars park on a piece of land separated from the main parcel by the new master plan. The parking will eventually be moved underground with a community auditorium built on the corner to complement the open space and street intersection.In order to avoid a closed, urban-block effect, the linear mass is broken down into a series of buildings separated by gaps that are used for public circulation. These spaces provide variety within the building volume.

Corners

The corners are treated differently in response to various external conditions. For example, a small public space is created at the intersection of the main road and the secondary road, where a waiting area and a bus stop is located and a small thicket of ficus trees to shade the waiting area. Another small area along the main road between the building blocks provides space for an outdoor café and a passage to the interior. A series of small passages lead from the outside perimeter to the interior courtyard at the main corners, heightening the porosity of the project.The fishermen insisted on maintaining equality among the units. To meet this requirement, particularly in terms of outdoor space and views, the units had to be different, depending on their location in plan.

Context

Given the chaotic and unpredictable conditions of the new context and its isolation from the residential quarters of Tyre, the design defines a strong edge to the outside along the site perimeter. However, it introduces an organizational frame for the surrounding streets and new parcels. This edge is made of an extenuated building (7 meters thick) that wraps in on itself creating an internal road and an open space. The internal road continues the side street, provides access to the units, and connects the two main access points. The open space provides a common public garden and a playground. In order to avoid a closed, urban-block effect, the linear mass is broken down into a series of buildings separated by gaps that are used for public circulation. These spaces provide variety within the building volume.

Units

The project consists of 80 two-bedroom units each about 86 square meters of interior space and about half the area in private outdoor open space. The units are arranged in three types of blocks or groupings. The first type consists of simple one-story flats (simplexes) arranged around a common scissor stair. The second type of block consists of 4 duplexes, each duplex consisting of an open floor plan for living spaces and a second floor for bedrooms. This type is located around the main open space. All living floors have cross views and cross ventilation and are extended to the outside by private outdoors spaces (gardens and porches for the lower units and balconies and roof decks for the upper units). The third type is a combination of duplexes and simplexes and is located at the corners of the main open space. One of the main features of this project is the large open space. The space of the building mass in relation to the open space allows for an increasing enclosure and then release. The open space is made of two parts, a paved area with a collective water tank underneath and a planted area. Instead of framing the parts with trees, trees are used to mark entrances to paths between buildings. The landscape spills through these gaps between the buildings to the exterior to emphasize the connection between the interior open space and the street.

Sources

Comments

Register to join to conversation.

(default) 54 queries took 349 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `images`22223
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SHOW FULL COLUMNS FROM `sources`772
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';112
5SHOW FULL COLUMNS FROM `timelines`662
6SHOW FULL COLUMNS FROM `hp_features`442
7SHOW FULL COLUMNS FROM `architects_architectures`552
8SHOW FULL COLUMNS FROM `comments`16162
9SHOW FULL COLUMNS FROM `wall_posts`773
10SHOW FULL COLUMNS FROM `profile_visits`443
11SHOW FULL COLUMNS FROM `login_tokens`772
12SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
13SHOW FULL COLUMNS FROM `watched_objects`662
14SHOW FULL COLUMNS FROM `comments_users`662
15SHOW FULL COLUMNS FROM `tags`552
16SHOW FULL COLUMNS FROM `architectures_tags`662
17SHOW FULL COLUMNS FROM `architects_tags`662
18SHOW FULL COLUMNS FROM `versions`882
19SHOW FULL COLUMNS FROM `architecture_types`332
20SHOW FULL COLUMNS FROM `architecture_conditions`332
21SHOW FULL COLUMNS FROM `architecture_partners`662
22SHOW FULL COLUMNS FROM `partner_roles`222
23SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
24SELECT `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 11128
25SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
26SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
27UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-08-18 03:47:15', `modified` = '2019-08-18 03:47:15' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
28SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11116
29SELECT `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` = 'housing-for-the-fishermen-of-tyre' AND `Architecture`.`deleted` = 0 LIMIT 11116
30SELECT `ArchitectureType`.`id`, `ArchitectureType`.`title` FROM `architecture_types` AS `ArchitectureType` WHERE `ArchitectureType`.`id` = '4b463ec8-c1c8-4e46-b88e-0acfb372233b' 112
31SELECT `Country`.`name` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948a-d58c-4148-85ef-45a21030b5da' 112
32SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('5c1b200a-400c-4a27-863c-7c306d7b5e1b') 225
33SELECT `ArchitecturePartner`.`id`, `ArchitecturePartner`.`architecture_id`, `ArchitecturePartner`.`name`, `ArchitecturePartner`.`website`, `ArchitecturePartner`.`partner_role_id`, `ArchitecturePartner`.`created` FROM `architecture_partners` AS `ArchitecturePartner` WHERE `ArchitecturePartner`.`architecture_id` = ('5c1b200a-400c-4a27-863c-7c306d7b5e1b') 333
34SELECT `PartnerRole`.`id`, `PartnerRole`.`title` FROM `partner_roles` AS `PartnerRole` WHERE `PartnerRole`.`id` = '4bf23ac3-6768-49e6-b13e-87d7183d6281' 112
35SELECT `PartnerRole`.`id`, `PartnerRole`.`title` FROM `partner_roles` AS `PartnerRole` WHERE `PartnerRole`.`id` = '4c6424ce-8122-3bc1-b725-f865183d6281' 112
36SELECT `PartnerRole`.`id`, `PartnerRole`.`title` FROM `partner_roles` AS `PartnerRole` WHERE `PartnerRole`.`id` = '4bf23ac3-2268-4102-ad20-87d7183d6281' 112
37SELECT `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` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' AND `ArchitecturesTag`.`tag_id` = `Tag`.`id`) 445
38SELECT `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` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' AND `ArchitectsArchitecture`.`architect_id` = `Architect`.`id`) 114
39SELECT `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` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 151530
40SELECT `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` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1002
41SELECT `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` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' AND `Version`.`version_id` IS NULL LIMIT 1002
42SELECT `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` <> '5c1b200a-400c-4a27-863c-7c306d7b5e1b' AND `Article`.`deleted` = 0 AND `Architecture`.`description` <> '' AND `Architecture`.`tags` <> '' AND `Architecture`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'collective housing') OR (`Article`.`tags` LIKE '%, collective housing') OR (`Article`.`tags` LIKE '%, collective housing, %') OR (`Article`.`tags` LIKE 'collective housing, %') OR (`Article`.`tags` LIKE 'colour') OR (`Article`.`tags` LIKE '%, colour') OR (`Article`.`tags` LIKE '%, colour, %') OR (`Article`.`tags` LIKE 'colour, %') OR (`Article`.`tags` LIKE 'Housing') OR (`Article`.`tags` LIKE '%, Housing') OR (`Article`.`tags` LIKE '%, Housing, %') OR (`Article`.`tags` LIKE 'Housing, %') OR (`Article`.`tags` LIKE 'cooperatives') OR (`Article`.`tags` LIKE '%, cooperatives') OR (`Article`.`tags` LIKE '%, cooperatives, %') OR (`Article`.`tags` LIKE 'cooperatives, %')) ORDER BY Rand() ASC LIMIT 22248
43SELECT `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` = '5a375089-a7e0-4b9c-a4df-45706d7b5e1b' 112
44SELECT `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` = ('5a375089-a7e0-4b9c-a4df-45706d7b5e1b') ORDER BY `_order` asc, `created` asc 4438
45SELECT `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` = '5a12cdf4-20cc-4ed1-a39d-2f2f6d7b5e1b' 112
46SELECT `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` = ('5a12cdf4-20cc-4ed1-a39d-2f2f6d7b5e1b') ORDER BY `_order` asc, `created` asc 6628
47SELECT 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` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' ORDER BY `Comment`.`id` desc 002
48SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' 112
49SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' 112
50UPDATE `architectures` SET `id` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b', `views` = 241, `views_last_day` = 29, `views_last_week` = 35, `views_last_month` = 50, `last_viewed` = '2019-08-18 03:47:15', `modified` = '2018-12-20 05:38:22' WHERE `architectures`.`id` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b'13
51SELECT `Architecture`.`user_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b' AND `Architecture`.`deleted` <> 1 LIMIT 1112
52SELECT COUNT(*) AS `count` FROM `architectures` AS `Architecture` WHERE `Architecture`.`user_id` = '52ff7855-3800-424e-affd-679b6d7b5e1b' AND `Architecture`.`deleted` <> 1 118
53UPDATE `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` = 947 WHERE `User`.`id` = '52ff7855-3800-424e-affd-679b6d7b5e1b'02
54UPDATE `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` = "241", `Article`.`views_last_day` = "29", `Article`.`views_last_week` = "35", `Article`.`views_last_month` = "50", `Article`.`last_viewed` = "2019-08-18 03:47:15" WHERE `foreign_id` = '5c1b200a-400c-4a27-863c-7c306d7b5e1b'133