DELETE
FROM jos_session
WHERE ( TIME < '1722060637' )
SELECT *
FROM jos_session
WHERE session_id = 'tm4mqk0rte98jl7enopkcrk794'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'tm4mqk0rte98jl7enopkcrk794','1722061537','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT id
FROM jos_plugins
WHERE element = 'u24_je_plg_lytebox'
AND folder = 'system'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext, a.fulltext) AS text, CONCAT_WS( "/", u.title, b.title ) AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid, "2" AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b
ON b.id=a.catid
INNER JOIN jos_sections AS u
ON u.id = a.sectionid
WHERE ( (a.title LIKE '%плакаты%' OR a.introtext LIKE '%плакаты%' OR a.fulltext LIKE '%плакаты%' OR a.metakey LIKE '%плакаты%' OR a.metadesc LIKE '%плакаты%') )
AND a.state = 1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 06:25:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 06:25:37' )
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 0, 50
SELECT id, a.title AS title, a.created AS created, a.metadesc, a.metakey, CONCAT(a.introtext, a.fulltext) AS text, "2" AS browsernav, "Материалы без категорий" AS SECTION
FROM jos_content AS a
WHERE ((a.title LIKE '%плакаты%' OR a.introtext LIKE '%плакаты%' OR a.fulltext LIKE '%плакаты%' OR a.metakey LIKE '%плакаты%' OR a.metadesc LIKE '%плакаты%'))
AND a.state = 1
AND a.access <= 0
AND a.sectionid = 0
AND a.catid = 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 06:25:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 06:25:37' )
ORDER BY a.created DESC
LIMIT 0, 23
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext, a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid, CONCAT_WS( "/", u.title, b.title ) AS SECTION, "2" AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b
ON b.id=a.catid
AND b.access <= 0
INNER JOIN jos_sections AS u
ON u.id = a.sectionid
WHERE ( (a.title LIKE '%плакаты%' OR a.introtext LIKE '%плакаты%' OR a.fulltext LIKE '%плакаты%' OR a.metakey LIKE '%плакаты%' OR a.metadesc LIKE '%плакаты%') )
AND a.state = -1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 06:25:37' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 06:25:37' )
ORDER BY a.created DESC
LIMIT 0, 17
SELECT *
FROM jos_tagmeta
WHERE ('/index.php/component/search/?areas%5B0%5D=content&searchphrase=all&searchword=%D0%BF%D0%BB%D0%B0%D0%BA%D0%B0%D1%82%D1%8B+%D0%BF%D0%BE+%D0%9E%D0%A2' REGEXP uri)>0
AND published='1'
ORDER BY ordering
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 0 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.id = 2 )
AND
c.published = 1
AND
c.access <= 0;
SELECT DISTINCT
cats.title AS cat,
users.name AS author,
cats.SECTION AS SID,
content.title AS title,
content.introtext AS text,
content.created AS DATE,
content.images AS images,
content.id AS IID,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END AS ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", cats.id, cats.alias)
ELSE cats.id END AS CID
FROM
jos_content AS content
LEFT JOIN
jos_categories AS categories
ON categories.id = content.catid
LEFT JOIN
jos_sections AS sections
ON sections.id = content.sectionid
LEFT JOIN
jos_menu AS menu
ON menu.componentid = content.id
LEFT JOIN
jos_users AS users
ON users.id = content.created_by
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
jos_categories AS cats
ON content.catid = cats.id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2024-07-27 06:25:37' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2024-07-27 06:25:37' )
AND ( content.catid = 2 )
ORDER BY
content.created DESC
LIMIT
0,6;
