DELETE
FROM bal_session
WHERE ( time < '1328631320' )
SELECT *
FROM bal_session
WHERE session_id = '2dkblfkv5etuu5fvgnm1kkdrl2'
UPDATE `bal_session`
SET `time`='1328632220',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
WHERE session_id='2dkblfkv5etuu5fvgnm1kkdrl2'
SELECT *
FROM bal_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM bal_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT `id`,`link`
FROM bal_menu
WHERE ((`name` LIKE '%component%')
AND (`published` > 0))
SELECT m.*, c.`option` AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM bal_xmap
SELECT *
FROM bal_menu
WHERE id = '80'
SELECT *
FROM `bal_xmap_sitemap`
WHERE id=1
SELECT *
FROM bal_xmap_items
WHERE VIEW='html'
AND sitemap_id=1
SELECT *
FROM `bal_xmap_ext`
WHERE `published`=1
AND extension NOT LIKE '%.bak'
SELECT *
FROM bal_menu
WHERE id = '80'
SELECT *
FROM bal_modules
WHERE published='1'
AND module='mod_mainmenu'
AND params LIKE '%menutype=mainmenu%'
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_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
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_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
SELECT m.*, c.`option` AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=32
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '7'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(44)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=66
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '13'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(52)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=26
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(42)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=31
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=60
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(50)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=54
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(41)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=55
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(40)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
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
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(49)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=63
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '12'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(51)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=51
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=70
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(47)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=72
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(57)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=71
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(58)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '10'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=67
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=73
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(55)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=74
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(59)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '15'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=64
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=57
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(37)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=58
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(38)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '9'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=47
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '8'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(45)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=68
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '16'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(56)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=65
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=75
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(53)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=76
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(60)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '14'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=30
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(43)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=78
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '17'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(61)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(65)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(66)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(72)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(75)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(67)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(70)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(71)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(76)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=79
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
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 bal_categories AS a
LEFT JOIN bal_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 <= '2012-02-07 16:30:21' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-07 16:30:21' )
AND b.access <= 0
WHERE a.section = '18'
AND a.published = '1'
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(63)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT a.id, a.title, a.metakey, 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 bal_content AS a,bal_categories AS c
WHERE a.catid=(69)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-07 16:30:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-07 16:30:21' )
AND a.access<='0'
ORDER BY a.created DESC
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=80
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT oldurl, dateadd
FROM bal_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=81&lang=en&view=archive'
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=81
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
SELECT oldurl, dateadd
FROM bal_redirection
WHERE newurl = 'index.php?option=com_search&Itemid=82&lang=en&view=search'
SELECT m.id, m.name, m.parent, m.link, m.type, m.browserNav, m.menutype, m.ordering, m.params, m.componentid,m.home, c.name AS component
FROM bal_menu AS m
LEFT JOIN bal_components AS c
ON m.type='components'
AND c.id=m.componentid
WHERE m.published='1'
AND m.parent=82
AND m.menutype = 'mainmenu'
AND m.access <= '0'
ORDER BY m.menutype,m.parent,m.ordering
UPDATE bal_xmap_sitemap
SET `name`='New Sitemap',`expand_category`='0',`expand_section`='0',`show_menutitle`='1',`columns`='2',`exlinks`='1',`ext_image`='img_grey.gif',`menus`='mainmenu,0,1,1,0.5,daily',`exclmenus`='',`includelink`='1',`usecache`='0',`cachelifetime`='15',`classname`='xmap',`count_xml`='364',`count_html`='364',`views_xml`='13429',`views_html`='14031',`lastvisit_xml`='1328554308',`lastvisit_html`='1328632222',`excluded_items`='',`compress_xml`='0'
WHERE id=1
SELECT template
FROM bal_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 80)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, title, module, position, content, showtitle, control, params
FROM bal_modules AS m
LEFT JOIN bal_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 = 80 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT oldurl, dateadd
FROM bal_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=81&lang=en&view=archive'
SELECT oldurl, dateadd
FROM bal_redirection
WHERE newurl = 'index.php?option=com_search&Itemid=82&lang=en&view=search'
All articles