Веб-резиденция профессионального дизайна 02.02.2011
В худшем, со времен Великой Депрессии, состоянии экономики, которое переживали США, ТОП 100 Interior Design's Giants (Сотня Гигантов Дизайна Интерьера) заработали в 2009 году «грязными» $2 208 950 136. Цифра внушительная с любой точки зрения. Однако, это меньше на 18% по сравнению с предыдущим годом, и на 13% меньше той цифры, что была предсказана. При этом, пятеро из Гигантов остались на том же уровне доходов, а в 21-ой компании даже получили прирост до 33%.
Рынок мебели, аксессуаров и проектирования совокупно составил $57 848 835 473 — ниже на 1% чем ранее, но выше на 6% чем прогноз. Совокупное пространство проектирования уменьшилось на 26%, приведя среднюю стоимость за квадратный метр к $1409 — неплохое семипроцентное увеличение за предыдущий год. Общая чмсленность штата дизайнеров интерьера упала на 25% с 1 214 временными увольнениями и только с 349 повышениями, однако, зарплаты и расценки увеличились для всех должностей. Самые низкооплачиваемые служащие увидели самый большой рост средней зарплаты. Увеличения расценков колебались от полутора до шести раз. В среднем Giants заявили о 82-процентном использовании рабочего времени и только в четырех компаниях рабочее время было использовано на все 100 процентов. Средняя оплата, заработанная на служащего, продолжала повышаться — на сей раз на 3,7%
The New York Mets office at Citi Field in Flushing is by Mancini Duffy; фото: Eric Laignel
Многие из Giants отметили, что их клиенты, обнаружив маркетинговую ценность рекламирования приверженности к экологичности, рассматривают теперь и устойчивость и длительность — как хороший шанс для бизнеса. Взносы, относящиеся к «зеленому» дизайну, возросли с 30 до 38 процентов. Чмсло пространств с существенными экологичными компонентами увеличилось более чем на одну треть, чтобы приблизиться к 50%. Экологичные продукты составили чуть более половины из общего списка. У Interior Design's Giants были собственные рецепты о том, как производители могут выручить в условиях нестабильной экономики. Почти 22% призывали к большей роли вендоров в дизайн-процессе и большем влиянии на качество дизайнерского образования. Другие отметили потребность в улучшении эстетики, внимания к инновациям и более пристальном внимании к исследованию рынка. Четверть отметила роль «интеллектуальных» технологий — BIM и Revit, например, и большим количеством данных испытаний.
BIM (Building Information Model) — информационная модель здания — это общая база данных, в которой на протяжении всего жизненного цикла, начиная с проектирования, строительства, эксплуатации, реконструкций и заканчивая сносом, хранится вся информация, относящаяся к данному зданию. Ведение общей базы данных позволяет уже на самых ранних стадиях регистрировать и исправлять конфликты и рассогласования в технической документации, вносимые разными отделами и организациями в процессе работы над общим проектом. Техническая документация на любой объект всегда избыточна. Содержимое спецификаций определяется содержимым чертежей и наоборот, виды и разрезы зависят друг от друга и т.д. BIM позволяет автоматизировать внесение изменений во все зависимые части проекта. Например, изменение формы комнаты автоматически отразится на всех видах и спецификациях в проектной документации, в которых имеются элементы и характеристики этой комнаты.
99% опрошенных использовали информацию с веб-сайтов производителей. Возможно, это потому, что в Интернете технические проблемы в основном решены. Дизайнеры используют этот канал более чем когда-либо для исследования исходных продуктов.
OWP/P/Cannon Design renovated and restored Cannon Design's regional office in St. Louis; фото: Gayle Babcock/ Architectural Imageworks. Clemson University's Baruch Institute in Georgetown, South Carolina, is by LS3P Associates; фото: Matt Silk.
*Из-заошибок отправки,DBIархитекторов, IncиForrestPerkinsне были включены впервоначальныйрейтинг,опубликован вянваре 2010 опроса.DBIАрхитекторыдолжны были бытьперечислены в№ 47иForrestPerkinsдолжныбытьв #74. NR-не сообщается
Gettys designed the Hard Rock Hotel Macau; courtesy of City of Dreams.
Топ 10 в дизайне резиденций
Компания
Marc-Michaels Interior Design
$13,300,000
Robert A.M. Stern Architects
$6,646,940
Peter Marino Architect
$5,916,000
Callison
$2,870,000
Smallwood, Reynolds, Stewart, Stewart & Associates
$2,462,874
Rockwell Group
$2,344,160
Roger Ferris + Partners
$2,250,000
Swanke Hayden Connell Architects
$1,802,000
Perkins Eastman
$1,632,000
CBT
$1,600,000
Топ 10 в дизайне объектов культуры
Компания
Gensler
$7,600,000
HKS
$4,133,052
HGA Architects and Engineers
$2,692,500
Studios Architecture
$2,200,000
EwingCole
$1,944,000
Peter Marino Architect
$1,836,000
Roger Ferris + Partners
$1,500,000
Leo A Daly
$1,120,000
Rockwell Group
$1,093,144
HDR Architecture
$857,480
Chicago's Monitor Doblin office is by Sasaki Associates; photo by Robert Benson
Топ 10 наиболее быстрорастущих из списка Giants
Компания
2009 FEES
2008 FEES
% CHANGE
RANK
Gensler
$380,000,000
$285,000,000
33%
1
Bilkey Llinas Design Associates
$22,258,000
$17,200,000
29%
25
Francis Cauffman
$10,860,000
$8,500,000
28%
48
Perkins + Will
$104,058,000
$85,886,000
21%
2
OPX
$6,450,000
$5,372,820
20%
79
KNA Design
$6,300,000
$5,275,000
19%
82
Anderson Mikos Architects
$8,736,000
$7,477,500
17%
56
HGA Architects and Engineers
$26,925,000
$24,250,000
11%
20
Peter Marino Architect
$20,400,000
$18,700,000
9%
29
Roger Ferris + Partners
$15,000,000
$14,000,000
7%
36
Топ 10 в дизайне здравоохранения
Компания
Perkins + Will
$41,623,200
OWP/P/Cannon Design
$30,734,700
HDR Architecture
$30,011,800
Perkins Eastman
$22,440,000
PageSoutherlandPage
$19,440,000
Anshen + Allen
$19,126,800
HOK
$18,540,000
NBBJ
$17,849,490
SmithGroup
$14,732,220
HGA Architects and Engineers
$12,116,250
Cooper University Hospital by EwingCole is in Camden, New Jersey; фото: Eduard Hueber/Arch Photo.
Топ 10 в дизайне в социальной сфере
Компания
HBA/Hirsch Bedner Associates
$55,011,850
Wilson Associates
$53,460,000
Gensler
$41,800,000
Bilkey Llinas Design Associates
$22,258,000
Rockwell Group
$20,413,328
Leo A Daly
$16,800,000
Daroff Design + DDI Architects
$15,015,000
DiLeonardo International
$10,166,000
Gettys
$7,820,000
Chambers
$7,425,000
Топ 10 в дизайне в правительственных учреждениях
Компания
Gensler
$38,000,000
Jacobs
$34,544,227
Skidmore, Owings & Merrill
$13,742,469
HOK
$13,390,000
Leo A Daly
$8,400,000
PageSoutherlandPage
$8,100,000
RTKL Associates
$7,184,147
Studios Architecture
$5,500,000
Perkins + Will
$5,202,900
KZF Design
$4,592,980
Топ 10 в дизайне ритэйла
Компания
Gensler
$45,600,000
Callison
$36,736,000
Jacobs
$14,944,541
Peter Marino Architect
$8,772,000
JGA
$7,100,000
FRCH Design Worldwide
$5,985,000
Little
$5,208,000
RTKL Associates
$3,848,650
Ted Moudis Associates
$2,925,000
Vocon
$2,550,548
Новые компании в рейтинге Giants
Компания
RANK
WHR Architects
45
Planning Design Research Corporation
70
KZF Design
71
JGA
73
Spector Group
76
Ratcliff
77
Milo Kleinberg Design Associates
78
OPX
79
KNA Design
82
OTJ Architects
84
Ronald Schmidt & Associates
86
FXFowle Architects
87
STG Design
89
VeenendaalCave
91
Array Healthcare Facilities Solutions
94
Rottet Studio
95
Gary Lee Partners
96
Pollack Architecture
97
Tonychi and Associates
98
Sasaki Associates
99
Loebl Schlossman & Hackl
100
The Rockwell Group created sets for the 81st Academy Awards at the Kodak Theatre in Los Angeles; photo courtesy of The Academy of Motion Pictures Arts and Sciences.
SELECT b.id
FROMa41xo_usergroupsAS a
LEFTJOINa41xo_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `a41xo_viewlevels`
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROMa41xo_menuAS m
LEFTJOINa41xo_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SELECT `component`
FROM `a41xo_tortags_components`
SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROMa41xo_categories as c
LEFTJOINa41xo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFTJOIN (SELECT cat.id as id FROMa41xo_categoriesAS cat JOINa41xo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=1296 AND badcats.id is null
GROUPBY 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
ORDERBY c.lft
SELECT alias, catid FROMa41xo_content WHERE id = 1296
SELECT a.rules
FROMa41xo_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT b.rules
FROMa41xo_assetsAS a
LEFTJOINa41xo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASEWHEN badcats.id is null THEN a.state ELSE 0 ENDAS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN a.modified = 0 THEN a.created ELSE a.modified END as 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECTMAX(contact.id) AS id
FROMa41xo_contact_detailsAS contact
WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROMa41xo_contentAS a
LEFTJOINa41xo_categoriesAS c on c.id = a.catid
LEFTJOINa41xo_usersAS u on u.id = a.created_by
LEFTJOINa41xo_categories as parent ON parent.id = c.parent_id
LEFTJOINa41xo_content_ratingAS v ON a.id = v.content_id
LEFT OUTERJOIN (SELECT cat.id as id FROMa41xo_categoriesAS cat JOINa41xo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 1296 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-24 23:40:19') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-24 23:40:19') AND (a.state = 1 OR a.state =2)
SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROMa41xo_categories as c
LEFTJOINa41xo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFTJOIN (SELECT cat.id as id FROMa41xo_categoriesAS cat JOINa41xo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=113 AND badcats.id is null
GROUPBY 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
ORDERBY c.lft
SELECT* FROM `a41xo_sitelinkx_config`
SELECT* FROM `a41xo_sitelinkx` ORDERBY wort
SELECTTIMEVALUE FROM `a41xo_jlcacklepro_timer`
SELECT* FROM `a41xo_jlcacklepro_comment` where `post_id` ='http://design-union-spb.ru/authors/money/1296-100-interior-designs-giants' and `status` = '1'
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `id`
FROM `a41xo_tortags_components`
WHERE `component`='com_content'
SELECT `t`.* FROM `a41xo_tortags_tags` AS `t`
INNERJOIN `a41xo_tortags` AS `m` ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=1296 AND `m`.`oid`=1
ORDERBY `t`.`title` ASC
SELECT* FROM `a41xo_sitelinkx_config`
SELECT* FROM `a41xo_sitelinkx` ORDERBY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.* FROM `a41xo_tortags_tags` AS `t`
INNERJOIN `a41xo_tortags` AS `m` ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=1296 AND `m`.`oid`=1
ORDERBY `t`.`title` ASC
UPDATEa41xo_content SET hits = hits + 1 WHERE id = 1296
SELECT alias, catid FROMa41xo_content WHERE id = 1296
SELECT alias, catid FROMa41xo_content WHERE id = 1296
SELECT alias, catid FROMa41xo_content WHERE id = 1296
SELECT html FROMa41xo_odude_profile_field WHERE name='design';
SELECT* FROMa41xo_users as u LEFTJOINa41xo_user_usergroup_map as ug on u.id = ug.user_id WHERE u.id=0
SELECT count(*) as v FROMa41xo_vflow_data
SELECT count(*) as v FROMa41xo_joomgallery
SELECT count(*) as v FROMa41xo_content
SELECT `a41xo_vflow_data`.* FROM ( SELECT id FROM `a41xo_vflow_data` ORDERBYRAND() LIMIT 2) as ids JOIN `a41xo_vflow_data` ON `a41xo_vflow_data`.id = ids.id
SELECT* from
( SELECT id FROM `a41xo_joomgallery` WHERE published = 1 ORDERBYRAND() LIMIT 2) as j
join `a41xo_joomgallery` on a41xo_joomgallery.id = j.id
JOIN `a41xo_joomgallery_catg` ON catid = cid;
SELECT `a41xo_content`.* FROM ( SELECT id FROM `a41xo_content` ORDERBYRAND() LIMIT 2) as ids JOIN `a41xo_content` ON `a41xo_content`.id = ids.id where state = 1
SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROMa41xo_categories as c
LEFTJOINa41xo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFTJOIN (SELECT cat.id as id FROMa41xo_categoriesAS cat JOINa41xo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=144 AND badcats.id is null
GROUPBY 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
ORDERBY c.lft
SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROMa41xo_categories as c
LEFTJOINa41xo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFTJOIN (SELECT cat.id as id FROMa41xo_categoriesAS cat JOINa41xo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=188894 AND badcats.id is null
GROUPBY 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
ORDERBY c.lft
UPDATE `a41xo_flexbanners` SET finished=1, state=0
WHERE (enddate < '2025-03-25 02:40:24' and enddate != '0000-00-00 00:00:00' and state!=2 and state!=-2)
OR (impmade >= maximpressions AND maximpressions != 0 )
OR (clicks >= maxclicks AND maxclicks != 0)
UPDATE `a41xo_flexbanners` SET state=1
WHERE startdate<= '2025-03-25 02:40:24' and finished=0 and startdate != '0000-00-00 00:00:00' and state!=2 and state!=-2
UPDATE `a41xo_flexbanners` SET dailyimpressions=0, lastreset='2025-03-25'
WHERE lastreset< '2025-03-25' or lastreset ISNULL
SHOWFULLCOLUMNS FROM `a41xo_content`
SELECT* FROMa41xo_content WHERE `id` = '1296'
SELECT `a41xo_flexbanners`.`id`,
`a41xo_flexbannerslocations`.`locationname`,
`a41xo_flexbannerslocations`.`locationid`,
`a41xo_flexbanners`.`imageurl`,
`a41xo_flexbanners`.`imagealt`,
`a41xo_flexbanners`.`type`,
`a41xo_flexbanners`.`customcode`,
`a41xo_flexbanners`.`startdate`,
`a41xo_flexbanners`.`enddate`,
`a41xo_flexbanners`.`lastreset`,
`a41xo_flexbanners`.`impmade`,
`a41xo_flexbanners`.`clicks`,
`a41xo_flexbanners`.`maximpressions`,
`a41xo_flexbanners`.`maxclicks`,
`a41xo_flexbanners`.`linkid`,
`a41xo_flexbanners`.`language`,
`a41xo_flexbanners`.`newwin`,
`a41xo_flexbannerssize`.`width`,
`a41xo_flexbannerssize`.`height`,
`a41xo_flexbanners`.`restrictbyid`,
`a41xo_flexbanners`.`dailyimpressions`
FROM `a41xo_flexbanners`
Inner Join `a41xo_flexbannerslocations` ON (`a41xo_flexbanners`.`locationid` = `a41xo_flexbannerslocations`.`locationid`
AND `a41xo_flexbannerslocations`.`state` = 1)
Inner Join `a41xo_flexbannersclient` ON (`a41xo_flexbanners`.`clientid` = `a41xo_flexbannersclient`.`clientid`
AND `a41xo_flexbannersclient`.`state` = 1)
Inner Join `a41xo_flexbannerssize` ON (`a41xo_flexbanners`.`sizeid` = `a41xo_flexbannerssize`.`sizeid`
AND `a41xo_flexbannerssize`.`state` = 1)
WHERE `a41xo_flexbannerslocations`.`locationid` = 1
AND `a41xo_flexbanners`.`state` = 1
AND `a41xo_flexbanners`.`finished` = 0
AND (`a41xo_flexbanners`.`language` = "ru-RU" or `a41xo_flexbanners`.`language` = '*')
ORDERBY `restrictbyid` desc, `dailyimpressions`
SELECT b.title as cattitle, CASEWHENCHAR_LENGTH(a.alias) THENCONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASEWHENCHAR_LENGTH(b.alias) THENCONCAT_WS(':', a.catid, b.alias) ELSE a.catid END as catslug FROMa41xo_contentAS a LEFTJOINa41xo_categoriesAS b ON b.id = a.catid WHERE a.id = 1296
SELECT `component`
FROM `a41xo_tortags_components`
SELECT* FROM `a41xo_tortags_components`
WHERE `component`='com_content'
SELECT `id`
FROM `a41xo_tortags_components`
WHERE `component`='com_content'
SELECT `t`.* FROM `a41xo_tortags_tags` AS `t`
INNERJOIN `a41xo_tortags` AS `m` ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=1296 AND `m`.`oid`=1
SELECT `t`.`title`
FROM `a41xo_tortags_tags` AS `t`
ORDERBY `t`.`hits` DESC LIMIT 0, 300
SELECT b.rules
FROMa41xo_assetsAS a
LEFTJOINa41xo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_tortags')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT m.* FROMa41xo_modulesAS m
LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 10186 AND m.access IN (1,1) AND m.published = 1 AND e.enabled = 1
ORDERBY m.ordering
SELECT m.* FROMa41xo_modulesAS m
LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 10187 AND m.access IN (1,1) AND m.published = 1 AND e.enabled = 1
ORDERBY m.ordering
SELECT m.* FROMa41xo_modulesAS m
LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 10168 AND m.access IN (1,1) AND m.published = 1 AND e.enabled = 1
ORDERBY m.ordering
SELECT m.* FROMa41xo_modulesAS m
LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 81 AND m.access IN (1,1) AND m.published = 1 AND e.enabled = 1
ORDERBY m.ordering
SELECT m.* FROMa41xo_modulesAS m
LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 10166 AND m.access IN (1,1) AND m.published = 1 AND e.enabled = 1
ORDERBY m.ordering
SELECT m.* FROMa41xo_modulesAS m
LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
WHERE m.client_id = 0 AND m.id = 16 AND m.access IN (1,1) AND m.published = 1 AND e.enabled = 1
ORDERBY m.ordering
SELECT alias, catid FROMa41xo_content WHERE id = 1296
SELECT social_id FROMa41xo_bt_connections WHERE social_type ="facebook" AND user_id ="0"
39 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
6 × SELECT m.* FROMa41xo_modulesAS m LEFTJOINa41xo_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
5 × SELECT alias, catid FROMa41xo_content
4 × SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROMa41xo_categories as c LEFTJOINa41xo_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFTJOIN (SELECT cat.id as id FROMa41xo_categoriesAS cat JOINa41xo_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
4 × SELECT `component` FROM `a41xo_tortags_components
3 × SELECT `t`.* FROM `a41xo_tortags_tags` AS `t` INNERJOIN `a41xo_tortags` AS `m` ON `m`.`tid`=`t`.`id`
2 × SELECT b.rules FROMa41xo_assetsAS a LEFTJOINa41xo_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
2 × SELECT* FROM `a41xo_sitelinkx`
2 × SELECT* FROM `a41xo_sitelinkx_config
2 × SELECT `id` FROM `a41xo_tortags_components`
1 × SELECT* FROMa41xo_content
1 × SELECT `a41xo_flexbanners`.`id`,
`a41xo_flexbannerslocations`.`locationname`,
`a41xo_flexbannerslocations`.`locationid`,
`a41xo_flexbanners`.`imageurl`,
`a41xo_flexbanners`.`imagealt`,
`a41xo_flexbanners`.`type`,
`a41xo_flexbanners`.`customcode`,
`a41xo_flexbanners`.`startdate`,
`a41xo_flexbanners`.`enddate`,
`a41xo_flexbanners`.`lastreset`,
`a41xo_flexbanners`.`impmade`,
`a41xo_flexbanners`.`clicks`,
`a41xo_flexbanners`.`maximpressions`,
`a41xo_flexbanners`.`maxclicks`,
`a41xo_flexbanners`.`linkid`,
`a41xo_flexbanners`.`language`,
`a41xo_flexbanners`.`newwin`,
`a41xo_flexbannerssize`.`width`,
`a41xo_flexbannerssize`.`height`,
`a41xo_flexbanners`.`restrictbyid`,
`a41xo_flexbanners`.`dailyimpressions`
FROM `a41xo_flexbanners`
Inner Join `a41xo_flexbannerslocations` ON (`a41xo_flexbanners`.`locationid` = `a41xo_flexbannerslocations`.`locationid`
AND `a41xo_flexbannerslocations`.`state` = 1)
Inner Join `a41xo_flexbannersclient` ON (`a41xo_flexbanners`.`clientid` = `a41xo_flexbannersclient`.`clientid`
AND `a41xo_flexbannersclient`.`state` = 1)
Inner Join `a41xo_flexbannerssize` ON (`a41xo_flexbanners`.`sizeid` = `a41xo_flexbannerssize`.`sizeid`
AND `a41xo_flexbannerssize`.`state` = 1)
1 × SELECT `a41xo_content`.* FROM ( SELECT id FROM `a41xo_content` ORDERBYRAND() LIMIT 2) as ids JOIN `a41xo_content` ON `a41xo_content`.id = ids.id
1 × SELECT `a41xo_vflow_data`.* FROM ( SELECT id FROM `a41xo_vflow_data`
1 × SELECT* from ( SELECT id FROM `a41xo_joomgallery`
1 × SELECT* FROM `a41xo_tortags_components`
1 × SELECT social_id FROMa41xo_bt_connections
1 × SELECT b.id FROMa41xo_usergroupsAS a LEFTJOINa41xo_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `t`.`title` FROM `a41xo_tortags_tags` AS `t`
1 × SELECT count(*) as v FROMa41xo_conten
1 × SELECT b.title as cattitle, CASEWHENCHAR_LENGTH(a.alias) THENCONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASEWHENCHAR_LENGTH(b.alias) THENCONCAT_WS(':', a.catid, b.alias) ELSE a.catid END as catslug FROMa41xo_contentAS a LEFTJOINa41xo_categoriesAS b ON b.id = a.catid
1 × SELECT* FROMa41xo_users as u LEFTJOINa41xo_user_usergroup_map as ug on u.id = ug.user_id
1 × SELECTTIMEVALUE FROM `a41xo_jlcacklepro_timer
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASEWHEN badcats.id is null THEN a.state ELSE 0 ENDAS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN a.modified = 0 THEN a.created ELSE a.modified END as 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECTMAX(contact.id) AS id FROMa41xo_contact_detailsAS contact
1 × SELECT a.rules FROMa41xo_assetsAS a
1 × SELECT id, rules FROM `a41xo_viewlevels
1 × SELECT* FROM `a41xo_jlcacklepro_comment`
1 × SELECT `session_id` FROM `a41xo_session`
1 × SELECT count(*) as v FROMa41xo_vflow_dat
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROMa41xo_menuAS m LEFTJOINa41xo_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT html FROMa41xo_odude_profile_field
1 × SELECT `component` FROM `a41xo_tortags_components`
1 × SELECT count(*) as v FROMa41xo_joomgaller
Прочие SQL-запросы:
1 × UPDATE `a41xo_flexbanners` SET dailyimpressions=0, lastreset='2025-03-25'
1 × SHOWFULLCOLUMNS FROM `a41xo_content
1 × UPDATE `a41xo_flexbanners` SET state=1
1 × UPDATE `a41xo_flexbanners` SET finished=1, state=0