Путеводитель. Канада

Информация о профиле

Использование памяти

Зарегистрировано запросов: 192

1. SELECT *
     FROM jlov_session
     WHERE session_id = 'd235fa3499788b40d3dd055c2678d921'
2. DELETE
     FROM jlov_session
     WHERE ( TIME < '1524364329' )
3. SELECT *
     FROM jlov_session
     WHERE session_id = 'd235fa3499788b40d3dd055c2678d921'
4. INSERT INTO `jlov_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'd235fa3499788b40d3dd055c2678d921','1524365229','','0','1','0' )
5. SELECT *
     FROM jlov_components
     WHERE parent = 0
6. SELECT folder AS TYPE, element AS name, params
     FROM jlov_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT `id`,`link`
     FROM jlov_menu  
     WHERE ((`name` LIKE '%karta saita.html%')
     AND (`published` > 0))
8. SELECT oldurl, newurl
     FROM jlov_redirection
     WHERE oldurl = 'karta-saita.html'
     ORDER BY rank ASC
     LIMIT 1
9. UPDATE jlov_redirection
     SET cpt=(cpt+1)
     WHERE `newurl` = 'index.php?option=com_xmap&Itemid=1041&lang=ru&sitemap=1'
     AND `oldurl` = 'karta-saita.html'
10. SELECT *
      FROM jlov_xmap
11. SELECT *
      FROM jlov_menu
      WHERE id = '1041'
12. SELECT *
      FROM `jlov_xmap_sitemap`
      WHERE id=1
13. SELECT *
      FROM `jlov_xmap_ext`
      WHERE `published`=1
      AND extension NOT LIKE '%.bak'
14. SELECT *
      FROM jlov_menu
      WHERE id = '1041'
15. SELECT *
      FROM jlov_modules
      WHERE published='1'
      AND module='mod_mainmenu'
      AND params LIKE '%menutype=mainmenu%'
16. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=0
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
17. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
18. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1073
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
19. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1119
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
20. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '2'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
21. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(11)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
22. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(12)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
23. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(13)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
24. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1120
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
25. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '3'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
26. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(14)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
27. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(15)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
28. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(16)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
29. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(17)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
30. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(18)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
31. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(19)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
32. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(20)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
33. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1121
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
34. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '4'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
35. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(21)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
36. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(22)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
37. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(23)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
38. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(24)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
39. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(25)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
40. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1122
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
41. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '5'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
42. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(26)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
43. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(27)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
44. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(28)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
45. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1128
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
46. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1041
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
47. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1134
      AND m.menutype = 'mainmenu'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
48. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(32)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
49. SELECT *
      FROM jlov_modules
      WHERE published='1'
      AND module='mod_mainmenu'
      AND params LIKE '%menutype=menubig%'
50. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=0
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
51. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1042
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
52. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1047
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
53. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(11)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
54. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1048
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
55. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(12)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
56. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1049
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
57. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(13)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
58. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '2'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
59. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1043
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
60. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1050
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
61. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(14)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
62. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1051
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
63. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(15)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
64. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1052
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
65. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(16)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
66. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1053
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
67. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(17)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
68. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1054
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
69. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(18)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
70. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1055
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
71. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(19)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
72. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1056
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
73. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(20)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
74. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '3'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
75. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1044
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
76. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1057
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
77. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(21)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
78. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1058
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
79. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(22)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
80. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1059
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
81. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(23)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
82. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1060
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
83. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(24)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
84. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1061
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
85. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(25)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
86. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '4'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
87. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1045
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
88. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1062
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
89. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(26)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
90. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1063
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
91. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(27)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
92. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1064
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
93. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(28)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
94. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
     
      FROM jlov_categories AS a
     
      LEFT JOIN jlov_content AS b
      ON b.catid = a.id
     
      AND b.state = '1'
     
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
     
      AND b.access <= 0
     
      WHERE a.SECTION = '5'
     
      AND a.published = '1'
     
      AND a.access <= 0
     
      GROUP BY a.id
     
      HAVING COUNT( b.id ) > 0
     
      ORDER BY a.ordering
95. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1046
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
96. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1065
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
97. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(29)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
98. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
     
      FROM jlov_menu AS m
     
      LEFT JOIN jlov_components AS c
      ON m.TYPE='components'
      AND c.id=m.componentid
     
      WHERE m.published='1'
      AND m.parent=1066
      AND m.menutype = 'menubig'
     
      AND m.access <= '0'
     
      ORDER BY m.menutype,m.parent,m.ordering
99. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
     
      FROM jlov_content AS a,jlov_categories AS c
     
      WHERE a.catid=(30)
     
      AND a.catid=c.id
     
      AND a.state='1'
     
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
     
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
     
      AND a.access<='0'
     
      ORDER BY a.created DESC
100. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1130
       AND m.menutype = 'menubig'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
101. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.catid=(31)
      
       AND a.catid=c.id
      
       AND a.state='1'
      
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
      
       AND a.access<='0'
      
       ORDER BY a.created DESC
102. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
      
       FROM jlov_categories AS a
      
       LEFT JOIN jlov_content AS b
       ON b.catid = a.id
      
       AND b.state = '1'
      
       AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
      
       AND b.access <= 0
      
       WHERE a.SECTION = '6'
      
       AND a.published = '1'
      
       AND a.access <= 0
      
       GROUP BY a.id
      
       HAVING COUNT( b.id ) > 0
      
       ORDER BY a.ordering
103. SELECT oldurl, dateadd
       FROM jlov_redirection
       WHERE newurl = 'index.php?option=com_datsogallery&Itemid=1127&lang=ru'
104. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1127
       AND m.menutype = 'menubig'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
105. SELECT *
       FROM jlov_modules
       WHERE published='1'
       AND module='mod_mainmenu'
       AND params LIKE '%menutype=menuverhnee%'
106. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=0
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
107. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1072
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
108. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1094
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
109. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1099
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
110. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.catid=(11)
      
       AND a.catid=c.id
      
       AND a.state='1'
      
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
      
       AND a.access<='0'
      
       ORDER BY a.created DESC
111. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1100
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
112. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.catid=(12)
      
       AND a.catid=c.id
      
       AND a.state='1'
      
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
      
       AND a.access<='0'
      
       ORDER BY a.created DESC
113. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1101
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
114. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.catid=(13)
      
       AND a.catid=c.id
      
       AND a.state='1'
      
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
      
       AND a.access<='0'
      
       ORDER BY a.created DESC
115. SELECT a.id, a.title, a.name, a.params,a.SECTION,a.alias,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
      
       FROM jlov_categories AS a
      
       LEFT JOIN jlov_content AS b
       ON b.catid = a.id
      
       AND b.state = '1'
      
       AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-04-22 06:47:09' )
      
       AND b.access <= 0
      
       WHERE a.SECTION = '2'
      
       AND a.published = '1'
      
       AND a.access <= 0
      
       GROUP BY a.id
      
       HAVING COUNT( b.id ) > 0
      
       ORDER BY a.ordering
116. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1095
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
117. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1102
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
118. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.catid=(14)
      
       AND a.catid=c.id
      
       AND a.state='1'
      
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
      
       AND a.access<='0'
      
       ORDER BY a.created DESC
119. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1103
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
120. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.catid=(15)
      
       AND a.catid=c.id
      
       AND a.state='1'
      
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:47:09' )
      
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:47:09' )
      
       AND a.access<='0'
      
       ORDER BY a.created DESC
121. SELECT m.id, m.name, m.parent, m.link, m.TYPE, m.browserNav, m.menutype, m.ordering, m.params, m.componentid, c.name AS component
      
       FROM jlov_menu AS m
      
       LEFT JOIN jlov_components AS c
       ON m.TYPE='components'
       AND c.id=m.componentid
      
       WHERE m.published='1'
       AND m.parent=1104
       AND m.menutype = 'menuverhnee'
      
       AND m.access <= '0'
      
       ORDER BY m.menutype,m.parent,m.ordering
122. SELECT a.id, a.title, a.modified, a.created, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
      
       FROM jlov_content AS a,jlov_categories AS c
      
       WHERE a.