DELETE
FROM jos_session
WHERE ( time < '1369199502' )
SELECT *
FROM jos_session
WHERE session_id = '6856dfb332327f52488795f353dde94c'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '6856dfb332327f52488795f353dde94c','1369203102','','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 id, title, alias
FROM jos_jumi
WHERE published = 1
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 *
FROM jos_autotweet_automator
WHERE id = 'content'
SELECT *
FROM jos_autotweet_automator
WHERE id = 'automator'
UPDATE `jos_autotweet_automator`
SET `lastexec`='2013-05-22 06:11:42'
WHERE id='automator'
SELECT *
FROM `jos_autotweet_queue`
WHERE `publish_up` <= '2013-05-22 06:10:42'
ORDER BY `publish_up` ASC
LIMIT 1
SELECT c.`id` AS id, c.`name` AS name, c.`published` AS published, c.`autopublish` AS autopublish, c.`media_mode` AS media_mode, c.`description` AS description, t.`name` AS type, t.`max_chars` AS max_chars, c.`id_1` AS id_1, c.`id_1_secret` AS id_1_secret, c.`id_2` AS id_2, c.`id_2_secret` AS id_2_secret, c.`selection` AS selection, c.`other` AS other, c.`use_own_api` AS use_own_api, c.`api_key` AS api_key, c.`api_secret` AS api_secret, c.`api_authurl` AS api_authurl, c.`api_other` AS api_other, t.`auth_url` AS auth_url, t.`auth_key` AS auth_key, t.`auth_secret` AS auth_secret
FROM `jos_autotweet_channel` c, `jos_autotweet_channeltype` t
WHERE c.`published` = 1
AND c.`channeltype_id` = t.`id`
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT params
FROM jos_components AS c
WHERE c.OPTION='com_widgetkit'
SELECT *
FROM jos_tagmeta
WHERE ( (('/component/mailto/?tmpl=component&link=aHR0cDovL3doYXRhYmFyYmVyLmNvbS9ibG9nL3ZpZGVvcy82NjU4LW9mZmljaWFsLXZpZGVvLWJhbmdsYWRlc2gtZnQtcHVzaGEtdC1hbmQtamFkYWtpc3MtLTEwMA%3D%3D' REGEXP BINARY uri)>0
AND case_sensitive<>'0') OR (('/component/mailto/?tmpl=component&link=aHR0cDovL3doYXRhYmFyYmVyLmNvbS9ibG9nL3ZpZGVvcy82NjU4LW9mZmljaWFsLXZpZGVvLWJhbmdsYWRlc2gtZnQtcHVzaGEtdC1hbmQtamFkYWtpc3MtLTEwMA%3D%3D' REGEXP uri)>0
AND case_sensitive='0') )
AND published='1'
ORDER BY ordering