Веб-резиденция профессионального дизайна 29.06.2010
Международный День Промышленного Дизайна отмечается ежегодно 29 июня приветствием профессии промышленного дизайнера. Впервые провозглашенный в 2007 году по случаю 50-й годовщины ИКСИД, Международный День Промышленного Дизайна был основан с целью продвижения осведомленности о профессии промышленного дизайнера и расширения сотрудничества дизайнеров и преподавателей, которое помогает улучшить экономическое, социальное, культурное и экологическое качество жизни во всём мире.
Сериями международных событий 29 июня, инициированных как членами, так и не членами ИКСИД, Международный День Промышленного дизайна обеспечивает дизайнеров и единомышленников, энтузиастов широкого спектра профессий, каналом взаимодействия друг с другом. Такие события, как развивающие семинары, выставки, международные симпозиумы по социально ответственному дизайну, веб-трансляции, свободный вход в музеи и международный студенческий конкурс плакатов ИКСИД являются только частью той памятной деятельности, на которую Всемирный День Промышленного Дизайна вдохновил окружающий мир.
World Industrial Design Day 2010 Events
Australia
At the Queensland College of Art, there will be a screening of the feature-length film "Objectified", which documents the creative process of some of the world’s most influential product designers. The screening will be preceded by a panel discussion for World Industrial Design Day. This event was organised by the Design Institute of Australia (DIA) and the Queensland University of Technology (QUT) and will take place on 29 June.
Adelaide, in South Australia, is celebrating World Industrial Design day by holding a design contest called "Hung out to dry", which calls upon South Australian designers to design coat hangers made of recycled materials. This contest is to demonstrate how industrial designers can solve social and environmental issues.
Belgium
On 29 June in Antwerp, Flanders Inshape, three Flemish design universities and the Society of Flemish Designers will host a lecture by Icsid Senator Prof. Dr. Peter Zec entitled, "Good Industrial Design is Good Business!" This lecture will highlight the value of design as a strategic business tool for economic growth and added value. During the evening, there will also be a Pecha Kucha consisting of three designers presenting successful industrial design cases and a presentation by Ingrid Lieten, the Flemish minister of Innovation, Government investments, Media and Poverty reduction.
British Columbia Industrial Design (BCID) members, and their families and friends are invited to celebrate World Industrial Design Day at the first annual "Golden Links" Frisbee Golf event. The inaugural year of the tournament will be held at the 'classic' Jericho disc golf course.
Chile
The school of design at the Instituto Profesional DuocUC de la Pontificia Universidad Catolica de Chile (DuocUC) will be holding an exhibition and seminar about the value of design in everyday life. The exhibition will display 100 everyday objects that have marked the history of Chile in a way to examine the process and reasoning behind their design. The Seminar will be held on June 29 beginning at 15:00 at DuocUC San Carlos de Apoquindo Campus located in Santiago, Chile.
China
"Design changes the city, design makes life better!" Design is playing more and more important role in Beijing's Urban Planning. Beijing will hold a variety of activities on the theme of design on 29th June to celebrate World Industrial Design Day.
Celebration activities are as following:
The China Design Market (CDM) nameplate unveiling ceremony will be held on 29th June. Simultaneously, the first design museum in China will be established during CDM. Beijing Municipal Government built China's first design market in China Design Market Tower, it offers services to enterprises, designers, colleges and design firms including investing and financing, business negotiation, salon and exhibitions.
"+86 China Red Star Design Award Store" of Beijing Industrial Design Center (BIDC) will open in 798 artzone on 29th June. The store will sell Red Star awarded products and other popular design products to encourage citizens to use good design.
On 29th June, BIDC will also hold "Re-design of low-carbon life" exhibition in CDM to arouse the awareness of citizens to reuse and recycle waste product.
BIDC's China Design Plus College of Design Practice will organize a design management training for students in Beijing DRC Industrial Design Innovation Base.
Colombia
Pastodiseña design collective, in collaboration with a Universidad de Nariño I.D. students group, is holding a public design show in commemoration of World Industrial Design Day. The event, "RE USE 2" will include the creation of interesting objects entirely from plastic bottles and will be held from June 29 to July 4 at Unicentro Pasto Mall.
The city of Dresden will showcase the spontaneity of their artful city in collaboration with the Dresden Technical University by celebrating World Industrial Design Day. The program consists of a roundtable discussion about Design Education, a workshop on the future of design at the Museum of Decorative Arts and a discussion on 'Flow Design' and design practices.
Ireland
The Dublin Institute of Technology and the Institute of Designers in Ireland in association with Dublin City Council are pleased to announce details of a workshop to take place in the School of Art Design and Printing, DIT Mountjoy Square to celebrate World Industrial Design Day.
The workshop will bring together practitioners, recent graduates and students of all design disciplines to investigate design solutions relating to the theme. The attendees will be divided into teams and investigate solutions. The focus will be on creativity, networking and fun.
The workshop will run from 09:30 to 17:00 on Tuesday 29th June 2010 in DIT 41, Mountjoy Square, Dublin 1. The event is free and all are welcome. However places are limited and it will be necessary to RSVP in advance.
Iran
Mashhad Municipality is very pleased to celebrate WORLD INDUSTRIAL DESIGN DAY. Though, IAUM faculty members and students are the program administrative committee.
The program consists of a lecture and media presentation offered to emerging and professional industrial designers. Government and industry representatives will be the main participants of the symposium. The program will be held on 30 June at 6:00 pm. In addition, selected national product designs will be exhibited through 30 June to 7 July, at Mashhad artists' house (Kuh-sangi park). The exhibition will be open to the public to promote design as an essential aspect of business and contemporary lifestyle.
Organizers at ETMK City Branch is planning to celebrate World Industrial Design Day for the first time. The city's event "The Days To Come Together Today" is their designated slogan. They've also created a facebook event for local Turkish citizens to participate.
This year, Istanbul Technical University (ITU) Department of Industrial Product Design celebrated World Industrial Design Day on the 26th of June 2010, due to their graduation ceremony.
ITU alumni, students and members of the design community in Istanbul attended the meeting in which industrial designer Umit Altun gave a speech titled as "Being an Industrial Designer in Turkey". A cocktail party in Taskisla courtyard, kindly sponsored by Makel and Efe, followed the talk soon afterwards.
United Kingdom
During a two-day Research Festival at the University of Brighton's Design Archive, the archives' team will be distributing badges marking a selection of classic British product designs with recipients being invited to identify the designers. The University of Brighton's 'Design Archives' is home to the ICSID archive.
Venezuela
The University Institute of Technology Antonio José de Sucre Extension San Cristóbal, Táchira State located in Venezuela, is coordinating a series of workshops focused on solving problems in natural disaster for World Industrial Design Day. They have invited other Industrial Design schools within a border zone between Colombia and Venezuela, among them are the Experimental University of Tachira, the Politécnico Santiago Mariño, and the University of Pamplona.
The event will focus on forming three teams of 10 students of different universities using materials such as cardboard, aluminum and PET. This event will be coordinated by Prof. Dr. DI. Luis Salgado, Head of the School of Industrial Design faculty of the University Institute of Technology Antonio José de Sucre Extension San Cristóbal.
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=951 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 = 951
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 = 951 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 22:57:50') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 22:57:50') 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=8 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/portalnew/place-of/world/951-widd10' 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`=951 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`=951 AND `m`.`oid`=1
ORDERBY `t`.`title` ASC
UPDATEa41xo_content SET hits = hits + 1 WHERE id = 951
SELECT alias, catid FROMa41xo_content WHERE id = 951
SELECT alias, catid FROMa41xo_content WHERE id = 951
SELECT alias, catid FROMa41xo_content WHERE id = 951
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=117 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=123 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 < '2024-04-27 01:57:52' 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<= '2024-04-27 01:57:52' and finished=0 and startdate != '0000-00-00 00:00:00' and state!=2 and state!=-2
UPDATE `a41xo_flexbanners` SET dailyimpressions=0, lastreset='2024-04-27'
WHERE lastreset< '2024-04-27' or lastreset ISNULL
SHOWFULLCOLUMNS FROM `a41xo_content`
SELECT* FROMa41xo_content WHERE `id` = '951'
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 = 951
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`=951 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 = 951
SELECT social_id FROMa41xo_bt_connections WHERE social_type ="facebook" AND user_id ="0"
38 типов 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='2024-04-27'
1 × SHOWFULLCOLUMNS FROM `a41xo_content
1 × UPDATE `a41xo_flexbanners` SET state=1
1 × UPDATE `a41xo_flexbanners` SET finished=1, state=0