-
SELECT *
FROM jos_session
WHERE session_id = '9telh1kjke2e4upmvvdcgkoj05'
-
DELETE
FROM jos_session
WHERE ( time < '1367738914' )
-
SELECT *
FROM jos_session
WHERE session_id = '9telh1kjke2e4upmvvdcgkoj05'
-
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '9telh1kjke2e4upmvvdcgkoj05','1367741314','','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 *
FROM jos_migration_backlinks
WHERE url LIKE 'component/option,com\_mailto/link,aHR0cDovL3dlYnRvdXIub3JnLnVhL211emV5LWlzdG9yaXlpLW1pc3RhLWtvbG9taXlpLmh0bWw\%3D/tmpl,component/%' OR sefurl LIKE 'component/option,com\_mailto/link,aHR0cDovL3dlYnRvdXIub3JnLnVhL211emV5LWlzdG9yaXlpLW1pc3RhLWtvbG9taXlpLmh0bWw\%3D/tmpl,component/%'
-
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_mailto&lang=uk&link=aHR0cDovL3dlYnRvdXIub3JnLnVhL211emV5LWlzdG9yaXlpLW1pc3RhLWtvbG9taXlpLmh0bWw%3D&tmpl=component'
-
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 oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_mailto&lang=uk&link=aHR0cDovL3dlYnRvdXIub3JnLnVhL211emV5LWlzdG9yaXlpLW1pc3RhLWtvbG9taXlpLmh0bWw%3D&tmpl=component'
-
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 id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=24
-
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1