Genç Hacıbektaş WEB	Salı, 06 Ocak 2009
Anasayfa
Ana Menü Anasayfa Genç Hacıbektaş WEB Kültür - Sanat Araştırdık Genç Paylaşım Genç Mizah Arama Ziyaretçi Defteri İletişim Mekanlar Hacıbektaş Gücü Hacıbektaş Gönüllüleri Oyunlar Resimler (Yeni) Sitelerimiz Hacıbektaş WEB Forum Hacıbektaş Albüm Hacıbektaş Ruhi Su Nasıl Gidilir     Nerde Kalınır Saat & Tarih	Gösterilecek hiç öğe yok [ Geri ]
Design by Zak Mahuna © 2005-2010 www.dizajn.biz
	© 2009 Genç Hacıbektaş WEB Joomla! GNU/GPL Lisansi ile korunan ücretsiz bir yazilimdir.

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 34 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1231267873' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1231267873' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
5
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
10
SELECT *
 FROM jos_menu
 WHERE id = 34
11
SELECT COUNT(a.id)
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_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 <= '2009-01-06 20:06' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-06 20:06' )
 AND ( a.catid=17 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
12
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, s.published AS sec_pub,  cc.published AS sec_pub, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-06 20:06' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-06 20:06' )
 AND ( a.catid=17 )
 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
13
SELECT *
 FROM jos_categories
 WHERE id = '17'
14
SELECT *
 FROM jos_sections
 WHERE id = '4'
15
SELECT a.*
 FROM jos_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'
16
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
17
SELECT COUNT(*) AS numrows
 FROM jos_banner
 WHERE showBanner = 1
18
SELECT *
 FROM jos_banner
 WHERE showBanner = 1
LIMIT 1
19
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 6
20
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
21
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_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 = 34 )
 ORDER BY ordering
22
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Üst menü1'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
24
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Sitelerimiz'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
25
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
26
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1