SELECT *
FROM jlov_session
WHERE session_id = '75e5399893f43bcc369681fb55145899'
DELETE
FROM jlov_session
WHERE ( TIME < '1524363756' )
SELECT *
FROM jlov_session
WHERE session_id = '75e5399893f43bcc369681fb55145899'
INSERT INTO `jlov_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '75e5399893f43bcc369681fb55145899','1524364656','','0','1','0' )
SELECT *
FROM jlov_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jlov_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT `id`,`link`
FROM jlov_menu
WHERE ((`name` LIKE '%turisticheskie marshruty%')
AND (`published` > 0))
SELECT oldurl, newurl
FROM jlov_redirection
WHERE oldurl = 'turisticheskie-marshruty/novosti/'
ORDER BY rank ASC
LIMIT 1
UPDATE jlov_redirection
SET cpt=(cpt+1)
WHERE `newurl` = 'index.php?option=com_content&Itemid=1131&id=31&lang=ru&layout=blog&view=category'
AND `oldurl` = 'turisticheskie-marshruty/novosti/'
SELECT template
FROM jlov_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1131)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jlov_categories AS c
INNER JOIN jlov_sections AS s
ON s.id = c.SECTION
WHERE c.id = 31
LIMIT 0, 1
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jlov_content AS a
LEFT JOIN jlov_categories AS cc
ON a.catid = cc.id
LEFT JOIN jlov_users AS u
ON u.id = a.created_by
LEFT JOIN jlov_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 31
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-22 02:37:36' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-04-22 02:37:36' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 6
SELECT cc.title AS category, a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email
FROM jlov_content AS a
LEFT JOIN jlov_categories AS cc
ON a.catid = cc.id
LEFT JOIN jlov_users AS u
ON u.id = a.created_by
LEFT JOIN jlov_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 31
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-22 02:37:36' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-04-22 02:37:36' )
ORDER BY a.created DESC, a.created DESC
SELECT title
FROM jlov_content
WHERE publish_up < NOW()
AND catid= 31
ORDER BY id DESC
LIMIT 0,5
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_jcomments&format=raw&lang=ru&object_group=com_content&object_id=984&task=rss'
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_jcomments&format=raw&lang=ru&object_group=com_content&object_id=983&task=rss'
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_jcomments&format=raw&lang=ru&object_group=com_content&object_id=981&task=rss'
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_jcomments&format=raw&lang=ru&object_group=com_content&object_id=979&task=rss'
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_jcomments&format=raw&lang=ru&object_group=com_content&object_id=980&task=rss'
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_jcomments&format=raw&lang=ru&object_group=com_content&object_id=978&task=rss'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jlov_modules AS m
LEFT JOIN jlov_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 = 1131 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
jlov_categories AS c
LEFT JOIN
jlov_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jlov_content AS content
ON
c.id = content.catid
WHERE
( c.id = 30 )
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
jlov_content AS content
LEFT JOIN
jlov_categories AS categories
ON categories.id = content.catid
LEFT JOIN
jlov_sections AS sections
ON sections.id = content.sectionid
LEFT JOIN
jlov_menu AS menu
ON menu.componentid = content.id
LEFT JOIN
jlov_users AS users
ON users.id = content.created_by
LEFT JOIN
jlov_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
jlov_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 <= '2018-04-2202:37:37' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2018-04-2202:37:37' )
AND ( content.catid = 30 )
AND frontpage.content_id IS NULL
ORDER BY
RAND()
LIMIT
0,2;
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_user&lang=ru&view=register'
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jlov_categories AS c
LEFT JOIN
jlov_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jlov_content AS content
ON
c.id = content.catid
WHERE
( c.SECTION = 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
jlov_content AS content
LEFT JOIN
jlov_categories AS categories
ON categories.id = content.catid
LEFT JOIN
jlov_sections AS sections
ON sections.id = content.sectionid
LEFT JOIN
jlov_menu AS menu
ON menu.componentid = content.id
LEFT JOIN
jlov_users AS users
ON users.id = content.created_by
LEFT JOIN
jlov_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
jlov_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 <= '2018-04-2202:37:37' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2018-04-2202:37:37' )
AND ( content.catid = 11 OR content.catid = 12 OR content.catid = 13 )
AND frontpage.content_id IS NULL
ORDER BY
RAND()
LIMIT
0,10;
SELECT oldurl, dateadd
FROM jlov_redirection
WHERE newurl = 'index.php?option=com_datsogallery&Itemid=1126&lang=ru'
Новости
Україна - це велика земля в якій безліч захоплюючих місць і міст для туристів. В нашій державі істотне зацікавленість людей інтригує - місто Львів.
Руководство города Алушты продолжает заниматься благоустройством города в ожидании курортного сезона 2017. С этого года убирать центральные улицы города 
Всему свое время
Нет на земле лучшего места для отдыха, чем Ялта. Она знаменита во всем мире своими живописными зелеными долинами, защищенная горами от холодных северных ветров и омываемая теплым морем с юга, а также чудесным климатом. Отдыхать в Ялту приезжали и приезжают люди со всего мира, здесь отдыхали многие знаменитые люди, которые прославили этот край в своих произведениях.
