holebipastores.be

Home Nieuws Links Groep

Main Menu Home Groep Activiteiten Vieringen Gebedsviering Schepping Andere vindplaatsen Contacten Forum Bezinning Fotogalerij

Home Vieringen Newsflash Vieringen Gebedsviering Schepping Lees meer...   Gebedviering 'Vriendschap' Lees meer...   Andere vindplaatsen andere vindplaats   [ terug ]

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM joom_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM joom_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 17 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM joom_session
 WHERE (
 ( time < '1283705314' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283705314' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT session_id
 FROM joom_session
 WHERE session_id = 'a4eb8519e45edd64175bb1fb0e27bf05'
6
INSERT INTO joom_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'a4eb8519e45edd64175bb1fb0e27bf05','1283706214','','0','1' )
7
SELECT COUNT(*)
 FROM joom_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE joom_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM joom_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE joom_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM joom_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
12
UPDATE joom_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
13
SELECT *
 FROM joom_menu
 WHERE id = 17
14
SELECT COUNT(a.id)
 FROM joom_content AS a
 INNER JOIN joom_categories AS cc ON cc.id = a.catid
 LEFT JOIN joom_users AS u ON u.id = a.created_by
 LEFT JOIN joom_sections AS s ON a.sectionid = s.id
 LEFT JOIN joom_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 <= '2010-09-05 19:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:03' )
 AND ( a.sectionid=3 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
15
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM joom_content AS a
 INNER JOIN joom_categories AS cc ON cc.id = a.catid
 LEFT JOIN joom_users AS u ON u.id = a.created_by
 LEFT JOIN joom_sections AS s ON a.sectionid = s.id
 LEFT JOIN joom_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 <= '2010-09-05 19:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:03' )
 AND ( a.sectionid=3 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 9
16
SELECT folder, element, published, params
 FROM joom_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
17
SELECT a.*
 FROM joom_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'
18
SELECT id, title, module, position, content, showtitle, params
 FROM joom_modules AS m
 INNER JOIN joom_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 = 17 )
 ORDER BY ordering
19
SELECT id
 FROM joom_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
20
SELECT m.*
 FROM joom_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
21
SELECT COUNT( id )
 FROM joom_menu 
 WHERE type = 'content_typed'
 AND published = 1
22
SELECT id
 FROM joom_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
23
SELECT m.*
 FROM joom_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
24
SELECT m.*
 FROM joom_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
25
SELECT id, name, link, parent, type, menutype, access
 FROM joom_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
26
SELECT *
 FROM joom_banner
 WHERE showBanner=1
27
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM joom_content AS a
 INNER JOIN joom_categories AS cc ON cc.id = a.catid
 INNER JOIN joom_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 19:03' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:03' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering