Make a tax deductible contribution

Main Menu Home About Us Contact Us MHS eNewsletter Composers 18th Century Late 19th Century Early 20th Century Late 20th Century 21st Century Conductors Instrumentalists Vocalists Featured Artists & Groups Reviews Donors Search Site for... Links Newsflash Fun Stuff Hot Topic! Bibliography Events Myrtle on the Web Guestbook Finding the truth is not enough. What we also have to find is justice.                                ~Rigoberta Menchu Composers Filter     Order  Date asc Date desc Title asc Title desc Hits asc Hits desc Ordering    Display #  5 10 15 20 25 30 50 Date Item Title Hits Wednesday, 14 March 2007 21st Century 3474 Wednesday, 14 March 2007 Late 20th century 4800 Wednesday, 14 March 2007 Early 20th Century 4154 Wednesday, 14 March 2007 19th Century 6168 Wednesday, 14 March 2007 18th Century 4096   << Start < Prev 1 Next > End >> Results 1 - 5 of 5 [ Back ]       © 2012 myrtlehart.org Joomla! is Free Software released under the GNU/GPL License.

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 86 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1328527777' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328527777' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = 'c7ebe6b8a9742ecc2e11eff2b588da7b'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = '828cfd428057a20bfa5c1f60a902f429'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '828cfd428057a20bfa5c1f60a902f429','1328528677','','0','1' )
7
SELECT `params` FROM `jos_mambots` WHERE `element`='azrul.system'
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT *
 FROM jos_menu
 WHERE id = 86
15
SELECT *
 FROM jos_categories
 WHERE id = '26'
16
SELECT *
 FROM jos_sections
 WHERE id = '12'
17
SELECT c.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS c
 LEFT JOIN jos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2012-02-06 04:44' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-06 04:44' )
 AND b.access <= 0
 WHERE c.section = '12'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
18
SELECT COUNT(a.id) as numitems
 FROM jos_content AS a
 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.catid = 26
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-06 04:44' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-06 04:44' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
19
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM jos_content AS a
 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.catid = 26
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-06 04:44' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-06 04:44' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 30
20
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
21
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 86 )
 ORDER BY ordering
22
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
24
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=100'
25
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=101'
26
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=102'
27
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=103'
28
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=104'
29
select published from jos_categories where id=3
30
select s.published from jos_sections s, jos_categories c where c.id=3 and c.section=s.id
31
SELECT * FROM jos_content
 WHERE catid=3
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state = 1
 ORDER BY created DESC
 LIMIT 100
32
select published from jos_categories where id=22
33
select s.published from jos_sections s, jos_categories c where c.id=22 and c.section=s.id
34
SELECT * FROM jos_content
 WHERE catid=22
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state = 1
 ORDER BY created DESC
 LIMIT 100
35
select published from jos_categories where id=39
36
select s.published from jos_sections s, jos_categories c where c.id=39 and c.section=s.id
37
SELECT * FROM jos_content
 WHERE catid=39
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= now() )
            AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= now() )
            AND state = 1
 ORDER BY created DESC
 LIMIT 100
38
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'funstuff'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
39
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
40
SELECT * FROM jos_jreactConfig LIMIT 1