Sargam FAQ My Favorite links Listen to Podcast

Login
Username Password Remember me Password Reminder No account yet? Create one

Sargam

Sargam is the website for lovers of Hindustani Classical and light music. The idea of 'Podcasting' struck as perfect solution to my ever expanding group of music lovers in London and South East England. In May 2004, we started a bi-monthly 'Mehfil'  ( Concert) to spread the joy. This program was very well received and soon became popular with our friends. After an eventful year of Music lovers seperated by miles, bound by busy work routines , and energy sapping  daily commutes made regular Mehfil ( Concert) difficult to arrange. I  had to find a new way of sharing their joy with like minded folks across the globe. So here's one small step in that direction. Thanks to Prakash for his wonderful idea, hosting, and technical as well as moral support. Thanks to Viv for help with Style sheets and lovely logo for Sargam.   Your comments and suggestions are of great value. Hope you Enjoy !   [ Back ]

Mambo is Free Software released under the GNU/GPL License.

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='10' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1219912171)
5
SELECT * FROM mos_session WHERE session_id='075cbc2d8b03eb8069dda57ad709d559'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('39d1af773c2be842be297f236ce64f82')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '61f8a0ac3884db15662a2788a5297655','1219913071','','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='10'
17
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
 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.id='3' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-08-28 04:44:32')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-08-28 04:44:32')
 AND a.access <= 0
18
SELECT a.id
 FROM mos_content AS a
 WHERE a.catid = 2
 AND a.state = 1 AND ordering < 1
 AND a.access <= '0'
 ORDER BY a.ordering DESC
 LIMIT 1
19
SELECT a.id
 FROM mos_content AS a
 WHERE a.catid = 2
 AND a.state = 1 AND ordering > 1
 AND a.access <= '0'
 ORDER BY a.ordering
 LIMIT 1
20
UPDATE mos_content SET hits=(hits+1) WHERE id='3'
21
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
22
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
23
SELECT * FROM mos_mambots WHERE id='16'
24
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
25
SELECT * FROM mos_components WHERE id='17'
26
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 = '10' OR mm.menuid = '0')
ORDER BY ordering
27
SELECT a.id
 FROM mos_content AS a
 INNER JOIN mos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access <= '0' AND b.access <= '0'
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-08-28 04:44:32') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-08-28 04:44:32')
 AND catid='3' 
 ORDER BY a.ordering
28
SELECT * FROM mos_content WHERE id='0'
29
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
30
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
31
SELECT * FROM mos_mambots WHERE id='16'
32
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
33
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=3'
34
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=3'
35
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=4'
36
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=4'
37
SELECT name FROM mos_users WHERE id = 0
38
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
39
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
40
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
41
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
42
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 0,1