SELECT *
FROM jos_session
WHERE session_id = '1cd863e2eecdd48a7abcca45a8adf3b8'
DELETE
FROM jos_session
WHERE ( TIME < '1371619519' )
SELECT *
FROM jos_session
WHERE session_id = '1cd863e2eecdd48a7abcca45a8adf3b8'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '1cd863e2eecdd48a7abcca45a8adf3b8','1371621319','','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=6&Itemid=71&limitstart=9%' OR sefurl LIKE 'option=com\_content&view=section&layout=blog&id=6&Itemid=71&limitstart=9%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'index.php?option=com\_content&view=section&layout=blog&id=6&Itemid=71&limitstart=9%' OR sefurl LIKE 'index.php?option=com\_content&view=section&layout=blog&id=6&Itemid=71&limitstart=9%'
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 = 71)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_sections
WHERE id = 6
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 = 6
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 05:55:19' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-06-19 05:55:19' )
ORDER BY a.created DESC
LIMIT 9, 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 = 6
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 05:55:19' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-06-19 05:55:19' )
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 05:55' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2013-06-19 05:55' )
AND b.access <= 0
WHERE a.SECTION = 6
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 = 71 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 = 33
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 33, '2013-06-19' )
SELECT *
FROM jos_swmenu_config
WHERE id = 106
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 = '106' OR jos_swmenu_extended.moduleID IS NULL)
WHERE jos_menu.menutype = 'get-sophisticated'
AND published = '1'
ORDER BY parent, ordering
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos_polls
WHERE id = 15
AND published = 1
SELECT id, text
FROM jos_poll_data
WHERE pollid = 15
AND text <> ""
ORDER BY id
In what was described as the Miracle at Marie Calendars after a waitress’s narcoleptic fit caused a major Boysenberry Pie stain to occur on one of the restaurant’s walls. Immediately, customers began debating whether it looked like the Madonna, Jesus’ mother, or Madonna, the pop icon. Within hours competing interests had surrounded the establishment. One local clergyman said, “I don’t know whether to pray it or give it an exorcism.”
Big announcement just confirmed at San
Diego’s Comic Con Convention--Star Trek: The Wrath Of Metamucil vs.
Rocky VII: Facial Skin Tighter Than A Speed BagIn the tradition of
Godzilla versus...
A major study on Global Warming
sponsored by Coppertone has come to a startling conclusion: Al Gore
is a cause for what’s known as “Crazy Ass Weather
Phenomena.” ...
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...
A Medical Marijuana hot house in California
caught on fire sending clouds of THC-filled smoke into the
air. At a press conference, a police spokesman told
reporters, “I’ve never seen the town this happy...
After seeing the photos of
Golden Boy Oscar De La Hoya in fishnets and silk panties , Pop Dive
Britney Spears told reporters four years ago, “So that’s what
happened to my undies?!” Spears...
Normally when you see a headline like this at
Slurve, it's because we like to make stuff up, especially
when there's not much else to cover. Which is why we have to put a
disclaimer on this one, because it's a true story...
Most of us don't really
think too much about where our electricity comes from. We just
switch on the lights, turn on the TV, or crank up the stereo. But
for some people, producing the...
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.