|
Санкт-Петербург:
...
Фото: dizbook
Мероприятие проходило в рамках Saint-Petersburg Design Week 2014
Организаторы:
Санкт-Петербургский Союз дизайнеров
Cтудия FULLHOUSEDESIGN
Кураторы проекта ...
Создано 29.06.2014
... (Санкт-Петербург) Северо-западным филиалом ГЦСИ при поддержке Министерства культуры РФ Государственным музеем истории Санкт-Петербурга представляют выставку «Weltformat: швейцарский плакат из Люцерна ...
Создано 19.06.2014
... коллекции Российского Этнографического музея Санкт-Петербурга, консультировались с его ведущим специалистом Дмитрием Барановым. Принципы организации пространства избы – минималистичного и эффективного ...
Создано 26.05.2014
Портал ART1. Visual daily, журнал «Проектор» и креативное пространство «Ткачи» с гордостью представляют лекцию швейцарского дизайнера Ральфа Шрайфогеля в программе Санкт-Петербургской ...
Создано 25.05.2014
...
с 12-00 до 19-00,
по адресу: Санкт-Петербург,
В.О., 6-я линия, 29
...
Создано 17.05.2014
... Тимофеев, председатель правления Санкт-Петербургского Союза Дизайнеров
Пресс-конференция состоится в конференц-зале «БалтИнфо»
по адресу: ул. Мира, д. 34 (2 этаж)
Аккредитация ...
Создано 16.05.2014
Уважаемые, коллеги! 27 мая в образовательным центре "Дом Бенуа" пройдет первая российская презентация изданной книги RUB DESIGN BOOK 2014 в рамках Санкт-Петербургской Недели Дизайна. ...
Создано 12.05.2014
Санкт-Петербургский Союз дизайнеров, Санкт-Петербургский Союз художников при поддержке Правительства Санкт-Петербурга и Координационного Совета творческих союзов Санкт-Петербурга представляют выставку ...
Создано 07.05.2014
Уважаемые, коллеги! Друзья! Приглашаем вас на творческий семинар, который пройдет 7 мая в Санкт-Петербургском Союзе дизайнеров, где , собравшись за круглым столом, будет возможность обсудить результаты ...
Создано 06.05.2014
В рамках Международного проекта «Искусство света», который пройдет с 23 по 30 мая 2014 года в Санкт-Петербурге, организаторами подготовлена образовательная программа. С расписанием событий ...
Создано 01.05.2014
... – оформление витрины реального магазина.
После этого курса, вам будет по плечу создавать витрины, которые шокируют, удивляют, продают!
12 – 17 мая, Санкт-Петербург
Стоимость ...
Создано 29.04.2014
В апреле 2014 в Манеже кадетского корпуса в рамках ST. PETERSBURG FASHION WEEK состоялся показ коллекции «Орнаменталь» фэшн-дизайнера, члена Союза Художников России Юлии Косяк.
...
Создано 28.04.2014
29 апреля в выставочном зале Санкт-Петербургского Союза Дизайнеров открывается международная выставка «FASHION UNLIMITED – МОДА БЕЗ ГРАНИЦ».
Это традиционный ежегодный смотр ...
Создано 27.04.2014
2 апреля 2014 года в Санкт-Петербургском государственном технологическом университете растительных полимеров (СПБГТУРП), на кафедре промышленного дизайна прошла защита дипломов.
Свои проекты ...
Создано 21.04.2014
18 апреля в Санкт-Петербурге состоится мастер-класс дизайнера, тренера, основателя крупнейшей on-line школы для дизайнеров — Станислава Орехова.
ПРОГРАММА МАСТЕР-КЛАССА
Выбор ...
Создано 16.04.2014
6 апреля в Манеже кадетского корпуса в рамках ST. PETERSBURG FASHION WEEK состоялся показ коллекция Татьяны Граковой «Вивальди для КПК» созданая как развитие дипломной работы, защищенной ...
Создано 14.04.2014
... коммерческой линии одежды не только не остановится, но и продолжит наращивать обороты: одеться “от Аксенова” легко получится во многих бутиках Санкт-Петербурга».
Комментируя ...
Создано 13.04.2014
Компания «Проект 111» - лидер российского рынка промопродукции и бизнес-подарков, объявляет о начале четвертого конкурса в рамках серии мероприятий G.I.F.T.S. Award. Тема нового конкурсного ...
Создано 13.04.2014
... отмечает свое совершеннолетие.
В трёх выставочных залах Санкт-Петербургского Союза дизайнеров представлены три комплексных проекта последних лет, выполненные на бумаге или с помощью бумаги: ...
Создано 10.04.2014
... публике еще по участию в Санкт-Петербургской неделе дизайна 2013.
В рамках Таркетт Дизайн Академии состоится открытая дискуссия с известными российскими дизайнерами и архитекторами. В мероприятии ...
Создано 10.04.2014
Что ж, есть, как говорится, две новости — хорошая и плохая. Начнём с первой. Судя по количеству заинтересовавшихся статьёй ТРИ МИЛЛИАРДА РУБЛЕЙ НА ПРОМЫШЛЕННЫЙ ДИЗАЙН на design-union о постановлении ...
Создано 31.03.2014
6 апреля в рамках XIV Международного фестиваля «Японская весна» в музее «Эрмитаж-Выборг» (филиал Государственного Музея Эрмитаж) при поддержке Генерального Консульства ...
Создано 27.03.2014
Международная Неделя моды в Петербурге AURORA FASHION WEEK Russia представляет первый в России фестиваль в сфере fashion & beauty AURORA MARKET, который пройдет с 12 по 13 апреля 2014 года, даст ...
Создано 27.03.2014
5 марта 2014 г. в Галерее Дизайна/bulthaup (Санкт-Петербург) прошел семинар "DESIGN EXPRESS. 3X20" для практиков архитектуры и дизайна, а также тех, кто только осваивает профессию. Темой встречи ...
Создано 14.03.2014
... фонд Woodenfish/Москва, отмечен Королевским консульством Швеции. Частные дома и апартаменты/Санкт-Петербург.
Концепт-проекты: жилой район «Технопарк» Skolkovo/Москва; реновация здания ...
Создано 20.02.2014
Каждый год, на излете зимы в СПБ Союзе Дизайнеров приходят новые люди. Приходят продемонстрировать свои профессиональные достижения, познакомиться с коллегами, услышать компетентное мнение относительно ...
Создано 31.01.2014
... свечей, а, затем, когда смолкла скрипка, была объявлена минута молчания в память о погибших в трагедии Холокоста и жертвах Блокады Ленинграда…
Санкт-Петербургский Союз дизайнеров выражает благодарность ...
Создано 30.01.2014
... по группам;
23 января 2014 года (четверг) с 18:00 до 20.00
Адрес: С-Петербург, наб. реки Мойки, д. 8.
Санкт-Петербургский Союз Дизайнеров.
Генеральный информационный партнер –
Портал ...
Создано 17.01.2014
C 26 декабря по 8 января 2014, в студии ручного творчества «Мартовский заяц» пройдет Праздничная выставка ручного творчества, «Ангелы в городе»! На выставке вы сможете окунуться ...
Создано 25.12.2013
... (г. Тула, Россия)
2. Галина Габриэль (Санкт-Петербург, Россия)
3. Мария Заборовская (Санкт-Петербург, Россия)
4. Лариса Канунникова (Санкт-Петербург, Россия)
5. Вадим Кондрашев (Санкт-Петербург, ...
Создано 13.12.2013
|
session.client.forwarded ⇒ 18.223.160.61
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
session.token ⇒ 69cba13d7b4e6ca2036fec0a329be901
files ⇒
Application 0.000 seconds (+0.000); 0.61 MB (+0.612) - afterLoad
Application 0.074 seconds (+0.074); 9.12 MB (+8.503) - afterInitialise
Application 0.082 seconds (+0.008); 9.77 MB (+0.653) - afterRoute
Application 0.731 seconds (+0.649); 13.94 MB (+4.175) - afterDispatch
Application 0.742 seconds (+0.011); 14.90 MB (+0.955) - beforeRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.748 seconds (+0.006); 15.26 MB (+0.359) - afterRenderModule mod_cdc_jfloating_bar (CDC J Floating Bar)
Application 0.751 seconds (+0.003); 15.23 MB (-0.026) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.754 seconds (+0.003); 15.31 MB (+0.076) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.754 seconds (+0.000); 15.30 MB (-0.008) - beforeRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.795 seconds (+0.040); 15.34 MB (+0.039) - afterRenderModule mod_tortags_often_clouds (mod_tortags_often_clouds)
Application 0.803 seconds (+0.008); 15.36 MB (+0.016) - beforeRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.814 seconds (+0.011); 15.38 MB (+0.024) - afterRenderModule mod_brilliant_instajoom (INSTAGRAM CHANEL)
Application 0.814 seconds (+0.000); 15.38 MB (-0.003) - beforeRenderModule mod_sape (Sape Module)
Application 0.815 seconds (+0.001); 15.40 MB (+0.020) - afterRenderModule mod_sape (Sape Module)
Application 0.816 seconds (+0.000); 15.39 MB (-0.007) - beforeRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.816 seconds (+0.000); 15.40 MB (+0.006) - afterRenderModule mod_myextpagetitle (mod_myextpagetitle)
Application 0.816 seconds (+0.000); 15.39 MB (-0.001) - beforeRenderModule mod_jlcackle (JL Cackle last comments)
Application 0.816 seconds (+0.000); 15.40 MB (+0.007) - afterRenderModule mod_jlcackle (JL Cackle last comments)
Application 0.817 seconds (+0.000); 15.40 MB (-0.003) - beforeRenderModule mod_custom (Yandex direct LEFT)
Application 0.819 seconds (+0.002); 15.41 MB (+0.008) - afterRenderModule mod_custom (Yandex direct LEFT)
Application 0.819 seconds (+0.000); 15.41 MB (+0.005) - beforeRenderModule mod_ads_elite (Ads Elite)
Application 1.103 seconds (+0.284); 15.80 MB (+0.384) - afterRenderModule mod_ads_elite (Ads Elite)
Application 1.113 seconds (+0.010); 15.82 MB (+0.024) - beforeRenderModule mod_lastupdate (mod_lastupdate)
Application 1.155 seconds (+0.042); 15.84 MB (+0.018) - afterRenderModule mod_lastupdate (mod_lastupdate)
Application 1.161 seconds (+0.005); 15.85 MB (+0.018) - beforeRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.176 seconds (+0.015); 15.94 MB (+0.081) - afterRenderModule mod_imagebar_DU (mod_imagebar_DU)
Application 1.179 seconds (+0.003); 15.89 MB (-0.043) - beforeRenderModule mod_flexbanners (FlexBanners)
Application 1.184 seconds (+0.005); 16.19 MB (+0.294) - afterRenderModule mod_flexbanners (FlexBanners)
Application 1.389 seconds (+0.204); 16.95 MB (+0.763) - beforeRenderModule mod_login (Login Form)
Application 1.393 seconds (+0.004); 16.99 MB (+0.039) - afterRenderModule mod_login (Login Form)
Application 1.468 seconds (+0.075); 16.19 MB (-0.798) - afterRender
16.35 MB (17,140,312 Bytes)
SELECT `session_id`
FROM `a41xo_session`
WHERE `session_id` = 'a38d552205caa0831399fe780da36cf4'
LIMIT 0, 1
INSERT INTO `a41xo_session`
(`session_id`, `client_id`, `time`)
VALUES
('a38d552205caa0831399fe780da36cf4', 0, '1714091428')
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`=2962
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`=2945
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`=2924
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`=2923
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`=2916
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`=2909
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`=2906
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`=2903
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`=2901
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`=2897
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`=2896
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`=2893
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`=2889
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`=2879
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`=2866
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`=2864
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`=2863
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`=2862
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`=2856
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`=2855
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`=2839
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`=2836
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`=2835
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`=2818
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`=2799
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`=2783
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`=2782
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`=2769
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`=2756
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`=2748
AND `m`.`oid`=1
ORDER BY `t`.`title` ASC
SELECT html
FROM a41xo_odude_profile_field
WHERE name='design';
SELECT '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM a41xo_tortags x, a41xo_tortags_tags t
WHERE t.`id`=x.`tid`
GROUP BY t.`id`
LIMIT 20
SELECT *
FROM a41xo_users as u
LEFT JOIN a41xo_user_usergroup_map as ug
on u.id = ug.user_id
WHERE u.id=0
SELECT count(*) as v
FROM a41xo_vflow_data
SELECT count(*) as v
FROM a41xo_joomgallery
SELECT count(*) as v
FROM a41xo_content
SELECT `a41xo_vflow_data`.*
FROM ( SELECT id
FROM `a41xo_vflow_data`
ORDER BY RAND()
LIMIT 2) as ids JOIN `a41xo_vflow_data`
ON `a41xo_vflow_data`.id = ids.id
SELECT *
from
( SELECT id
FROM `a41xo_joomgallery`
WHERE published = 1
ORDER BY RAND()
LIMIT 2) as j
join `a41xo_joomgallery`
on a41xo_joomgallery.id = j.id
JOIN `a41xo_joomgallery_catg`
ON catid = cid;
SELECT `a41xo_content`.*
FROM ( SELECT id
FROM `a41xo_content`
ORDER BY RAND()
LIMIT 2) as ids JOIN `a41xo_content`
ON `a41xo_content`.id = ids.id
where state = 1
UPDATE `a41xo_flexbanners`
SET finished=1, state=0
WHERE (enddate < '2024-04-26 03:30:29'
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-26 03:30:29'
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-26'
WHERE lastreset< '2024-04-26' 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 html
FROM a41xo_odude_profile_field
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 '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM a41xo_tortags x, a41xo_tortags_tags t
1 × UPDATE `a41xo_flexbanners`
SET dailyimpressions=0, lastreset='2024-04-26'
1 × UPDATE `a41xo_flexbanners`
SET state=1
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 ('a38d552205caa0831399fe780da36cf4', 0, '1714091428'