Main page Lectures/Courses   Main menu Main page Meetings Lectures/Courses About ECVAA Hall of Fame Diplomates Officers Committees Important docs. Guide for questions Training tool Approved centres Archive Positions/Jobs Weblinks News EBVS newsletters Search Contacts Members login Username Password Remember me Forgotten your password? Lectures/Courses Lectures and Courses Vienna Pain Days 2019 Annual courses for preparation to the examinations Preparation course for the FRCA Basic Sciences Anaesthetic Course Mersey School of Anaesthesia Lectures available Ketamine: Exploring various aspects of the drug Workshops ECLAM ESLAV Pre-conference workshop “Publishing your science: toolkit and guidelines”

copyright ECVAA 1995-2018

1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='116' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1568799583)
4
SELECT * FROM mos_session WHERE session_id='93f87de953795fb6d3d12cdb8db26c71'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('f0778d6fa5839ab08a3c07ad9cb04fe1')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'bba3a80a3d46c6cd026566596eb12f19','1568801383','','0','1' )
7
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
8
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
9
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
10
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
11
SELECT count(*) FROM mos_stats_agents WHERE agent='com' AND type='2'
12
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='com' AND type='2'
13
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
14
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
15
SELECT access FROM mos_menu WHERE id='116'
16
SELECT * FROM mos_menu WHERE id='116'
17
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, g.name AS groups, cc.name AS category
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 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_sections AS s ON a.sectionid = s.id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-18 11:09:43' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-18 11:09:43' )
 AND a.access <= '0'
 AND a.catid IN ( 105 ) 
 AND s.access <= 0
 ORDER BY a.created DESC
18
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'
19
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'
20
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
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 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=536
23
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_blog_section' AND m.published='1' AND i.id=536
24
SELECT 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' AND i.id=536
25
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
26
SELECT * FROM mos_components WHERE id='17'
27
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 = '116' OR mm.menuid = '0')
ORDER BY ordering
28
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
29
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
30
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
31
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=322'
32
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=322'
33
SELECT name FROM mos_users WHERE id = 0