SELECT *
FROM jos_session
WHERE session_id = '00d8e5be522f3369416eefe3afe0928b'
DELETE
FROM jos_session
WHERE ( TIME < '1368870175' )
SELECT *
FROM jos_session
WHERE session_id = '00d8e5be522f3369416eefe3afe0928b'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '00d8e5be522f3369416eefe3afe0928b','1368871975','','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=category&layout=blog&id=146&Itemid=80%' OR sefurl LIKE 'option=com\_content&view=category&layout=blog&id=146&Itemid=80%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_content&view=category&layout=blog&id=146&Itemid=80%' OR sefurl LIKE 'index.php?option=com\_content&view=category&layout=blog&id=146&Itemid=80%'
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 = 80)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.SECTION
WHERE c.id = 146
LIMIT 0, 1
SELECT cc.title AS category, 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, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 146
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-18 10:12:55' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-18 10:12:55' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 10
SELECT cc.title AS category, 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, g.name AS groups, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 146
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-18 10:12:55' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-18 10:12:55' )
ORDER BY a.created DESC, a.created DESC
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 = 80 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-05-18' )
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 = 34
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 34, '2013-05-18' )
For the first time in 10 years
Barry Manilow is back with new music. The news has brought about
cheers from his “Fanilows” and the Elevator Muzak Association of
America (EMAA). The EMAA issued a statement: “We welcome any new
material from Mr. Manilow. His music playing in the background has
kept people from lingering on elevators for decades now.” They
added: “Despite stories of an occasional brain hemorage when stuck
on an elevator...
36 indie bands gathered in Ventura, California for a 5-stage all-day extravaganza. ErrorFM was tthere broadcastin live with exclusive coverage. From the antics of Gram Rabbit to the homemade instruments of Old Man Markeley, to a two year old handing out condoms to promote the Bad Betty Podcast, it was certainly an event to behold. Here are some of the highlights. 
In less than one month, Rebecca Black's hit single "Friday" has gotten more than 61 million hits, and is showing no signs of slowing down. With such mind melting lyrics, catchy melodies, the smooth sound of autotune, and a random rapping limo driver, Fridays are never going to be the same again.
I have a bone to pick with the
Grammys, and it’s not just that they failed to nominate my band’s
song “
Very few bands have shit rain upon them while they’re playing. Many, many should. But few do. And if you’re a band from Nashville comprised of brothers and cousins, and you named your band after your grandfather, I don’t even have to hear your music to hope that one day birds will drop little, fluffy craps all over you while you play your silly songs.