|
графический дизайн:
Споры о том, что есть фотография – искусство или техническое умение – сегодня однозначно решены в пользу искусства. Его главная задача – передать настроение и эмоции, подчеркнуть неповторимость ...
Создано 06.12.2010
Шум, гам, суета, толпы байкеров и гимнастов, репортеров и чиновников… Такая вот «Молодежная Волна» с головой накрыла 7-й павильон Ленэкспо 26 ноября 2010 года, и можно только посочувствовать ...
Создано 30.11.2010
Future Generation Art Prize — первая глобальная арт-премия для поддержки нового поколения художников, присуждаемая по итогам открытого международного конкурса. Главный приз размером в $100 ...
Создано 30.11.2010
Уважаемые друзья и коллеги! В 2010 году исполнилось 10 лет образовательной программе «Графический дизайн» Факультета искусств СПбГУ. Десятилетний юбилей программа отметила переходом в ...
Создано 25.11.2010
Если верить одной древней легенде, живопись появилась от очерчивания тени. Так еще не существовавшее искусство фотографии легло в основу живописи. В наши дни, этот способ определения пространства — ...
Создано 24.11.2010
Галерея современного искусства Anna Nova представляет выставку Александра Флоренского «Картины, нарисованные в путешествиях 2005-2010», которую можно будет посмотреть с 26 ноября по 20 декабряпо ...
Создано 18.11.2010
Организаторы: Минэнерго России совместно с Государственным центральным музеем современной истории России и Мемориальным музеем-квартирой Г.М. Кржижановского. Партнеры конкурса - Союз художников России ...
Создано 17.11.2010
Начался новый этап международной премии «Arte Лагуна», поощряющей молодое современное искусство. Оставаясь последовательными в достижении поставленных целей, создатели Arte Laguna — ...
Создано 15.11.2010
Структура образовательного процесса Детской Студии Мультимедиа «M-ART» рассчитана на 4 года непрерывного обучения (с 12 до 17 лет) и включает в себя взаимодополняющий спектр дисциплин (анимационных, ...
Создано 11.11.2010
Основатели новой компании — оператора IP-телевидения, доверили дизайн-студии Oblako назвать своё детище. Для того чтобы название говорило само за себя, мы подробнейшим образом изучили идейную ...
Создано 09.11.2010
Человек ходит по городам, смотрит через объектив и щелчком останавливает время. Раз – стоп, меньше секунды. И потом - дальше. Идти себе, смотреть, где-нибудь выпить кофе, с кем-нибудь незнакомым ...
Создано 09.11.2010
В этом году проекту «Золотая Блоха» — Всероссийской выставке-конкурсу товарных знаков и логотипов исполнилось 10 лет. Декларируемые цели: выявление новейших тенденций и профессиональных ...
Создано 08.11.2010
Журнал ПРОЕКТ БАЛТИЯ приглашает вас на открытие выставки Юрия Молодковца«АВТОРСКИЙ НАДЗОР. Портрет + Дизайн. Часть I», которое состоится в салоне ANDREW MARTIN 10 ноября в 19:00
...
Создано 06.11.2010
Санкт-Петербургский Союз дизайнеров по заказу Комитета по молодёжной политике и взаимодействию с общественными организациями Санкт-Петербурга проводит открытый творческий молодёжный конкурс на ...
Создано 01.11.2010
В выставочном центре «Мойка 8» Санкт-Петербургского Союза дизайнеров с 8 по 23 ноября будет работать выставка творческих работ Ирины Владимировны Егоровой —замечательного дизайнера ...
Создано 31.10.2010
Немецкий культурный центр имени Гёте в партнерстве с Лофт Проектом ЭТАЖИ представляют выставку Института связей с зарубежными странами — Гюнтер Юккер «Человек Страдающий. 14 примиряющих ...
Создано 23.10.2010
Раз в несколько лет С-Arts объединяет ведущих иллюстраторов и художников России для самой масштабной коллективной работы в рамках современного искусства. Впервые проект стартовал в 2003 году. К этому ...
Создано 26.10.2010
Знак — минимальная и самая лапидарная форма графического дизайна. Соль. Суть. Зерно. Биеннале географически проводится в России, в Сибири. Дизайн объединяет весь мир. Все объединяет знак. Международная ...
Создано 21.10.2010
13 октября - 3 ноября 2010г. Галерея «Рабфак» представляет выставку Коптевой Анастасии «Действия с множествами». Открытие 13 октября, в 19:00.
СТАЧКА и РАБФАК – ...
Создано 13.10.2010
«Его искусство –это проявление совершенной свободы и тончайшего эстетизма. Олега Яковлева всегда интересовали простые формы. В его работах нет ни грамма излишней художественной ...
Создано 08.10.2010
Культурная ассоциация MoCA (Modern Contemporary Art), в сотрудничестве сo Студией Arte Laguna при поддержке Министерства Иностранных Дел, Региона Венето, Европейского института дизайна. приглашают принять ...
Создано 10.10.2010
Международная Биеннале плаката в Мексике.
При поддержке: Комитета по культуре Правительства Санкт-Петербурга, Комитета по внешним связям Санкт-Петербурга, Посольства Мексики в России, Неправительственного ...
Создано 03.10.2010
Для европейцев Япония представляет собой удивительную загадку, до сих пор неразгаданную ими. Такая далекая и таинственная, Япония издревле манила к себе путешественников. Исполненное же гипнотического ...
Создано 29.09.2010
Фонд Елены Франчук «АНТИСПИД» провел конкурс графического дизайна Naked Street Fashion. Миссия организаторов конкурса состоит в напоминании молодежи: «хороший секс — это ...
Создано 28.09.2010
Ставший привычным для всех логотип конкурса «Адмиралтейская Игла», начинающийся с субтильной заглавной буквы «А», силуэт которой образован швейной иглой, условно опирающейся ...
Создано 20.09.2010
...
Чем может помочь Графический дизайн?
Глобальное био-разнообразие теряется гораздо быстрее, чем вымирание из-за природных изменений в землепользовании, нерационального ...
Создано 15.09.2010
15 сентября 2010 года в 18.00 в Галерее Дизайна/bulthaup состоится церемония награждения победителей конкурса художественной фотографии Explanation Kills Art Photo Contest и торжественное ...
Создано 13.09.2010
В этом году исполняется 105 лет со дня рождения Даниила Хармса.
Издательство «Азбука» и книжный магазин «Москва» дают шанс попробовать свои силы и стать настоящим книжным художником, ...
Создано 13.09.2010
Интернет облетела новость из области дизайна — типографики, которая не так часто балует читателей громкими событиями: исследователи из Лаборатории зрительной эргономики США, пришли к выводу на ...
Создано 13.09.2010
LAZAREV GALLERY представляет: «50 000 руб.» живопись Владимира Титова и видео перформанс «ЛКШ – group» Пресс-конференция и открытие: 9 сентября. Время работы выставки: ...
Создано 07.09.2010
|
session.client.forwarded ⇒ 18.216.233.58
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
session.token ⇒ e4448fc1cf4482d4c9bd28deeedea13b
files ⇒
Application 0.000 seconds (+0.000); 0.68 MB (+0.683) - afterLoad
Application 0.243 seconds (+0.243); 9.94 MB (+9.258) - afterInitialise
Application 0.251 seconds (+0.009); 10.72 MB (+0.776) - afterRoute
Application 0.917 seconds (+0.666); 14.87 MB (+4.156) - afterDispatch
Application 0.930 seconds (+0.012); 15.57 MB (+0.699) - beforeRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.935 seconds (+0.006); 15.93 MB (+0.357) - afterRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.936 seconds (+0.001); 15.90 MB (-0.029) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.940 seconds (+0.003); 15.98 MB (+0.077) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.940 seconds (+0.000); 15.97 MB (-0.007) - beforeRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.966 seconds (+0.026); 16.01 MB (+0.039) - afterRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.970 seconds (+0.004); 16.03 MB (+0.016) - beforeRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.982 seconds (+0.012); 16.05 MB (+0.024) - afterRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.982 seconds (+0.000); 16.05 MB (-0.003) - beforeRenderModule mod_sape (Sape Module)
Application 0.984 seconds (+0.001); 16.07 MB (+0.020) - afterRenderModule mod_sape (Sape Module)
Application 0.985 seconds (+0.001); 16.08 MB (+0.015) - beforeRenderModule mod_custom (Social Links Block - Экспорт из Coala)
Application 0.988 seconds (+0.003); 16.09 MB (+0.008) - afterRenderModule mod_custom (Social Links Block - Экспорт из Coala)
Application 0.988 seconds (+0.000); 16.06 MB (-0.027) - beforeRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.989 seconds (+0.000); 16.07 MB (+0.005) - afterRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.989 seconds (+0.000); 16.07 MB (-0.001) - beforeRenderModule mod_jlcackle (JL Cackle last comments)
Application 0.990 seconds (+0.000); 16.07 MB (+0.006) - afterRenderModule mod_jlcackle (JL Cackle last comments)
Application 0.990 seconds (+0.000); 16.07 MB (-0.003) - beforeRenderModule mod_custom (Yandex direct LEFT)
Application 0.990 seconds (+0.001); 16.08 MB (+0.004) - afterRenderModule mod_custom (Yandex direct LEFT)
Application 0.990 seconds (+0.000); 16.08 MB (+0.005) - beforeRenderModule mod_ads_elite (Ads Elite)
Application 1.398 seconds (+0.408); 16.46 MB (+0.382) - afterRenderModule mod_ads_elite (Ads Elite)
Application 1.403 seconds (+0.005); 16.49 MB (+0.024) - beforeRenderModule mod_lastupdate (mod_lastupdate)
Application 1.445 seconds (+0.042); 16.50 MB (+0.018) - afterRenderModule mod_lastupdate (mod_lastupdate)
Application 1.450 seconds (+0.005); 16.52 MB (+0.018) - beforeRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.467 seconds (+0.017); 16.59 MB (+0.067) - afterRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.469 seconds (+0.003); 16.56 MB (-0.029) - beforeRenderModule mod_flexbanners (FlexBanners)
Application 1.479 seconds (+0.009); 16.85 MB (+0.295) - afterRenderModule mod_flexbanners (FlexBanners)
Application 1.482 seconds (+0.004); 16.88 MB (+0.028) - beforeRenderModule mod_menuDU (mod_menuDU)
Application 1.517 seconds (+0.035); 17.18 MB (+0.299) - afterRenderModule mod_menuDU (mod_menuDU)
Application 1.699 seconds (+0.182); 18.08 MB (+0.898) - beforeRenderModule mod_search (Search)
Application 1.702 seconds (+0.003); 18.11 MB (+0.027) - afterRenderModule mod_search (Search)
Application 1.705 seconds (+0.003); 18.12 MB (+0.015) - beforeRenderModule mod_gtranslate (GTranslate)
Application 1.707 seconds (+0.002); 18.24 MB (+0.117) - afterRenderModule mod_gtranslate (GTranslate)
Application 1.709 seconds (+0.001); 18.13 MB (-0.110) - beforeRenderModule mod_login (Login Form)
Application 1.713 seconds (+0.004); 18.17 MB (+0.038) - afterRenderModule mod_login (Login Form)
Application 1.780 seconds (+0.067); 17.42 MB (-0.745) - afterRender
17.52 MB (18,376,112 Bytes)
DELETE
FROM `a41xo_session`
WHERE `time` < '1713561567'
SELECT `session_id`
FROM `a41xo_session`
WHERE `session_id` = '1781de42a5c57b534c76d777ec8c8717'
LIMIT 0, 1
INSERT INTO `a41xo_session`
(`session_id`, `client_id`, `time`)
VALUES
('1781de42a5c57b534c76d777ec8c8717', 0, '1713563367')
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`=1211
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`=1209
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`=1206
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`=1198
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`=1194
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`=1185
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`=1182
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`=1176
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`=1168
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`=1162
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`=1161
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`=1156
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`=1154
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`=1149
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`=1147
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`=1142
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`=1140
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`=1134
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`=1120
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`=1111
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`=1103
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`=1097
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`=1089
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`=1085
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`=1062
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`=1055
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`=1052
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`=1051
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`=1050
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`=1041
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-19 21:49:28')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 21:49:28')
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-20 00:49:28'
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-20 00:49:28'
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-20'
WHERE lastreset< '2024-04-20' 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-20'
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 ('1781de42a5c57b534c76d777ec8c8717', 0, '1713563367'
1 × DELETE
FROM `a41xo_session`