|
дизайн среды:
В этом году компания HONKA отмечает юбилей. За 60 лет небольшой семейный бизнес вырос в международную корпорацию, на счету которой 85 000 проектов частных домов, объектов коммерческой ...
Создано 27.02.2018
Выставка-конкурс профессиональных и студенческих проектов, начиная с 1997 года.
Биеннале дизайна «Модулоп» является проектом Санкт-Петербургского Союза дизайнеров.
Биеннале ...
Создано 18.10.2017
Хельсинки верит в силу дизайна. Амбициозная цель стратегии города до 2021 года — быть самым функциональным городом в мире. Одним из способов добиться этого является комбинирование дизайна, оцифровки ...
Создано 13.09.2017
Международная Школа Дизайна (Москва и С.-Петербург) объявила прием работ на международный конкурс молодых дизайнеров «Дизайн-Дебют 2017», приуроченный к 15-летнему юбилею Школы в Санкт-Петербурге. ...
Создано 10.09.2017
Архитектурное бюро Archido под руководством архитектора Вадима Кондрашева выступило куратором градостроительного проекта в рамках Архитектурно-девелоперского форсайта РБК’16. Для исследования ...
Создано 19.05.2017
Приглашаем архитекторов, проектировщиков и дизайнеров участвовать в конкурсе «Национальная премия в области экологической архитектуры и строительства «Эко тектоника».
...
Создано 02.05.2017
Многофункциональность как тенденцию предметно-пространственного окружения также можно назвать этапом распредмечивания, сопровождающегося расширением функциональных возможностей. Тенденция эта, ...
Создано 20.02.2017
Уважаемые коллеги! Торгово-развлекательный центр «Охта Молл» и концерн SRV объявили о запуске конкурса на разработку айдентики Охты. Долгое время этот район был настоящей окраиной, несмотря ...
Создано 09.02.2017
Стартовал второй сезон международной профессиональной премии для архитекторов, дизайнеров и декораторов ADD AWARDS 2016. 7 основных номинаций, 4 специальных номинации, более 20 звездных экспертов — ...
Создано 18.10.2016
Уважаемые коллеги! В рамках XVII Всероссийского фестиваля архитектуры, дизайна и искусств в г. Тюмень будет проводиться традиционная выставка-конкурс, целью которой является выявление и поддержка ...
Создано 15.09.2016
“Курс HoReCa – настоящий источник вдохновения!”
“Очень интересные архитекторы и спикеры”
”Вдохновляет! Заряжает! Потрясает!”
”Свежий, актуальный ...
Создано 17.02.2016
В 2015 году после приобретения у Москвы 39 кинотеатров советской постройки компанией ADG Group был объявлен проект их реновации и создания на их базе многофункциональных центров шаговой доступности. ...
Создано 24.12.2015
Уважаемые коллеги! 14-15 ноября состоится практический форум для всех, кто связан со строительством и ремонтом дома или квартиры, посвященный техническим аспектам строительства и ведения проектов. Всё ...
Создано 11.11.2015
В октябре 2015 года бельгийская светотехническая компания Delta Light представила мировой общественности новое здание своей штаб-квартиры в Вевельгеме, а также отметила свое 25-летие.
© ...
Создано 11.11.2015
Спорное утверждение, что «художник должен быть голодным» опровергал ещё такой АС как Пушкин: «Не продаётся вдохновенье, но можно рукопись продать». Весь вопрос — сколько ...
Создано 16.07.2015
Уважаемые коллеги! Оргкомитет Биеннале «Модулор» объявляет об открытии приема заявок на юбилейную 10-ю выставку, которая состоится в «Креативном Пространстве ...
Создано 02.07.2015
Биеннале дизайна «Модулор», начавшись как отчётная выставка Санкт-Петербургского Союза Дизайнеров, превратилась в одно из самых крупных дизайнерских событий в России, включающее в свою орбиту ...
Создано 03.06.2015
НП Ассоциация «Невский проспект». Директору СПб филиала НИИ теории и истории архитектуры и градостроительства (НИИТИАГ РААСН) г-ну Кирикову Б.М. В своей деятельности «Ассоциация ...
Создано 06.04.2015
... потребности его обитателей. Проекты могут быть мульти-дисциплинарными, объединяя в себе несколько направлений дизайна: предметный (промдизайн), дизайн среды, дизайн интерьеров, медиа-дизайн и т.д.
...
Создано 16.03.2015
Эта история началась как защита кандидатской диссертации в Политехническом университете Милана в Италии. Для диссертации были проведены исследования и глубокий анализ более 800 конкурсов и премий в области ...
Создано 24.02.2015
В первый уикэнд апреля, по традиции, в Москве пройдет ежегодная Дизайн-Конференция, которая соберет на одной площадке ведущих экспертов рынка и осветит актуальные вопросы о трендах, тенденциях ...
Создано 16.02.2015
20 февраля в Галерее Музея Дизайна Vitra открывается выставка "Архитектура независимости - африканский модернизм". На данный момент это один из первых проектов, посвященных этому примечательному ...
Создано 03.02.2015
В Москве подведены итоги конкурса «Лофты для «Город Кристалл»». Участникам было предложено разработать концепции для 3-хкатегорий лофтов: «с патио», ...
Создано 30.01.2015
... потребности его обитателей. Проекты могут быть мульти-дисциплинарными, объединяя в себе несколько направлений дизайна: предметный (промдизайн), дизайн среды, дизайн интерьеров, медиа-дизайн и т.д.
...
Создано 19.01.2015
Дорогие друзья! Приглашаем вас принять участие в международном студенческом конкурсе «Устойчивое развитие городов». Конкурс проводится в рамках шестой международной конференции Экодизайн ...
Создано 12.01.2015
Ежегодный архитектурный фестиваль ЗОЛОТАЯ КАПИТЕЛЬ проводится в Новосибирске с 1996 года. Его центральным событием является Независимый национальный архитектурный рейтинг, который выводит архитектуру и ...
Создано 18.12.2014
Сочи — курортный город, известный своим гостеприимством. Солнце, море, пляж, отдых — вот первые слова, которые приходили в голову, когда звучало это название. Но с зимней Олимпиады SOCHI 2014 ...
Создано 07.11.2014
К нам на почту поступает большое количество информации о событиях, связанных с дизайном и архитектурой. Как правило, это пресс-релизы, в которых с той или иной степенью живописности повествуется «о ...
Создано 30.10.2014
Осенью 2015 года в помещениях Главного Штаба, в самом сердце Петербурга — на Дворцовой площади, состоится выставка, посвященная Золотому Веку финской архитектуры.
А предваряет ...
Создано 27.10.2014
“Уникальная возможность”, “получила еще огромный заряд вдохновения”, ”понравился профессионализм и четкость организации”, “все было на высшем уровне”, “классно, ...
Создано 17.10.2014
|
session.client.forwarded ⇒ 98.84.25.165
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ ca9a3052de608045934560a3e5917dd3
files ⇒
Application 0.000 seconds (+0.000); 0.68 MB (+0.683) - afterLoad
Application 0.083 seconds (+0.082); 9.94 MB (+9.257) - afterInitialise
Application 0.091 seconds (+0.009); 10.71 MB (+0.775) - afterRoute
Application 0.634 seconds (+0.543); 14.95 MB (+4.235) - afterDispatch
Application 0.655 seconds (+0.021); 18.34 MB (+3.391) - beforeRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.661 seconds (+0.006); 18.71 MB (+0.366) - afterRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.683 seconds (+0.022); 18.68 MB (-0.027) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.686 seconds (+0.004); 18.76 MB (+0.077) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.686 seconds (+0.000); 18.75 MB (-0.007) - beforeRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.725 seconds (+0.039); 18.79 MB (+0.039) - afterRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.779 seconds (+0.053); 18.80 MB (+0.016) - beforeRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 1.001 seconds (+0.222); 18.83 MB (+0.024) - afterRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 1.001 seconds (+0.000); 18.82 MB (-0.003) - beforeRenderModule mod_sape (Sape Module)
Application 1.002 seconds (+0.001); 18.85 MB (+0.020) - afterRenderModule mod_sape (Sape Module)
Application 1.003 seconds (+0.001); 18.84 MB (-0.007) - beforeRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 1.003 seconds (+0.000); 18.84 MB (+0.005) - afterRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 1.003 seconds (+0.000); 18.84 MB (-0.001) - beforeRenderModule mod_jlcackle (JL Cackle last comments)
Application 1.004 seconds (+0.000); 18.85 MB (+0.007) - afterRenderModule mod_jlcackle (JL Cackle last comments)
Application 1.004 seconds (+0.000); 18.85 MB (-0.003) - beforeRenderModule mod_custom (Yandex direct LEFT)
Application 1.007 seconds (+0.003); 18.85 MB (+0.008) - afterRenderModule mod_custom (Yandex direct LEFT)
Application 1.007 seconds (+0.000); 18.86 MB (+0.005) - beforeRenderModule mod_ads_elite (Ads Elite)
Application 1.292 seconds (+0.285); 19.24 MB (+0.384) - afterRenderModule mod_ads_elite (Ads Elite)
Application 1.387 seconds (+0.095); 19.27 MB (+0.024) - beforeRenderModule mod_lastupdate (mod_lastupdate)
Application 1.416 seconds (+0.029); 19.28 MB (+0.018) - afterRenderModule mod_lastupdate (mod_lastupdate)
Application 1.464 seconds (+0.049); 19.30 MB (+0.018) - beforeRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.488 seconds (+0.024); 19.37 MB (+0.074) - afterRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.513 seconds (+0.025); 19.33 MB (-0.044) - beforeRenderModule mod_flexbanners (FlexBanners)
Application 1.522 seconds (+0.009); 19.62 MB (+0.293) - afterRenderModule mod_flexbanners (FlexBanners)
Application 1.547 seconds (+0.025); 19.65 MB (+0.031) - beforeRenderModule mod_menuDU (mod_menuDU)
Application 1.559 seconds (+0.012); 20.28 MB (+0.622) - afterRenderModule mod_menuDU (mod_menuDU)
Application 1.810 seconds (+0.251); 18.10 MB (-2.174) - beforeRenderModule mod_search (Search)
Application 1.814 seconds (+0.004); 18.13 MB (+0.027) - afterRenderModule mod_search (Search)
Application 1.816 seconds (+0.003); 18.11 MB (-0.017) - beforeRenderModule mod_login (Login Form)
Application 1.820 seconds (+0.004); 18.15 MB (+0.037) - afterRenderModule mod_login (Login Form)
Application 1.898 seconds (+0.078); 17.27 MB (-0.884) - afterRender
17.41 MB (18,254,632 Bytes)
DELETE
FROM `a41xo_session`
WHERE `time` < '1731532295'
SELECT `session_id`
FROM `a41xo_session`
WHERE `session_id` = 'f2db763ccd09a18dad4f2b63454bcbbf'
LIMIT 0, 1
INSERT INTO `a41xo_session`
(`session_id`, `client_id`, `time`)
VALUES
('f2db763ccd09a18dad4f2b63454bcbbf', 0, '1731534095')
SELECT b.id
FROM a41xo_usergroups AS a
LEFT JOIN a41xo_usergroups AS 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
FROM a41xo_menu AS m
LEFT JOIN a41xo_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT `component`
FROM `a41xo_tortags_components`
UPDATE `a41xo_tortags_tags`
SET `hits`=hits+1
WHERE `title`='дизайн среды'
SELECT t.id
FROM a41xo_tortags_tags AS t
WHERE `t`.`title` LIKE '%дизайн среды%'
SELECT m.oid
FROM a41xo_tortags AS m
WHERE m.tid IN (14)
GROUP BY m.oid
SELECT m.item_id
FROM a41xo_tortags AS m
WHERE m.tid IN (14)
AND m.oid=1
SELECT c.*
FROM a41xo_tortags_components AS c
WHERE c.id =1
SELECT `id` AS `id`,`title` AS `title`,`introtext` AS `text`,`created` AS `created`,`catid`,`alias`,`images`
FROM a41xo_content AS `t`
WHERE state = 1
AND `id` IN (2381,2355,2353,2337,2330,2324,2317,2305,2304,2299,2297,2291,2294,2292,2288,2283,2282,2280,2279,2273,2272,2254,2257,2236,2235,2231,2225,2221,2220,2216,2209,2205,2199,2195,2192,2189,2186,2178,2177,2175,2170,2168,2159,2155,2151,2150,2146,2143,2130,2126,2121,2109,2107,2106,2103,2102,2085,2074,2051,2048,2025,2017,1979,1795,1927,1925,1919,1912,1908,1907,1894,1889,1883,1879,1872,1871,1870,1868,1863,1861,1847,1845,1837,1821,1816,1809,1808,1754,1751,1750,1710,1743,1737,1738,1729,1721,1712,1711,1694,1692,1693,1661,1648,1646,1643,1632,1631,1627,1617,1608,1579,1601,1593,1590,1559,1582,1563,1532,1523,1510,1501,1489,1483,1482,1478,1474,1458,1402,1399,1384,1376,1375,1372,1358,1357,1345,1300,1290,1268,1263,1256,1245,1244,1243,1228,1199,1187,1186,1184,1179,1172,1135,1123,1108,1086,1081,1057,1060,1053,1040,1031,1023,990,989,987,985,953,947,937,915,912,910,900,894,887,886,860,825,824,814,811,801,489,476,475,463,448,440,434,427,432,424,422,421,418,407,401,367,358,351,342,182,183,176,175,173,2375,2388,1351,1339,1261,2399,2402,2402,1133,986,2407,916,903,892,840,454,447,1321,2415,2448,2461,2469,2472,2484,2112,2052,1920,1917,2075,2568,2637,2639,2642,2662,2687,2741,2743,2771,2818,1556,2888,2896,2902,2905,2909,2914,2919,2922,2924,2952,2957,2964,2971,2975,2984,2986,2989,2990,2996,3025,3028,3032,3068,3069,3086,3093,1543,3100,3110,3133,3140,3142,3149,3152,3162,3169,3184,3208,3231,3251,3255,3299,3298,3318,3331,3349,3388,3395,3431,3434,3463,3465,3494,3497,3500,3512)
ORDER BY id desc
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=188896
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=165
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=159
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=132
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=107
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=122
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=188922
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=85
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=103
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=188916
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=121
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=98
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=111
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=84
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=51
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=76
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=36
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=120
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=155
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=156
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=188911
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=110
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=148
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=32
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=91
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=112
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=90
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=58
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=109
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=74
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=41
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=150
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY 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=147
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3512
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3500
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3497
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3494
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3465
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3463
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3434
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3431
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3395
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3388
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3331
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3318
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3299
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3298
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3255
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3251
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3231
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3208
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3184
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3169
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3162
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3152
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3149
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3142
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3140
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3133
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3110
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3100
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3093
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3086
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT html
FROM a41xo_odude_profile_field
WHERE name='design';
SELECT '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM a41xo_tortags x, a41xo_tortags_tags t
WHERE t.`id`=x.`tid`
GROUP BY t.`id`
LIMIT 20
SELECT *
FROM a41xo_users as u
LEFT JOIN a41xo_user_usergroup_map as ug
on u.id = ug.user_id
WHERE u.id=0
SELECT count(*) as v
FROM a41xo_vflow_data
SELECT count(*) as v
FROM a41xo_joomgallery
SELECT count(*) as v
FROM a41xo_content
SELECT `a41xo_vflow_data`.*
FROM ( SELECT id
FROM `a41xo_vflow_data`
ORDER BY RAND()
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
ORDER BY RAND()
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`
ORDER BY RAND()
LIMIT 2) as ids JOIN `a41xo_content`
ON `a41xo_content`.id = ids.id
where state = 1
UPDATE `a41xo_flexbanners`
SET finished=1, state=0
WHERE (enddate < '2024-11-14 00:41:36'
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-11-14 00:41:36'
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-11-14'
WHERE lastreset< '2024-11-14' or lastreset IS NULL
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` = '*')
ORDER BY `restrictbyid` desc, `dailyimpressions`
SELECT `component`
FROM `a41xo_tortags_components`
SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS 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
ORDER BY m.ordering
SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS 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
ORDER BY m.ordering
SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS 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
ORDER BY m.ordering
SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS 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
ORDER BY m.ordering
SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS 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
ORDER BY m.ordering
SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS 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
ORDER BY m.ordering
SELECT social_id
FROM a41xo_bt_connections
WHERE social_type ="facebook"
AND user_id ="0"
37 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
32 × SELECT `component`
FROM `a41xo_tortags_components
30 × SELECT *
FROM `a41xo_sitelinkx_config
30 × SELECT *
FROM `a41xo_sitelinkx`
30 × SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
30 × SELECT `component`
FROM `a41xo_tortags_components`
6 × SELECT m.*
FROM a41xo_modules AS m
LEFT JOIN a41xo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT count(*) as v
FROM a41xo_conten
1 × SELECT count(*) as v
FROM a41xo_joomgaller
1 × SELECT `a41xo_vflow_data`.*
FROM ( SELECT id
FROM `a41xo_vflow_data`
1 × SELECT count(*) as v
FROM a41xo_vflow_dat
1 × SELECT `a41xo_content`.*
FROM ( SELECT id
FROM `a41xo_content`
ORDER BY RAND()
LIMIT 2) as ids JOIN `a41xo_content`
ON `a41xo_content`.id = ids.id
1 × SELECT social_id
FROM a41xo_bt_connections
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 *
FROM a41xo_users as u
LEFT JOIN a41xo_user_usergroup_map as ug
on u.id = ug.user_id
1 × SELECT *
from ( SELECT id
FROM `a41xo_joomgallery`
1 × SELECT '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM a41xo_tortags x, a41xo_tortags_tags t
1 × SELECT t.id
FROM a41xo_tortags_tags AS t
1 × SELECT `id` AS `id`,`title` AS `title`,`introtext` AS `text`,`created` AS `created`,`catid`,`alias`,`images`
FROM a41xo_content AS `t`
1 × SELECT c.*
FROM a41xo_tortags_components AS c
1 × SELECT m.item_id
FROM a41xo_tortags AS m
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
FROM a41xo_menu AS m
LEFT JOIN a41xo_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, rules
FROM `a41xo_viewlevels
1 × SELECT html
FROM a41xo_odude_profile_field
1 × SELECT b.id
FROM a41xo_usergroups AS a
LEFT JOIN a41xo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `a41xo_session`
1 × SELECT m.oid
FROM a41xo_tortags AS m
1 × UPDATE `a41xo_flexbanners`
SET state=1
1 × UPDATE `a41xo_flexbanners`
SET dailyimpressions=0, lastreset='2024-11-14'
1 × UPDATE `a41xo_flexbanners`
SET finished=1, state=0
1 × UPDATE `a41xo_tortags_tags`
SET `hits`=hits+1
1 × INSERT INTO `a41xo_session` (`session_id`, `client_id`, `time`)
VALUES ('f2db763ccd09a18dad4f2b63454bcbbf', 0, '1731534095'
1 × DELETE
FROM `a41xo_session`