buffered

Index

Boka artister

Musikanvändning

Musikexempel

Videoklipp

Undervisning

- - - - - - -

Bagpipes worldwide Events

Hire players

Previous events

Music examples

Video clips

- - - - - - -

Piping Scandinavia

From Icon to Identity

- - - - - - -

Bagpipes info

Links

Press material

Contact

Scottish Piping and Drumming Worldwide Pipe Major Mats d Hermansson, Ph.D. and Drum Major Marie Nordström, B.Sc. both have a long experience of Scottish piping and drumming as players, teachers and band leaders. They are now available for performances and recitals worldwide. They can also give lectures about Scottish piping and drumming as well as perspectives of Scottish piping and drumming on the world music scene. Click the 'Hire players' link to the left to find out more about how you can hire players for your event. Mats and Marie are also looking to make contact with old and new friends within the piping and drumming community in Scotland, Scandinavia and worldwide. Pipe Major Mats d Hermansson, Ph.D. and Drum Major Marie Nordström, B.Sc. (Photo: Daniel Hermansson © 2008)

1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=55) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1553096570 AND guest>=0) OR (time<1553093870 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='3948004a038190949fe6ba2fd9fc03a0'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('3d8c161c74adde4888a9256ad91ae360')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '1448a608e4c23b1b1d01a73ad96f8387','1553097470','0','','0','1' ) 
6
SELECT count(*), type FROM mos_stats_agents WHERE (agent='Unknown' AND type=0) OR (agent='Unknown' AND type=1) OR (agent='com' AND type=2) GROUP BY type
7
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type=0
8
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type=1
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='com' AND type=2
10
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
11
SELECT * FROM mos_menu ORDER BY name
12
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
13
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
14
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='38' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-03-20 16:57:50')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-03-20 16:57:50')
 AND a.access <= 0
15
UPDATE mos_content SET hits=(hits+1) WHERE id='38'
16
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2019-03-20' AND item_table='#__content' AND item_id='38'
17
INSERT INTO mos_core_log_items VALUES
('2019-03-20','#__content','38','1')
18
SELECT id, title, module, position, content, showtitle, params, published, m.access, m.groups
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '55' OR mm.menuid = '0')
ORDER BY ordering
19
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
20
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'