Home

Main Menu Home News Pictures and Sounds Eventlist Events Review Contact Us Guestbook Blog Search About Frank Sinatra Ken Prevost Latest News Ken is back at Sommerlust! Events Review / Vergangene Veranstalltungen About Ken Prevost Login Form Benutzername Passwort Angemeldet bleiben Passwort vergessen?

Newsflash

Upcoming events... Sorry, no events to display Last Posts on Guestbook Webmaster Yes! Today Ken as well found his way to the Kenatra.ch site....!    Good work! Weiter Gallery2 Image block Zufallsbild DSC_2970 Datum: 03.09.2004 Betrachtet: 169 mal Besitzer/in: Tutorial_Publisher Syndicate

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_ken_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM jos_ken_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_ken_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_ken_session
 WHERE (
 ( time < '1327701341' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1327701341' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT COUNT(*)
 FROM jos_ken_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
7
UPDATE jos_ken_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
8
SELECT COUNT(*)
 FROM jos_ken_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
9
UPDATE jos_ken_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
10
SELECT COUNT(*)
 FROM jos_ken_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
11
UPDATE jos_ken_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
12
SELECT *
 FROM jos_ken_menu
 WHERE id = 1
13
SELECT a.*
 FROM jos_ken_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'
14
SELECT id, name, link, parent, type, menutype, access
 FROM jos_ken_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
15
SELECT id, title, module, position, content, showtitle, params
 FROM jos_ken_modules AS m
 INNER JOIN jos_ken_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
16
SELECT m.*
 FROM jos_ken_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
17
SELECT m.*
 FROM jos_ken_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
18
SELECT m.*
 FROM jos_ken_menu AS m
 WHERE menutype = 'About'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT COUNT( id )
 FROM jos_ken_menu 
 WHERE type = 'content_typed'
 AND published = 1
20
SELECT id
 FROM jos_ken_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
21
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_ken_content AS a
 LEFT JOIN jos_ken_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_ken_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_ken_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-27 23:10' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 23:10' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
22
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_ken_content AS i
 LEFT JOIN jos_ken_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_ken_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_ken_categories AS c ON i.catid = c.id
 LEFT JOIN jos_ken_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 19
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
23
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_ken_content AS i
 LEFT JOIN jos_ken_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_ken_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_ken_categories AS c ON i.catid = c.id
 LEFT JOIN jos_ken_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 16
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
24
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_ken_content AS i
 LEFT JOIN jos_ken_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_ken_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_ken_categories AS c ON i.catid = c.id
 LEFT JOIN jos_ken_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 14
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
25
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_ken_content AS a
 INNER JOIN jos_ken_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_ken_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 <= '2012-01-27 23:10' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 23:10' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
26
UPDATE jos_ken_eventlist_dates SET published = -1 WHERE DATE_SUB(NOW(), INTERVAL 0 DAY) > (IF (enddates <> 0000-00-00, enddates, dates))
27
SELECT id FROM jos_ken_menu WHERE link = "index.php?option=com_eventlist" AND published > 0
28
SELECT a.*, l.club, l.city, l.url FROM jos_ken_eventlist_dates AS a LEFT JOIN jos_ken_eventlist_locate AS l ON l.id = a.locid LEFT JOIN jos_ken_eventlist_categories AS c ON c.id = a.catsid WHERE a.published = 1 AND (IF (a.enddates <> 0000-00-00, a.enddates, a.dates)) >= DATE(NOW()) AND c.access <= 0 ORDER BY a.dates, a.times LIMIT 5
29
SELECT * FROM jos_ken_easybook
WHERE published = 1
ORDER BY gbid DESC
LIMIT 1
30
SELECT jlappid FROM jos_ken_jl_app WHERE apphandle='g2bridge'
31
SELECT param, value FROM jos_ken_jl_conf WHERE appid='100'
32
SELECT id
 FROM jos_ken_menu
 WHERE link = 'index.php?option=com_gallery2'
 AND published = '1'
 ORDER BY `access`, `parent`, `ordering` ASC
33
SELECT param, value FROM jos_ken_jl_conf WHERE appid='100'
34
SELECT param, value FROM jos_ken_jl_conf WHERE appid='100'