SELECT *
FROM jos_session
WHERE session_id = 'kg4on3rqvcnl70nhp8799o6s61'
DELETE
FROM jos_session
WHERE ( TIME < '1732174423' )
SELECT *
FROM jos_session
WHERE session_id = 'kg4on3rqvcnl70nhp8799o6s61'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'kg4on3rqvcnl70nhp8799o6s61','1732175323','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 0
AND TYPE = 'user'
ORDER BY ordering
SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 0
AND TYPE = 'templates'
ORDER BY ordering
SELECT *
FROM jos_comprofiler_tabs t
WHERE t.enabled = 1
ORDER BY t.ordering_register, t.POSITION, t.ordering
SELECT f.*, t.ordering_register AS tab_ordering_register, t.POSITION AS tab_position, t.ordering AS tab_ordering
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
AND f.registration = 1
AND t.enabled = 1
ORDER BY t.ordering_register, t.POSITION, t.ordering, f.ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id
FROM jos_comprofiler_field_values
WHERE fieldid = 67
ORDER BY ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND menuid = 0
Campi obbligatori | 
Campi visibili nel tuo profilo | 
Campi non visibili nel profilo | 
Informazioni: Punta il mouse sulle icone