DELETE
FROM jos_session
WHERE ( time < '1369177272' )
SELECT *
FROM jos_session
WHERE session_id = '6302b1205b4e66cd94ffb6a1fa174501'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '6302b1205b4e66cd94ffb6a1fa174501','1369180872','','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'
UPDATE `jos_autotweet_automator`
SET `lastexec`='2013-05-22 00:01:13'
WHERE id='content'
SELECT *
FROM `jos_content`
WHERE (`modified` > '2013-05-20 23:59:13' OR `created` > '2013-05-20 23:59:13')
AND `id` NOT IN (SELECT `ref_id`
FROM `jos_autotweet_queue`
WHERE `plugin` = 'AutotweetContent')
AND `id` NOT IN (SELECT `ref_id`
FROM `jos_autotweet_msglog`
WHERE `plugin` = 'AutotweetContent'
AND `postdate` > '2013-05-20 23:59:13')
SELECT *
FROM jos_autotweet_automator
WHERE id = 'automator'
UPDATE `jos_autotweet_automator`
SET `lastexec`='2013-05-22 00:01:13'
WHERE id='automator'
SELECT *
FROM `jos_autotweet_queue`
WHERE `publish_up` <= '2013-05-22 00:00: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=aHR0cDovL3doYXRhYmFyYmVyLmNvbS9ibG9nL2Jsb2ctbmV3cy8zNjM1LXZpZGVvLWRyLWRyZS1hbmQtc25vb3AtZG9nZy0tdGhlLW5leHQtZXBpc29kZS1saXZlLWF0LW1hbWFz' REGEXP BINARY uri)>0
AND case_sensitive<>'0') OR (('/component/mailto/?tmpl=component&link=aHR0cDovL3doYXRhYmFyYmVyLmNvbS9ibG9nL2Jsb2ctbmV3cy8zNjM1LXZpZGVvLWRyLWRyZS1hbmQtc25vb3AtZG9nZy0tdGhlLW5leHQtZXBpc29kZS1saXZlLWF0LW1hbWFz' REGEXP uri)>0
AND case_sensitive='0') )
AND published='1'
ORDER BY ordering