DELETE
FROM jos_session
WHERE ( time < '1369020012' )
SELECT *
FROM jos_session
WHERE session_id = 'f9bd533df269e2a4a73c9afa8657227b'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'f9bd533df269e2a4a73c9afa8657227b','1369023612','','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 *
FROM jos_autotweet_automator
WHERE id = 'content'
SELECT *
FROM jos_autotweet_automator
WHERE id = 'automator'
UPDATE `jos_autotweet_automator`
SET `lastexec`='2013-05-20 04:20:13'
WHERE id='automator'
SELECT *
FROM `jos_autotweet_queue`
WHERE `publish_up` <= '2013-05-20 04:19:13'
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=aHR0cDovL3doYXRhYmFyYmVyLmNvbS9tdXNpYy1kb3dubG9hZHMvbmV3ZXN0LXNpbmdsZXMtZGFpbHkvNjEyNS1uZXdtdXNpYy1qdXN0aW4tYmllYmVyLWZ0LXlpbmcteWFuZy10d2lucy1ib3lmcmllbmQtcmVtaXg%3D' REGEXP BINARY uri)>0
AND case_sensitive<>'0') OR (('/component/mailto/?tmpl=component&link=aHR0cDovL3doYXRhYmFyYmVyLmNvbS9tdXNpYy1kb3dubG9hZHMvbmV3ZXN0LXNpbmdsZXMtZGFpbHkvNjEyNS1uZXdtdXNpYy1qdXN0aW4tYmllYmVyLWZ0LXlpbmcteWFuZy10d2lucy1ib3lmcmllbmQtcmVtaXg%3D' REGEXP uri)>0
AND case_sensitive='0') )
AND published='1'
ORDER BY ordering