Details

Keywords Change this

Steel Frame Solutions, Rainwater Tanks Australia, Steel Frame Homes, Dave Cann, Modular Water Tanks, Modular Wall Systems, Modular Homes, Structural Steel, Steel Cladding, Steel Frame, Modular Framing Systems, Modular Rainwater Tanks, Steel Framing Systems, Modular Walls, Steel Framing

Birth date / place

June 22nd 1971, Perth, Australia

Selected Architecture

Add this

Practice / Active in Change this

Superwall Systems
8/ 11 Milson Place, O'Connor Western Australia
6163 O'Connor, Australia

www.superwall.com.au

Dave Cann Change this

Change thisO'Connor, Australia
born 1971, Perth
1 of 1

About Change this

Dave is a western Australian architect specialized in a wide range of structural steel framing systems and has built a significant record in engineering & architectural design services. With its Superwall and Hydrowall systems design, Dave has quickly gained a reputation for economical and high-quality modular steel framing and rainwater tank systems in Australia.

Partnered Sites:

Redstorm Scientific

Sources

Comments

Register to join to conversation.

(default) 65 queries took 415 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `architects`54543
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';112
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';113
4SHOW FULL COLUMNS FROM `users`38383
5SHOW FULL COLUMNS FROM `roles`663
6SHOW FULL COLUMNS FROM `countries`332
7SHOW FULL COLUMNS FROM `states`332
8SHOW FULL COLUMNS FROM `auth_keys`772
9SHOW FULL COLUMNS FROM `auth_key_types`222
10SHOW FULL COLUMNS FROM `feeds`662
11SHOW FULL COLUMNS FROM `top_list_items`772
12SHOW FULL COLUMNS FROM `top_lists`553
13SHOW FULL COLUMNS FROM `architectures`63633
14SHOW FULL COLUMNS FROM `architecture_types`332
15SHOW FULL COLUMNS FROM `architecture_conditions`332
16SHOW FULL COLUMNS FROM `articles`22222
17SHOW FULL COLUMNS FROM `object_views`552
18SHOW FULL COLUMNS FROM `images`22223
19SHOW FULL COLUMNS FROM `sources`772
20SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';113
21SHOW FULL COLUMNS FROM `hp_features`442
22SHOW FULL COLUMNS FROM `architects_architectures`552
23SHOW FULL COLUMNS FROM `architecture_partners`662
24SHOW FULL COLUMNS FROM `partner_roles`222
25SHOW FULL COLUMNS FROM `comments`16162
26SHOW FULL COLUMNS FROM `wall_posts`772
27SHOW FULL COLUMNS FROM `profile_visits`442
28SHOW FULL COLUMNS FROM `login_tokens`772
29SHOW FULL COLUMNS FROM `watched_objects`662
30SHOW FULL COLUMNS FROM `comments_users`662
31SHOW FULL COLUMNS FROM `tags`553
32SHOW FULL COLUMNS FROM `architectures_tags`662
33SHOW FULL COLUMNS FROM `architects_tags`662
34SHOW FULL COLUMNS FROM `versions`882
35SHOW FULL COLUMNS FROM `associates`662
36SHOW FULL COLUMNS FROM `timelines`662
37SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
38SHOW FULL COLUMNS FROM `likes`553
39SELECT `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 11136
40SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
41SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
42UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-09-23 10:11:14', `modified` = '2019-09-23 10:11:14' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'14
43SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11115
44SELECT `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date`, `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `architects` AS `Architect` LEFT JOIN `countries` AS `PracticeCountry` ON (`Architect`.`practice_country_id` = `PracticeCountry`.`id`) WHERE `Architect`.`deleted` = 0 AND `Architect`.`slug` = 'dave-cann' LIMIT 11110
45SELECT `PracticeCountry`.`id`, `PracticeCountry`.`name`, `PracticeCountry`.`user_count` FROM `countries` AS `PracticeCountry` WHERE `PracticeCountry`.`id` = '4936948a-6424-4013-979f-41681030b5da' 112
46SELECT `Source`.`title`, `Source`.`link`, `Source`.`foreign_id` FROM `sources` AS `Source` WHERE `Source`.`foreign_id` = ('569c987d-9570-4272-be7f-454b6d7b5e1b') 555
47SELECT `Timeline`.`date`, `Timeline`.`description`, `Timeline`.`architect_id` FROM `timelines` AS `Timeline` WHERE `Timeline`.`architect_id` = ('569c987d-9570-4272-be7f-454b6d7b5e1b') ORDER BY `Timeline`.`date` asc 003
48SELECT `Associate`.`user_id`, `Associate`.`type`, `Associate`.`architect_id` FROM `associates` AS `Associate` WHERE `Associate`.`architect_id` = ('569c987d-9570-4272-be7f-454b6d7b5e1b') 0010
49SELECT `Tag`.`slug`, `Tag`.`name`, `ArchitectsTag`.`id`, `ArchitectsTag`.`architect_id`, `ArchitectsTag`.`tag_id`, `ArchitectsTag`.`old_id`, `ArchitectsTag`.`old_architect_id`, `ArchitectsTag`.`old_tag_id` FROM `tags` AS `Tag` JOIN `architects_tags` AS `ArchitectsTag` ON (`ArchitectsTag`.`architect_id` = '569c987d-9570-4272-be7f-454b6d7b5e1b' AND `ArchitectsTag`.`tag_id` = `Tag`.`id`) 15154
50SELECT `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` = '569c987d-9570-4272-be7f-454b6d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc 1136
51SELECT `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` = '569c987d-9570-4272-be7f-454b6d7b5e1b' ORDER BY `Version`.`version_id` desc LIMIT 1002
52SELECT `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` = '569c987d-9570-4272-be7f-454b6d7b5e1b' AND `Version`.`version_id` IS NULL LIMIT 1002
53SELECT `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`, `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date` FROM `articles` AS `Article` LEFT JOIN `architects` AS `Architect` ON (`Article`.`foreign_id` = `Architect`.`id`) WHERE `Article`.`foreign_id` <> '569c987d-9570-4272-be7f-454b6d7b5e1b' AND `Article`.`deleted` = 0 AND `Architect`.`biography` <> '' AND `Architect`.`tags` <> '' AND `Architect`.`image_count` > 0 AND ((`Article`.`tags` LIKE 'dave cann') OR (`Article`.`tags` LIKE '%, dave cann') OR (`Article`.`tags` LIKE '%, dave cann, %') OR (`Article`.`tags` LIKE 'dave cann, %') OR (`Article`.`tags` LIKE 'steel framing systems') OR (`Article`.`tags` LIKE '%, steel framing systems') OR (`Article`.`tags` LIKE '%, steel framing systems, %') OR (`Article`.`tags` LIKE 'steel framing systems, %') OR (`Article`.`tags` LIKE 'modular wall systems') OR (`Article`.`tags` LIKE '%, modular wall systems') OR (`Article`.`tags` LIKE '%, modular wall systems, %') OR (`Article`.`tags` LIKE 'modular wall systems, %') OR (`Article`.`tags` LIKE 'modular framing systems') OR (`Article`.`tags` LIKE '%, modular framing systems') OR (`Article`.`tags` LIKE '%, modular framing systems, %') OR (`Article`.`tags` LIKE 'modular framing systems, %') OR (`Article`.`tags` LIKE 'steel frame homes') OR (`Article`.`tags` LIKE '%, steel frame homes') OR (`Article`.`tags` LIKE '%, steel frame homes, %') OR (`Article`.`tags` LIKE 'steel frame homes, %') OR (`Article`.`tags` LIKE 'steel framing') OR (`Article`.`tags` LIKE '%, steel framing') OR (`Article`.`tags` LIKE '%, steel framing, %') OR (`Article`.`tags` LIKE 'steel framing, %') OR (`Article`.`tags` LIKE 'steel frame') OR (`Article`.`tags` LIKE '%, steel frame') OR (`Article`.`tags` LIKE '%, steel frame, %') OR (`Article`.`tags` LIKE 'steel frame, %') OR (`Article`.`tags` LIKE 'modular walls') OR (`Article`.`tags` LIKE '%, modular walls') OR (`Article`.`tags` LIKE '%, modular walls, %') OR (`Article`.`tags` LIKE 'modular walls, %') OR (`Article`.`tags` LIKE 'steel cladding') OR (`Article`.`tags` LIKE '%, steel cladding') OR (`Article`.`tags` LIKE '%, steel cladding, %') OR (`Article`.`tags` LIKE 'steel cladding, %') OR (`Article`.`tags` LIKE 'steel frame solutions') OR (`Article`.`tags` LIKE '%, steel frame solutions') OR (`Article`.`tags` LIKE '%, steel frame solutions, %') OR (`Article`.`tags` LIKE 'steel frame solutions, %') OR (`Article`.`tags` LIKE 'modular homes') OR (`Article`.`tags` LIKE '%, modular homes') OR (`Article`.`tags` LIKE '%, modular homes, %') OR (`Article`.`tags` LIKE 'modular homes, %') OR (`Article`.`tags` LIKE 'structural steel') OR (`Article`.`tags` LIKE '%, structural steel') OR (`Article`.`tags` LIKE '%, structural steel, %') OR (`Article`.`tags` LIKE 'structural steel, %') OR (`Article`.`tags` LIKE 'modular water tanks') OR (`Article`.`tags` LIKE '%, modular water tanks') OR (`Article`.`tags` LIKE '%, modular water tanks, %') OR (`Article`.`tags` LIKE 'modular water tanks, %') OR (`Article`.`tags` LIKE 'modular rainwater tanks') OR (`Article`.`tags` LIKE '%, modular rainwater tanks') OR (`Article`.`tags` LIKE '%, modular rainwater tanks, %') OR (`Article`.`tags` LIKE 'modular rainwater tanks, %') OR (`Article`.`tags` LIKE 'rainwater tanks Australia') OR (`Article`.`tags` LIKE '%, rainwater tanks Australia') OR (`Article`.`tags` LIKE '%, rainwater tanks Australia, %') OR (`Article`.`tags` LIKE 'rainwater tanks Australia, %')) ORDER BY Rand() ASC LIMIT 211114
54SELECT `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4e6f99da-dc80-4ea6-b2d6-02276d7b5f76' 112
55SELECT `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` = ('4e6f99da-dc80-4ea6-b2d6-02276d7b5f76') ORDER BY `_order` asc, `created` asc 3325
56SELECT `Associate`.`id`, `Associate`.`user_id`, `Associate`.`architect_id`, `Associate`.`past`, `Associate`.`type`, `Associate`.`created` FROM `associates` AS `Associate` WHERE ((`architect_id` = '569c987d-9570-4272-be7f-454b6d7b5e1b') OR (`user_id` = '569c987d-9570-4272-be7f-454b6d7b5e1b')) 002
57SELECT 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` = '569c987d-9570-4272-be7f-454b6d7b5e1b' ORDER BY `Comment`.`id` desc 002
58SELECT `ArchitectsArchitecture`.`id`, `ArchitectsArchitecture`.`architect_id`, `ArchitectsArchitecture`.`architecture_id`, `ArchitectsArchitecture`.`_order`, `ArchitectsArchitecture`.`created`, `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 `architects_architectures` AS `ArchitectsArchitecture` LEFT JOIN `architectures` AS `Architecture` ON (`ArchitectsArchitecture`.`architecture_id` = `Architecture`.`id`) WHERE `ArchitectsArchitecture`.`architect_id` = '569c987d-9570-4272-be7f-454b6d7b5e1b' ORDER BY `Architecture`.`views` desc LIMIT 6004
59SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '569c987d-9570-4272-be7f-454b6d7b5e1b' 112
60SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '569c987d-9570-4272-be7f-454b6d7b5e1b' 112
61UPDATE `architects` SET `id` = '569c987d-9570-4272-be7f-454b6d7b5e1b', `views` = 1243, `views_last_day` = 2, `views_last_week` = 11, `views_last_month` = 34, `last_viewed` = '2019-09-23 10:11:14', `modified` = '2018-12-19 18:32:07' WHERE `architects`.`id` = '569c987d-9570-4272-be7f-454b6d7b5e1b'13
62SELECT `Architect`.`user_id` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '569c987d-9570-4272-be7f-454b6d7b5e1b' AND `Architect`.`deleted` <> 1 LIMIT 11111
63SELECT COUNT(*) AS `count` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '569c9782-f884-4cd3-a070-45386d7b5e1b' AND `Architect`.`deleted` <> 1 114
64UPDATE `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`.`architect_count` = 1 WHERE `User`.`id` = '569c9782-f884-4cd3-a070-45386d7b5e1b'02
65UPDATE `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` = "1243", `Article`.`views_last_day` = "2", `Article`.`views_last_week` = "11", `Article`.`views_last_month` = "34", `Article`.`last_viewed` = "2019-09-23 10:11:14" WHERE `foreign_id` = '569c987d-9570-4272-be7f-454b6d7b5e1b'123