PHP-Code:
1
1
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0--------------------------------------------------------------------------------2
DELETE FROM jos_session
WHERE time < '1207122395'
AND guest = 1
AND gid = 0
AND userid <> 0--------------------------------------------------------------------------------3
UPDATE jos_session
SET time = '1207124195'
, session_id = 'ce752daf2a6831e27e1ba1eca0e563ff'
WHERE session_id = '4f5cd03a941219a9e6cb66987a1a72dc'--------------------------------------------------------------------------------4
SELECT COUNT( session_id )
FROM jos_session
WHERE session_id = 'ce752daf2a6831e27e1ba1eca0e563ff'
AND username = 'admin'
AND userid = 62--------------------------------------------------------------------------------5
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'icon'
AND m.client_id = 1
ORDER BY m.ordering--------------------------------------------------------------------------------6
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'cpanel'
AND m.client_id = 1
ORDER BY m.ordering--------------------------------------------------------------------------------7
SELECT COUNT(*)
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username--------------------------------------------------------------------------------8
SELECT *
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
LIMIT 50--------------------------------------------------------------------------------9
SELECT *
FROM jos_components
ORDER BY ordering, name--------------------------------------------------------------------------------10
SELECT a.hits, a.id, a.sectionid, a.title, a.created, u.name
FROM jos_content AS a
LEFT JOIN jos_users AS u ON u.id=a.created_by
WHERE a.state != -2
ORDER BY hits DESC
LIMIT 10--------------------------------------------------------------------------------11
SELECT a.id, a.sectionid, a.title, a.created, u.name, a.created_by_alias, a.created_by
FROM jos_content AS a
LEFT JOIN jos_users AS u ON u.id = a.created_by
WHERE a.state != -2
ORDER BY created DESC
LIMIT 10--------------------------------------------------------------------------------12
SELECT menutype, COUNT(id) AS numitems
FROM jos_menu
WHERE published = 1
GROUP BY menutype--------------------------------------------------------------------------------13
SELECT a.id, a.title, a.name
FROM jos_sections AS a
WHERE a.scope = 'content'
GROUP BY a.id
ORDER BY a.ordering--------------------------------------------------------------------------------14
SELECT params
FROM jos_modules
WHERE module = 'mod_mainmenu'
ORDER BY title--------------------------------------------------------------------------------15
SELECT menutype
FROM jos_menu
GROUP BY menutype
ORDER BY menutype--------------------------------------------------------------------------------16
SELECT *
FROM jos_components
WHERE name != 'frontpage'
AND name != 'media manager'
ORDER BY ordering, name--------------------------------------------------------------------------------17
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'header'
AND m.client_id = 1
ORDER BY m.ordering--------------------------------------------------------------------------------18
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62--------------------------------------------------------------------------------19
SELECT COUNT( session_id )
FROM jos_session
WHERE session_id != 'ce752daf2a6831e27e1ba1eca0e563ff'--------------------------------------------------------------------------------20
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'debug'
AND m.client_id = 1
ORDER BY m.ordering
Export und Import mit MYSQLDUMPER ergibt die gleichen Probleme.
Lesezeichen