holebipastores.be

Home Nieuws Links Groep

Main Menu Home Groep Activiteiten Vieringen Forum Bezinning Fotogalerij Login Form Gebruikersnaam Wachtwoord Login opslaan Wachtwoord vergeten? Nog geen account? Maak er één aan! Syndicate

Home Newsflash Léonard Interview met André-Mutien Léonard: ‘Van Afrika leren om door trouw en onthouding Aids te voorkomen’ (3 april 2007) Lees meer...   << Begin < Vorige 21 22 23 24 25 26 Volgende > Einde >> Resultaten 101 - 101 van 101

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 = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM joom_session
 WHERE (
 ( time < '1283707118' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283707118' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM joom_session
 WHERE session_id = '19d8c2e27d35b54fb905d158c943e037'
6
SELECT session_id
 FROM joom_session
 WHERE session_id = '0ebc9027a522e8172699fb95de8b0ab2'
7
INSERT INTO joom_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '0ebc9027a522e8172699fb95de8b0ab2','1283708018','','0','1' )
8
SELECT *
 FROM joom_menu
 WHERE id = 1
9
SELECT COUNT(a.id)
 FROM joom_content AS a
 INNER JOIN joom_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN joom_categories AS cc ON cc.id = a.catid
 INNER JOIN joom_sections AS s ON s.id = a.sectionid
 LEFT JOIN joom_users AS u ON u.id = a.created_by
 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:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:33' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
10
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, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM joom_content AS a
 INNER JOIN joom_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN joom_categories AS cc ON cc.id = a.catid
 INNER JOIN joom_sections AS s ON s.id = a.sectionid
 LEFT JOIN joom_users AS u ON u.id = a.created_by
 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:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:33' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 100, 4
11
SELECT folder, element, published, params
 FROM joom_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
12
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'
13
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 = 1 )
 ORDER BY ordering
14
SELECT id
 FROM joom_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
15
SELECT m.*
 FROM joom_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
16
SELECT COUNT( id )
 FROM joom_menu 
 WHERE type = 'content_typed'
 AND published = 1
17
SELECT id
 FROM joom_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
18
SELECT m.*
 FROM joom_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT m.*
 FROM joom_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
20
SELECT id, name, link, parent, type, menutype, access
 FROM joom_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
21
SELECT *
 FROM joom_banner
 WHERE showBanner=1
22
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:33' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:33' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering