SELECT *
FROM jos_session
WHERE session_id = '7f6b59b0e451ac9b93d0de5e02281c98'
DELETE
FROM jos_session
WHERE ( TIME < '1371648950' )
SELECT *
FROM jos_session
WHERE session_id = '7f6b59b0e451ac9b93d0de5e02281c98'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '7f6b59b0e451ac9b93d0de5e02281c98','1371650750','','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 'option=com\_content&view=section&layout=blog&id=11&Itemid=13&limitstart=18%' OR sefurl LIKE 'option=com\_content&view=section&layout=blog&id=11&Itemid=13&limitstart=18%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_content&view=section&layout=blog&id=11&Itemid=13&limitstart=18%' OR sefurl LIKE 'index.php?option=com\_content&view=section&layout=blog&id=11&Itemid=13&limitstart=18%'
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 = 13)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_sections
WHERE id = 11
LIMIT 0, 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.access <= 0
AND s.id = 11
AND s.access <= 0
AND cc.access <= 0
AND s.published = 1
AND cc.published = 1
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-06-19 14:05:50' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-06-19 14:05:50' )
ORDER BY a.created DESC
LIMIT 18, 9
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.access <= 0
AND s.id = 11
AND s.access <= 0
AND cc.access <= 0
AND s.published = 1
AND cc.published = 1
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-06-19 14:05:50' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-06-19 14:05:50' )
ORDER BY a.created DESC
SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
FROM jos_categories AS a
LEFT JOIN jos_content AS b
ON b.catid = a.id
AND b.state = 1
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2013-06-19 14:05' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2013-06-19 14:05' )
AND b.access <= 0
WHERE a.SECTION = 11
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
HAVING numitems > 0
ORDER BY a.ordering
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 13 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *
FROM jos_swmenu_config
WHERE id = 128
SELECT jos_menu.* , jos_swmenu_extended.*
FROM jos_menu
LEFT JOIN jos_swmenu_extended
ON jos_menu.id = jos_swmenu_extended.menu_id
AND (jos_swmenu_extended.moduleID = '128' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'starting-lineup'
AND published = '1'
ORDER BY parent, ordering
SELECT *
FROM jos_swmenu_config
WHERE id = 68
SELECT jos_menu.* , jos_swmenu_extended.*
FROM jos_menu
LEFT JOIN jos_swmenu_extended
ON jos_menu.id = jos_swmenu_extended.menu_id
AND (jos_swmenu_extended.moduleID = '68' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'Clubhouse'
AND published = '1'
ORDER BY parent, ordering
SELECT *
FROM jos_swmenu_config
WHERE id = 79
SELECT jos_menu.* , jos_swmenu_extended.*
FROM jos_menu
LEFT JOIN jos_swmenu_extended
ON jos_menu.id = jos_swmenu_extended.menu_id
AND (jos_swmenu_extended.moduleID = '79' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'socialmedia'
AND published = '1'
ORDER BY parent, ordering
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 226
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 25
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 25, '2013-06-19' )
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 6
AND catid = 242
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 37
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 37, '2013-06-19' )
It is not called the Grand Old Party without good reason. Formed in 1854 as a response to the proposed expansion of slavery into Kansas and Nebraska, by 1860, they controlled Congress, and had succeeded in electing one of the greatest men to ever hold the highest office in our nation. They governed our country through the Civil War, helping to preserve our nation, end slavery, and pass the thirteenth, fourteenth and fifteenth amendments, taking a great step toward equal treatment under the law for all human beings.
It is a most disconcerting
feeling to those on their way to their place of employment to be
faced with parks, streets, even church yards filled with
the...
We have been called the land of opportunity. A shining city on a hill. The greatest country in the world. And all of us who live in this great nation, despite our differences, share a set of common values.
Invigorated by my experience visiting #OWS in New
York a few weeks ago, I was greatly looking forward to the Global
Day of Action back in Los Angeles. For the record, I am not a
professional protestor, although I started...
The man who once defeated Jack
Nicklaus left-handed, and was undefeated his entire career in North
Korea, Kim Jong Il has died of having too big a heart. Known
for his sunglasses and track...
The cheering in the streets of Tripoli
over the fall of the Libyian tyrant, Mommar Gadhafi brought relief
and celebration around the globe. From Microsoft
Office: “Gadhafi is done. Which is not only a victory for
Libyans...
I went to New York last week to
scatter the ashes of Jack, my beloved border collie of 12 years,
who lived with me there before we moved to Los Angeles. I spent
most of my days wandering and soaking up the...