The Bagpipe Pages
From Icon to Identity – Contents
Table of Contents (Download pdf-file – Click here.)

From Icon to Identity: Scottish Piping & Drumming in Scandinavia

Doctoral thesis by Mats d Hermansson (2003)

Table of Contents, page 1
Table of contents, page 2
Table of Contents, page 3
Table of Contents, page 4
Table of Contents, page 5
© Mats d Hermansson 2008
Joomla Templates By Joomladesigns
20 queries executed
1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=64) ORDER BY client_id, menuid
2 DELETE FROM mos_session WHERE (time<1563864149 AND guest>=0) OR (time<1563861449 AND guest<0)
3 SELECT * FROM mos_session WHERE session_id='0a441eacbd70a6d4be7bfdcf8d3998e3'
4 SELECT session_id FROM mos_session WHERE session_id=MD5('b5baf813743a31af907aaf870a98ca6f')
5 INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( 'd6af2bdb555ca48cae6da3421f6b76ca','1563865049','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='42' AND (a.state = '1' OR a.state = '-1') AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-07-23 07:57:29') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-07-23 07:57:29') AND a.access <= 0
15 UPDATE mos_content SET hits=(hits+1) WHERE id='42'
16 SELECT hits FROM mos_core_log_items WHERE time_stamp='2019-07-23' AND item_table='#__content' AND item_id='42'
17 INSERT INTO mos_core_log_items VALUES ('2019-07-23','#__content','42','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 = '64' 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'