Main Menu Home Links Contact Us Search Video Vault Browse All Shows About Search Login Form Username Password Remember me Forgotten your password? No account yet? Create one Who's Online We have 27 guests online and 13 members online bpf3535 memnArrenna lorrenturse WXJohn Neubecose Ensuenoleatte theman_4321 Last Seen »  WXJohn »  theman_4321 »  bpf3535 »  Neubecose »  Ensuenoleatte »  memnArrenna »  lorrenturse »  Lumpy75 »  antiseeda »  bubba40 Total Users 24708 registered 15 today 133 this week 791 this month Last: lorrenturse	IN HONOR OF LEROI MOORE 1961-2008   Last Updated ( Friday, 17 December 2010 ) [ Back ]	Browse All Shows Select Year DMB 2008 DMB 2007 DMB 2006 DMB 2005 DMB 2004 DMB 2003 DMB 2002 DMB 2001 and Older Dave Matthews and Friends Dave Matthews Dave & Tim DMB 2010 DMB 2009 Polls Which surprise would you rather see DMB pull out this summer? A full album straight through **WARNING: could be Everyday ;)** The liberation of Machead Butch Taylor on keys!
	Copyright © 2005, Live In Our Graves. All Rights Reserved. logo designed by: jh! design

1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1327701269)
5
SELECT * FROM mos_session WHERE session_id='60e98f092da3fc645407601a9425bfbd'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('5247a9ea13334c6ea4ef0c744c799426')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '8d150f4efb3d703e298cce88bb101d45','1327708469','','0','1' )
8
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
13
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
14
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
15
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
16
SELECT access FROM mos_menu WHERE id='1'
17
SELECT * FROM mos_menu WHERE id='1'
18
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-01-27 18:54:29'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-01-27 18:54:29' )
 ORDER BY f.ordering
19
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
20
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
21
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
22
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
23
select media from mos_media where id = 99
24
SELECT a.id
 FROM mos_components AS a
 WHERE a.option = 'com_podcast'
25
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
26
SELECT * FROM mos_mambots WHERE id='16'
27
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=99
28
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
29
SELECT * FROM mos_components WHERE id='17'
30
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
31
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
32
SELECT name FROM mos_users WHERE id = 0
33
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
34
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
35
SELECT DISTINCT a.username
 FROM mos_session AS a
 WHERE (a.guest=0)
36
SELECT id, username, name, lastvisitDate
FROM mos_users
WHERE block='0'
ORDER BY lastvisitDate  DESC LIMIT 10
37
SELECT count(id) as registered FROM mos_users WHERE usertype <> 'administrator' AND usertype <> 'superadministrator'
38
SELECT count(id) FROM mos_users WHERE to_days(registerDate) = to_days(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'
39
SELECT count(id) FROM mos_users WHERE yearweek(registerDate) = yearweek(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'
40
SELECT count(id) FROM mos_users WHERE month(registerDate) = month(curdate()) AND year(registerDate) = year(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'
41
SELECT username FROM mos_users WHERE block='0' AND usertype <> 'administrator' AND usertype <> 'superadministrator' ORDER BY registerDate DESC LIMIT 1
42
SELECT * FROM mos_menu  WHERE menutype = 'Shows'  AND published = '1'  ORDER BY name DESC
43
SELECT p.id, p.title
FROM mos_poll_menu AS pm, mos_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
44
SELECT id, text FROM mos_poll_data
WHERE pollid='40' AND text <> ''
ORDER BY id