|
Санкт-Петербург:
Уважаемые любители традиционной культуры! Приглашаем Вас на первый курс традиционного плетения и ткачества. Вы овладеете старинной техникой плетения тесьмы и поясов на пальцах и простейших видов ...
Создано 10.02.2020
... великорусского языка.Сегодня многие дизайнеры интуитивно обращаются к традиционным ремеслам, пришедшим к нам из глубины веков. В Санкт-Петербурге есть люди, которые посвятили себя изучению и сбору технологий ...
Создано 10.02.2020
В рамках VIII сезона «Недели дизайна» Санкт-Петербургский Союз дизайнеров презентует экспозицию “Промдизайн: перезагрузка российской промышленности”. СПб Союз дизайнеров – ...
Создано 29.05.2018
... дизайнер интерьера, руководитель студии «DA-Studio» в городе Санкт-Петербург.
Я проектирую частные дома и квартиры с планировкой, в том числе сложной, и создаю пространства для жизни людей, ...
Создано 10.05.2018
... Русского музея.
Открытие: 22 марта 2018 г., 19:30
Адрес: Санкт-Петербург, Невский пр., 8,
Галерея «Лавка Художника»
HAUBAUS bureau
www.haubaus.ru ...
Создано 21.03.2018
1 и 2 февраля в пространстве «Среда» состоится I Санкт-Петербургский профессиональный салон тканей и фурнитуры «Открытие». Салон соберет представителей торговых марок, ...
Создано 01.02.2018
Мечтаете связать свою жизнь с творчеством? Хотите освоить профессию дизайнера для дальнейшей работы или просто получить новые полезные навыки для себя?
Приходите ...
Создано 15.01.2018
...
INSTAGRAM: bezhkolighting
ШОУ-РУМ: 199155, г. Санкт-Петербург
ул. Уральская 13, салон "Аквариус", 2 этаж
...
Создано 28.12.2017
Рынок дизайна интерьера не стоит на месте и все время движется вперед. 10 ноября отметила свое «рождение» новая светотехническая компания «BRIGHT BURO | Светодизайн и комплектация» ...
Создано 26.11.2017
... г. А.Г. Петров удостоился Золотого приза биеннале «Модулор» в Санкт-Петербурге за портативное транспортное средство РОЛЛСТИК, в 2000 г. – Большой золотой медали на ЭКСПО- 2000 в Ганновере ...
Создано 30.10.2017
Выставка-конкурс профессиональных и студенческих проектов, начиная с 1997 года.
Биеннале дизайна «Модулоп» является проектом Санкт-Петербургского Союза дизайнеров.
Биеннале ...
Создано 18.10.2017
Уважаемые коллеги! С 10 по 19 ноября, 2017 года в Санкт-Петербурге состоится Всероссийская выставка – конкурс: «Петербургская биеннале дизайна «Модулор-2017». ...
Создано 10.09.2017
Международная Школа Дизайна (Москва и С.-Петербург) объявила прием работ на международный конкурс молодых дизайнеров «Дизайн-Дебют 2017», приуроченный к 15-летнему юбилею Школы в Санкт-Петербурге. ...
Создано 10.09.2017
...
Бесплатный электронный билет >>
Организатор:
«ПРИМЭКСПО» / ITE Санкт-Петербург
Телефон: +7 (812) 380 6017/00
E-mail: Этот адрес электронной почты защищен от спам-ботов. У вас должен быть включен JavaScript для просмотра.
www.designdecor-expo.ru ...
Создано 08.09.2017
... Italia, 1972
Monica Bellucci for GQ; Milano, 2000
Mirella Petteni, Linea Italiana, 1967
Музей современного искусства Эрарта
Санкт-Петербург, 29-я линия В.О., 2
+7 (812) ...
Создано 05.09.2017
... Countach
Lamborghini Aventador
Lamborghini Aventador
Музей современного искусства Эрарта
Санкт-Петербург, 29-я ...
Создано 24.08.2017
9 сентября в выставочном зале художественной школы Кронштадта запускается дизайн - проект «Культура быта. Север». Это событие анонсирует создание нового центра современного дизайна в рамках ...
Создано 24.08.2017
...
Организатор:
«ПРИМЭКСПО» / ITE Санкт-Петербург
Телефон: +7 (812) 380 6017/00
E-mail: Этот адрес электронной почты защищен от спам-ботов. У вас должен быть включен JavaScript для просмотра.
www.designdecor-expo.ru
...
Создано 07.08.2017
Дорогие друзья! В креативном пространстве «Мойка-8» Санкт-Петербургского Союза дизайнеров начала работу «Лавка дизайнера»
Вашему ...
Создано 10.07.2017
...
Люди, которые находятся внутри профессии. В Санкт-Петербурге это, пожалуй, первая структурированная программа такого уровня и направления. Большинство участников впервые выступают перед аудиторией ...
Создано 03.07.2017
В Санкт-Петербурге, дизайнерской компанией «Модулор» при поддержке СПб Союза дизайнеров, создан Высший Художественно-Технический Институт. Новая образовательная организация названа ...
Создано 27.06.2017
... представителями творческой интеллигенции, звездами российского дизайна и архитектуры.
Люди, которые находятся внутри профессии. В Санкт-Петербурге это, пожалуй, первая структурированная программа ...
Создано 22.06.2017
Главное дизайн-событие года пройдет в Санкт-Петербурге с 31 мая по 7 июня на абсолютно новой для города площадке ARTPLAY SPb. В программе – модные показы и светские мероприятия, лекции и мастер-классы, ...
Создано 26.05.2017
7 июня в 20:00 мы проведем онлайн-встречу специально для дизайнеров интерьера, а так же для графических и промышленных дизайнеров, на которой Вы узнаете о продвижении ваших услуг и привлечении ...
Создано 25.05.2017
Меморандум участников первого регионального «Форсайт-флота — 2017» в Санкт-Петербурге «Образ будущего Санкт-Петербурга в эпоху цифровой трансформации»
...
Создано 22.05.2017
... команда выбрала территорию Петровского острова в Санкт-Петербурге, предложив городу яркое концептуальное решение по созданию нового субцентра – «Обитаемый остров».
...
Создано 19.05.2017
... и эпилогом. Часть 1. Мировой опыт. Часть 2. Личный опыт.
Лекция состоится в Санкт-Петербургском Государственном Университете. Здание Двенадцати коллегий. Петровский зал. ...
Создано 24.04.2017
... Приобрести понравившиеся модели можно в шоу-руме бренда в Санкт-Петербурге по адресу Невский проспект 60, в музеях Фаберже, Государственном Эрмитаже, Русском музее и Третьяковской галерее, в Bosco Family ...
Создано 23.04.2017
... основало традицию творческих встреч с представителями творческой интеллигенции, звездами российского дизайна и архитектуры.
Люди, которые находятся внутри профессии. В Санкт-Петербурге это, пожалуй, ...
Создано 16.04.2017
... с представителями творческой интеллигенции, звездами российского дизайна и архитектуры.
Люди, которые находятся внутри профессии. В Санкт-Петербурге это, пожалуй, первая структурированная программа ...
Создано 27.03.2017
|
session.client.forwarded ⇒ 18.223.205.61
session.client.browser ⇒ claudebot
password_clear ⇒
groups ⇒
session.token ⇒ e6ccfdea47b8d6e99c48c194864875c7
files ⇒
Application 0.000 seconds (+0.000); 0.68 MB (+0.683) - afterLoad
Application 0.086 seconds (+0.086); 9.94 MB (+9.254) - afterInitialise
Application 0.098 seconds (+0.013); 10.71 MB (+0.778) - afterRoute
Application 0.765 seconds (+0.667); 15.21 MB (+4.497) - afterDispatch
Application 0.777 seconds (+0.012); 16.16 MB (+0.953) - beforeRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.784 seconds (+0.007); 16.52 MB (+0.358) - afterRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.787 seconds (+0.003); 16.50 MB (-0.026) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.791 seconds (+0.003); 16.57 MB (+0.074) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.798 seconds (+0.007); 16.59 MB (+0.024) - beforeRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.810 seconds (+0.012); 16.62 MB (+0.024) - afterRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.810 seconds (+0.000); 16.62 MB (-0.003) - beforeRenderModule mod_sape (Sape Module)
Application 0.811 seconds (+0.001); 16.64 MB (+0.020) - afterRenderModule mod_sape (Sape Module)
Application 0.811 seconds (+0.000); 16.63 MB (-0.007) - beforeRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.812 seconds (+0.000); 16.63 MB (+0.005) - afterRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.812 seconds (+0.000); 16.63 MB (-0.001) - beforeRenderModule mod_custom (Yandex direct LEFT)
Application 0.814 seconds (+0.003); 16.64 MB (+0.008) - afterRenderModule mod_custom (Yandex direct LEFT)
Application 0.814 seconds (+0.000); 16.65 MB (+0.005) - beforeRenderModule mod_ads_elite (Ads Elite)
Application 1.095 seconds (+0.281); 17.03 MB (+0.385) - afterRenderModule mod_ads_elite (Ads Elite)
Application 1.110 seconds (+0.015); 17.05 MB (+0.023) - beforeRenderModule mod_lastupdate (mod_lastupdate)
Application 1.156 seconds (+0.046); 17.07 MB (+0.018) - afterRenderModule mod_lastupdate (mod_lastupdate)
Application 1.161 seconds (+0.005); 17.09 MB (+0.018) - beforeRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.177 seconds (+0.016); 17.17 MB (+0.075) - afterRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.181 seconds (+0.004); 17.12 MB (-0.043) - beforeRenderModule mod_flexbanners (FlexBanners)
Application 1.187 seconds (+0.006); 17.42 MB (+0.295) - afterRenderModule mod_flexbanners (FlexBanners)
Application 1.191 seconds (+0.004); 17.45 MB (+0.027) - beforeRenderModule mod_menuDU (mod_menuDU)
Application 1.222 seconds (+0.030); 17.75 MB (+0.301) - afterRenderModule mod_menuDU (mod_menuDU)
Application 1.484 seconds (+0.262); 18.88 MB (+1.130) - beforeRenderModule mod_search (Search)
Application 1.488 seconds (+0.004); 18.90 MB (+0.027) - afterRenderModule mod_search (Search)
Application 1.491 seconds (+0.003); 18.89 MB (-0.017) - beforeRenderModule mod_login (Login Form)
Application 1.495 seconds (+0.004); 18.92 MB (+0.038) - afterRenderModule mod_login (Login Form)
Application 1.585 seconds (+0.089); 17.77 MB (-1.153) - afterRender
17.98 MB (18,854,320 Bytes)
DELETE
FROM `a41xo_session`
WHERE `time` < '1713439063'
SELECT `session_id`
FROM `a41xo_session`
WHERE `session_id` = '636b2efa78bb22f23e2823544ee9b586'
LIMIT 0, 1
INSERT INTO `a41xo_session`
(`session_id`, `client_id`, `time`)
VALUES
('636b2efa78bb22f23e2823544ee9b586', 0, '1713440863')
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 (21)
GROUP BY m.oid
SELECT m.item_id
FROM a41xo_tortags AS m
WHERE m.tid IN (21)
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 (2382,2359,2376,2356,2350,2346,2343,2347,2342,2338,2337,2327,2333,2325,2320,2324,2323,2321,2319,2318,2316,2315,2314,2305,2304,2298,2297,2295,2290,2285,2281,2275,2276,2277,2263,2267,2268,2262,2255,2253,2248,2250,2249,2247,2238,2236,2232,2230,2229,2223,2221,2218,2216,2212,2210,2208,2207,2202,2194,2193,2192,2189,2184,2182,2178,2175,2169,2168,2160,2156,2154,2153,2148,2146,2143,2142,2141,2140,2139,2127,2123,2117,2109,2108,2107,2103,2101,2100,2098,2097,2093,2087,2086,2082,2077,2075,2054,2053,2052,2043,2038,2037,2025,2021,2019,2018,2017,1984,1981,1971,1968,1967,1966,1964,1963,1957,1956,1954,1952,1946,1943,1941,1940,1939,1795,1791,1935,1931,1929,1924,1908,1907,1906,1903,1896,1895,1892,1888,1884,1883,1882,1877,1869,1864,1844,1839,1835,1834,1830,1832,1829,1828,1821,1819,1815,1805,1804,1800,1799,1765,1764,1760,1761,1757,1755,1753,1750,1710,1749,1748,1744,1741,1732,1731,1729,1723,1727,1720,1719,1713,1707,1706,1705,1703,1694,1702,1701,1698,1692,1693,1685,1687,1686,1675,1676,1667,1650,1663,1660,1638,1637,1636,1628,1622,1621,1619,1599,1584,1585,1588,1589,1575,1580,1582,1571,1570,1543,1567,1566,1565,1563,1554,1555,1540,1539,1535,1534,1526,1524,1517,1514,1507,1513,1512,1506,1501,1499,1487,1492,1478,1469,1482,1480,1471,1463,1462,1451,1460,1452,1448,1437,1435,1432,1427,1419,1413,1412,1409,1407,1398,1397,1391,1388,1386,1382,1376,1371,1368,1367,1366,1363,1358,1348,1345,1343,1322,1333,1327,1326,1323,1304,1294,1290,1284,1272,1262,1263,1261,1251,1250,1245,1223,1244,1243,1240,1239,1236,1241,1242,1235,1233,1230,1225,1218,1217,1211,1214,1213,1212,1209,1202,1201,1198,1195,1174,1189,1185,1186,1180,1179,1178,1173,1168,1163,1162,1161,1154,1153,1149,1145,1147,1138,1142,1143,1123,1133,1131,1126,1124,1120,1111,1110,1102,1098,1097,1091,1089,1088,1073,1069,1068,1065,1064,1062,1061,1060,1056,1053,1052,1047,1046,1041,1038,1032,1033,1028,1014,1016,1017,1015,1010,1002,977,974,972,958,957,955,949,947,945,944,943,939,938,936,916,920,919,917,915,913,907,904,903,902,899,898,889,897,896,892,891,887,886,885,879,878,875,872,869,863,861,862,859,848,844,846,845,842,840,839,838,836,834,832,829,831,830,826,821,820,817,816,814,811,810,809,806,805,803,799,502,494,489,476,475,466,460,457,456,449,447,444,443,442,440,427,425,424,417,415,405,402,404,403,385,365,364,358,344,343,329,324,322,316,314,313,304,302,298,297,294,289,284,283,282,280,277,274,273,259,254,242,237,236,235,225,224,221,183,180,179,177,176,174,169,166,158,155,154,146,144,142,120,119,114,102,101,89,2405,2404,2392,2365,2174,2415,2426,2429,2454,2471,2470,2476,59,2478,2479,2482,2481,2507,2510,1980,1722,409,2524,2531,2530,2535,2539,2540,2112,1920,1917,2542,2548,2549,2557,2561,2563,2567,2566,2570,2582,2590,2593,2602,2638,2639,2648,2656,2658,2663,2664,2666,2671,2672,2688,2690,2694,2696,2707,2714,2718,2719,2720,2733,2748,2743,2756,2769,2782,2783,2799,2818,2835,2836,2839,2855,2856,2862,2864,2866,2863,2879,2889,2893,2896,2897,2901,2902,2903,2906,2909,2916,2923,2924,2945,2962,2966,2978,2990,2994,2993,3025,3026,3032,3036,3044,3045,3047,3048,3049,3050,3051,3053,3063,3067,3073,3077,3078,3080,3085,3087,3088,3091,3093,2592,1969,484,3101,3103,3118,3115,2076,2080,2384,3122,3124,3125,3126,2580,3137,128,2283,2583,3140,3145,3155,3158,3164,3168,3180,3179,3181,3188,3202,3207,3208,3209,3217,3219,3226,3227,3228,3231,3238,3239,3240,3251,3250,3252,3254,3266,3269,3270,3271,3273,3279,3282,3283,3288,3295,3309,3310,3312,3319,3323,3327,3328,3334,3337,3338,3339,3341,3345,3349,3355,3357,3361,3363,3367,3375,3392,3393,3395,3403,3404,3405,3407,3408,3413,3416,3417,3419,3420,3421,3422,3423,3424,3427,3431,3432,3435,3437,3438,3440,3443,3445,3448,3449,3451,3455,3459,3460,3465,3467,3469,3470,3473,3474,3475,3477,3481,3486,3487,3492,3493,3494,3495,3500,3504,3506,3507,3508,3510,3514,3518,3519,3552,3553)
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=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=123
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=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=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=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=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=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=109
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=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=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=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=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=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=143
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=112
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=90
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM a41xo_categories as c
LEFT JOIN a41xo_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM a41xo_categories AS cat JOIN a41xo_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=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=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=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=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=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=154
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=106
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=99
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 (21)
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 (11250)
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`=3553
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`=3552
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`=3519
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`=3518
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`=3514
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`=3510
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`=3508
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`=3507
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`=3506
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`=3504
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3500
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3495
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3494
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3493
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`=3492
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`=3487
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`=3486
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`=3481
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`=3477
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`=3475
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`=3474
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`=3473
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`=3470
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`=3469
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`=3467
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3465
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT *
FROM `a41xo_sitelinkx_config`
SELECT *
FROM `a41xo_sitelinkx`
ORDER BY wort
SELECT `component`
FROM `a41xo_tortags_components`
SELECT `component`
FROM `a41xo_tortags_components`
WHERE `id`='1'
SELECT `t`.*
FROM `a41xo_tortags_tags` AS `t`
INNER JOIN `a41xo_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=3460
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`=3459
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`=3455
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`=3451
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-18 11:47:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 11:47:44')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 845 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT html
FROM a41xo_odude_profile_field
WHERE name='design';
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-18 14:47:44'
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-18 14:47:44'
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-18'
WHERE lastreset< '2024-04-18' 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"
32 × SELECT `component`
FROM `a41xo_tortags_components
30 × SELECT *
FROM `a41xo_sitelinkx_config
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`
30 × SELECT *
FROM `a41xo_sitelinkx`
29 × 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
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 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 `asset_id` AS `id`,`name` AS `title`,`description` AS `text`,`owner` AS `created`
FROM a41xo_joomgallery_catg 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 m.oid
FROM a41xo_tortags AS m
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM a41xo_menu AS m
LEFT JOIN a41xo_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `session_id`
FROM `a41xo_session`
1 × SELECT t.id
FROM a41xo_tortags_tags AS t
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 id, rules
FROM `a41xo_viewlevels
1 × SELECT html
FROM a41xo_odude_profile_field
1 × UPDATE `a41xo_flexbanners`
SET state=1
1 × UPDATE `a41xo_flexbanners`
SET dailyimpressions=0, lastreset='2024-04-18'
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 ('636b2efa78bb22f23e2823544ee9b586', 0, '1713440863'
1 × DELETE
FROM `a41xo_session`