|
графический дизайн:
Фейкстиваль 2016 уже открыт и ждёт ваших смелых рекламных и дизайн-концепций! В этом году мы приготовили много интересного.
Во-первых, мы добавили новые опции. Дело ...
Создано 24.05.2016
Уважаемые коллеги! 25 апреля 2016 года стартовал VI конкурс «GIFTS Award 2016» – конкурс идей для бизнес-подарков. Конкурс, в котором могут принять участие промышленные дизайнеры, ...
Создано 20.05.2016
В статье рассматривается архитектура и другие коммуникации Санкт-Петербурга с точки зрения семиотики и архетипов. Абстрагированы некоторые из основных оппозиций, касающихся Санкт-Петербурга. Одним из ...
Создано 19.05.2016
В этом году, вот уже шестой год подряд, фестиваль Weltformat организует международный студенческий конкурс плаката.
Двадцать плакатов, отобранных Жюри, будут представлены ...
Создано 04.05.2016
С 25 мая по 1 июня 2016 года Санкт-Петербург в шестой раз под слоганом Design[6]Sense пройдет Неделя Архитектуры и Дизайна — St. Petersburg Design Week 2016. Событие представит последние достижения ...
Создано 29.04.2016
Мир, в котором решены все глобальные проблемы, мир, где нет самых болезненных проблем человечества, станет главной темой конкурса графических дизайнеров Digital Decade 2016.
...
Создано 18.04.2016
Биеннале Плаката в Эквадоре является главной осью визуальной коммуникации нового континента, концентрирует свои усилия, чтобы быть научным, профессиональным и творческим событием, где каждый, кто связан ...
Создано 15.04.2016
Звезда графического дизайна Невилл Броуди, ниспровергатель мейнстрима, бунтарь и экспериментатор, глава Research Studios с филиалами в Париже, Берлине, Барселоне и Токио, автор книги The ...
Создано 12.04.2016
24 марта в Белом Зале Комитета по Культуре Санкт-Петербурга состоялось заседание расширенного экспертного Совета и церемония Награждения победителей конкурса «Хочу в Гатчину».
...
Создано 28.03.2016
«Make Extremism History!» является восьмым ежегодным конкурсом дизайна, организованным 4tomorrow.
Конкурс является частью проекта «poster for tomorrow»/ Он направлен на ...
Создано 09.03.2016
На протяжении без малого 300-летней истории СПб гос.университета культура и искусство были неразрывно связаны с деятельностью вуза. Но именно с началом функционирования графического направления, в области ...
Создано 25.02.2016
... новое направление - образовательная программа «Графический дизайн». За 15 лет реализации данного направления из стен Санкт-Петербургского государственного университета вышло более 470 дизайнеров-универсантов, ...
Создано 05.02.2016
Уважаемые коллеги! Фонд Международного центра встреч молодежи в Освенциме – организатор шестого Международного социально-политической Биеннале плаката приглашает к участию в конкурсе.
...
Создано 06.01.2016
Государственный музей-заповедник “Гатчина” и Ассоциация “Центр развития творческих индустрий” объявляют старт открытого конкурса для молодых дизайнеров на разработку логотипа ...
Создано 29.12.2015
Уважаемые, коллеги! Друзья! Предлагаем вашему вниманию книгу о скетчинге. Настоящая книга адресована дизайнерам интерьера и тем, кто собирается им стать. ...
Создано 21.12.2015
До 20 декабря идёт прием работ на XVI Всероссийскую выставку-конкурс товарных знаков «Золотая Блоха». На сегодняшний день прислано рекордное количество работ – свыше 2000! В проекте ...
Создано 18.12.2015
В честь 70-летия первой резолюции Генеральной Ассамблеи ООН, в которой была поставлена цель ликвидации ядерного оружия и всех других видов оружия массового уничтожения, Управление Организации Объединенных ...
Создано 30.11.2015
Событие Habitare, представляющее дизайн мебели и интерьера изменило свою айдентику,освежив и акцентировав свои свои сильные стороны и перспективу.
Новый визуальный ...
Создано 26.11.2015
23 октября во Всероссийский день работника рекламы в Казани открылась выставка нереализованных рекламных проектов «ПОТРАЧЕНО».
Проблема идей, уходящих ...
Создано 29.10.2015
В московском агентстве Bang! Bang! Studio, 7 лет занимающимся иллюстрацией в сфере рекламы и полиграфии на российском рынке, открыли онлайн-школу для иллюстраторов, где можно научиться работать в самых ...
Создано 26.10.2015
В этом году на Смарт фестивале было зарегистрировано около 1500 человек из Воронежа, Москвы, Санкт-Петербурга, Смоленска и других городов России. За два дня на 4 площадках выступили более 50 экспертов, ...
Создано 14.10.2015
Уважаемые рузья и коллеги! 10-11 октября 2015 года пройдет ежегодный «Смарт-фестиваль». Третий год подряд фестиваль собирает наикрутейших людей веба: спикеров, экспертов,дизайнеров, разработчиков, ...
Создано 08.09.2015
С этой осени у графиков дизайнеров появляется новая лаборатория для творческих экспериментов – Лаборатория плаката.
Что такое современный плакат? Наиболее востребованный у галеристов ...
Создано 03.08.2015
Компания Iggesund Papreboard организовала конкурс для дизайнеров из разных стран мира по улучшению и созданию более экологичной потребительской упаковки. Было представлено около 200 дизайнерских ...
Создано 29.07.2015
Друзья! Вас приветствует команда “КАК”, которая круглосуточно работает над книгой "Соль русского дизайна", чтобы успеть выпустить ее в декабре этого года.
...
Создано 23.07.2015
Спорное утверждение, что «художник должен быть голодным» опровергал ещё такой АС как Пушкин: «Не продаётся вдохновенье, но можно рукопись продать». Весь вопрос — сколько ...
Создано 16.07.2015
Уважаемые коллеги! Оргкомитет Биеннале «Модулор» объявляет об открытии приема заявок на юбилейную 10-ю выставку, которая состоится в «Креативном Пространстве ...
Создано 02.07.2015
Биеннале дизайна «Модулор», начавшись как отчётная выставка Санкт-Петербургского Союза Дизайнеров, превратилась в одно из самых крупных дизайнерских событий в России, включающее в свою орбиту ...
Создано 03.06.2015
В последнее время мы забываем, что живем в мультикультурном мире. При всех различиях у многих народов гораздо больше общего, чем кажется. Глобальные тренды диктуют модель поведения, манеру ...
Создано 27.04.2015
Бренд-дизайн — это дизайн для брендов. Коммерческий графический дизайн, как таковой отличает от бренд-дизайна ориентация последнего на массовое потребление. В бренд-дизайне во главу угла становится ...
Создано 20.04.2015
|
session.client.forwarded ⇒ 18.119.139.50
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
session.token ⇒ 8df1ae62de9081edd839b2bb2dcda8f5
files ⇒
Application 0.000 seconds (+0.000); 0.68 MB (+0.683) - afterLoad
Application 0.089 seconds (+0.089); 9.94 MB (+9.258) - afterInitialise
Application 0.098 seconds (+0.009); 10.72 MB (+0.776) - afterRoute
Application 0.710 seconds (+0.612); 14.94 MB (+4.227) - afterDispatch
Application 0.725 seconds (+0.015); 16.38 MB (+1.440) - beforeRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.731 seconds (+0.006); 16.74 MB (+0.356) - afterRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.737 seconds (+0.006); 16.71 MB (-0.026) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.741 seconds (+0.004); 16.79 MB (+0.077) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.741 seconds (+0.000); 16.78 MB (-0.007) - beforeRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.770 seconds (+0.029); 16.82 MB (+0.038) - afterRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.785 seconds (+0.015); 16.84 MB (+0.016) - beforeRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.813 seconds (+0.028); 16.86 MB (+0.024) - afterRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.813 seconds (+0.000); 16.86 MB (-0.003) - beforeRenderModule mod_sape (Sape Module)
Application 0.814 seconds (+0.001); 16.88 MB (+0.021) - afterRenderModule mod_sape (Sape Module)
Application 0.815 seconds (+0.000); 16.87 MB (-0.007) - beforeRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.815 seconds (+0.000); 16.88 MB (+0.005) - afterRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.815 seconds (+0.000); 16.88 MB (-0.001) - beforeRenderModule mod_jlcackle (JL Cackle last comments)
Application 0.815 seconds (+0.000); 16.88 MB (+0.007) - afterRenderModule mod_jlcackle (JL Cackle last comments)
Application 0.815 seconds (+0.000); 16.88 MB (-0.003) - beforeRenderModule mod_custom (Yandex direct LEFT)
Application 0.818 seconds (+0.002); 16.89 MB (+0.007) - afterRenderModule mod_custom (Yandex direct LEFT)
Application 0.818 seconds (+0.000); 16.89 MB (+0.005) - beforeRenderModule mod_ads_elite (Ads Elite)
Application 1.104 seconds (+0.286); 17.28 MB (+0.387) - afterRenderModule mod_ads_elite (Ads Elite)
Application 1.145 seconds (+0.041); 17.31 MB (+0.025) - beforeRenderModule mod_lastupdate (mod_lastupdate)
Application 1.189 seconds (+0.044); 17.32 MB (+0.018) - afterRenderModule mod_lastupdate (mod_lastupdate)
Application 1.204 seconds (+0.015); 17.34 MB (+0.017) - beforeRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.221 seconds (+0.017); 17.41 MB (+0.068) - afterRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.229 seconds (+0.008); 17.37 MB (-0.038) - beforeRenderModule mod_flexbanners (FlexBanners)
Application 1.234 seconds (+0.005); 17.66 MB (+0.294) - afterRenderModule mod_flexbanners (FlexBanners)
Application 1.243 seconds (+0.009); 17.69 MB (+0.029) - beforeRenderModule mod_menuDU (mod_menuDU)
Application 1.269 seconds (+0.026); 17.99 MB (+0.301) - afterRenderModule mod_menuDU (mod_menuDU)
Application 1.598 seconds (+0.329); 18.26 MB (+0.267) - beforeRenderModule mod_search (Search)
Application 1.602 seconds (+0.004); 18.29 MB (+0.026) - afterRenderModule mod_search (Search)
Application 1.605 seconds (+0.003); 18.27 MB (-0.018) - beforeRenderModule mod_login (Login Form)
Application 1.609 seconds (+0.005); 18.31 MB (+0.038) - afterRenderModule mod_login (Login Form)
Application 1.685 seconds (+0.076); 17.47 MB (-0.837) - afterRender
17.59 MB (18,447,552 Bytes)
DELETE
FROM `a41xo_session`
WHERE `time` < '1714015249'
SELECT `session_id`
FROM `a41xo_session`
WHERE `session_id` = 'd663eb16b808aa95cf95a3d79d28b340'
LIMIT 0, 1
INSERT INTO `a41xo_session`
(`session_id`, `client_id`, `time`)
VALUES
('d663eb16b808aa95cf95a3d79d28b340', 0, '1714017049')
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 (18)
GROUP BY m.oid
SELECT m.item_id
FROM a41xo_tortags AS m
WHERE m.tid IN (18)
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 (2068,2067,2064,2063,2033,2019,1982,1939,1923,1916,1914,1911,1897,1895,1844,1835,1834,1832,1828,1825,1809,1757,1738,1729,2183,2125,2148,2089,1725,1719,1699,1708,1707,1700,1658,1673,1680,1668,1665,1663,1657,1647,1638,1622,1621,1619,1605,1599,1594,2356,2334,2328,2326,2325,2319,2311,2307,2293,2296,2295,2290,2286,2259,2241,2245,2242,2218,2217,2214,2213,2204,2191,2188,2171,2164,2160,2149,2142,2104,2097,2094,2091,2078,2077,2073,2056,2053,2039,2015,2015,1990,1986,1972,1970,1965,1961,1958,1957,1946,1940,1930,1921,1909,1904,1902,1896,1891,1888,1881,1878,1876,1873,1869,1867,1862,1859,1858,1856,1849,1819,1818,1815,1814,1810,1803,1759,1749,1747,1739,1589,1575,1567,1562,1550,1548,1555,1547,1540,1538,1534,1531,1526,1521,1514,1512,1511,1503,1495,1494,1481,1492,1488,1485,1484,1466,1465,1461,1464,1463,1462,1452,1448,1439,1433,1434,1429,1427,1420,1418,1417,1414,1412,1409,1407,1401,1385,1383,1379,1380,1374,1371,1365,1348,1331,1323,1304,1299,1294,1291,1288,1284,1275,1276,1272,1266,1260,1258,1254,1239,1242,1227,1211,1214,1212,1209,1206,1198,1194,1185,1182,1176,1168,1162,1161,1149,1147,1140,1142,1134,1120,1103,1111,1097,1089,1085,1062,1055,1052,1050,1051,1041,1038,1016,1017,1015,1010,1005,1002,1000,996,995,977,976,972,969,962,949,948,944,939,920,919,907,906,905,904,899,897,895,891,878,875,872,864,866,861,846,842,838,836,834,833,831,830,820,818,817,816,815,806,803,799,502,497,491,487,466,456,446,444,428,425,417,403,383,381,380,365,360,346,343,333,322,314,309,306,305,303,302,298,295,294,291,290,283,282,280,277,271,230,259,256,252,239,237,235,234,233,229,180,179,171,170,158,154,144,140,130,119,101,77,59,2327,2250,2208,1156,1297,1220,1820,2391,2392,2400,1154,242,224,177,2404,2382,2452,2461,2457,2456,2524,2535,1884,2112,2052,1920,2075,2561,2582,2591,2596,2638,2662,2686,2692,2696,2713,2741,2742,2757,2758,2782,2787,2790,2793,2807,2779,2858,2865,2903,2923,2930,2945,2969,2992,3019,3024,3026,3027,2973,2898,2810,3080,3082,1626,3116,3122,3126,3134,3138,461,3140,3141,3145,3150,3156,3146,3165,3168,3176,3182,3183,3187,3196,3197,3207,3216,3217,3222,3231,3251,3255,3256,3259,3261,3272,3289,3292,3293,3305,3307,3315,3317,3319,3320,3327,3334,3340,3345,3350,3353,3354,3357,3358,3361,3363,3365,3369,3370,3376,3383,3385,3388,3389,3399,3402,3404,3409,3425,3429,3431,3435,3440,3452,3453,3456,3460,3462,3474,3477,3479,3480,3490,3491,3494,3499,3500)
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=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=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=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=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=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=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=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=124
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=117
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=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=188914
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=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=27
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=20
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=128
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=188897
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=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=188910
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=188909
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=24
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=188908
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=126
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=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=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=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=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=151
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=131
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=130
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=149
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=129
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=146
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=93
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=108
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=144
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 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 m.item_id
FROM a41xo_tortags AS m
WHERE m.tid IN (18)
AND m.oid=8
SELECT c.*
FROM a41xo_tortags_components AS c
WHERE c.id =8
SELECT `asset_id` AS `id`,`name` AS `title`,`description` AS `text`,`owner` AS `created`
FROM a41xo_joomgallery_catg AS `t`
WHERE `asset_id` IN (7247)
ORDER BY id desc
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`=3365
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`=3363
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`=3361
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`=3358
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`=3357
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`=3354
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`=3353
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`=3350
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`=3345
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`=3340
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`=3334
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`=3327
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`=3320
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`=3319
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`=3317
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`=3315
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`=3307
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`=3305
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`=3293
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`=3292
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`=3289
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`=3272
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`=3261
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`=3259
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`=3256
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`=3222
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`=3217
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM a41xo_modules AS m
LEFT JOIN a41xo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN a41xo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-25 03:50:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 03:50:50')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 690 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
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-04-25 06:50:51'
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-25 06:50:51'
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-25'
WHERE lastreset< '2024-04-25' 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"
46 × 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
2 × SELECT c.*
FROM a41xo_tortags_components AS c
2 × SELECT m.item_id
FROM a41xo_tortags AS m
1 × SELECT count(*) as v
FROM a41xo_conten
1 × SELECT count(*) as v
FROM a41xo_joomgaller
1 × SELECT count(*) as v
FROM a41xo_vflow_dat
1 × SELECT `a41xo_vflow_data`.*
FROM ( SELECT id
FROM `a41xo_vflow_data`
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 social_id
FROM a41xo_bt_connections
1 × SELECT *
FROM a41xo_users as u
LEFT JOIN a41xo_user_usergroup_map as ug
on u.id = ug.user_id
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 *
from ( SELECT id
FROM `a41xo_joomgallery`
1 × SELECT html
FROM a41xo_odude_profile_field
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 `asset_id` AS `id`,`name` AS `title`,`description` AS `text`,`owner` AS `created`
FROM a41xo_joomgallery_catg AS `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 id, rules
FROM `a41xo_viewlevels
1 × SELECT `session_id`
FROM `a41xo_session`
1 × SELECT m.oid
FROM a41xo_tortags AS m
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM a41xo_modules AS m
LEFT JOIN a41xo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN a41xo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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 '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM a41xo_tortags x, a41xo_tortags_tags t
1 × UPDATE `a41xo_flexbanners`
SET state=1
1 × UPDATE `a41xo_flexbanners`
SET dailyimpressions=0, lastreset='2024-04-25'
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 ('d663eb16b808aa95cf95a3d79d28b340', 0, '1714017049'
1 × DELETE
FROM `a41xo_session`