Conteúdo Imagens 08 setembro 2010   Início Fale Conosco Links Arquivos Compartilhados Browse the web faster with Firefox Conteúdo Documentários Alimentação/Vegan Curtas Livros/Textos Imagens Programas Menu Conteúdo Notícias Links Arquivos Compartilhados Chat Entre em Contato Search Recursos Favoritos Login Imagens Passeata 28/03/08 Avaliação do Usuário: / 1 Por Interativismo    20 de março de 2008 Seja o primeiro a conmentar este artigo. | Adicionar como favorito (20) | Publique este artigo no seu site | Visto: 1033 | Leia mais... Última Atualização ( 20 de março de 2008 ) Leia mais...   [Voltar] Search Online Nós temos 3 visitantes online Frase "Somente após uma desgraça conseguirá despertar Somente depois de perder tudo, poderá fazer o que quiser" Tyler Durden - Chuck Palahniuk   Estatisticas Membros: 121 Notícias: 160 Weblinks: 13 Visitantes: 201553 Links Recomendados:

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access IN ( 0 )
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 40 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1283963739' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283963739' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '1fceacdd068ad912150a9b39b3c5e5fa'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = '67aeab422d42e95def4fada196b14d62'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`jaclplus`,`guest` ) VALUES ( '67aeab422d42e95def4fada196b14d62','1283964639','','0','0','1' )
8
SELECT *
 FROM jos_menu
 WHERE id = 40
9
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 <= '2010-09-08 11:50' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 11:50' )
 AND ( a.catid=14 )
 AND s.published = 1
 AND cc.published = 1
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,
 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 <= '2010-09-08 11:50' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 11:50' )
 AND ( a.catid=14 )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  a.created DESC
LIMIT 5
11
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 106
12
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access IN ( 0 )
 AND folder = 'content'
 ORDER BY ordering
13
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_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_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 = 106
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
14
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '106'
15
SELECT hits FROM jos_content WHERE id = '106'
16
SELECT count(*) FROM jos_akocomment WHERE contentid='106' AND published='1'
17
SELECT id FROM jos_mambots WHERE element = 'joompie' AND folder = 'content'
18
SELECT *
 FROM jos_mambots
 WHERE id = '29'
19
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
20
SELECT *
 FROM jos_mambots
 WHERE id = '27'
21
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
22
SELECT *
 FROM jos_mambots
 WHERE id = '27'
23
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
24
SELECT *
 FROM jos_mambots
 WHERE id = '27'
25
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
26
SELECT *
 FROM jos_mambots
 WHERE id = '27'
27
SELECT `fulltext` FROM `jos_content` WHERE `id` =106
28
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'
29
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access IN ( 0 )
 ORDER BY menutype, parent, ordering
30
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 IN ( 0 )
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 40 )
 ORDER BY ordering
31
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
32
SELECT `username` FROM jos_users WHERE id = '0'
33
SELECT `username` FROM jos_users WHERE id = '0'
34
INSERT INTO jos_usertrace (`username`, `userip`, `useragent`, `userurl`, `userreferer`, `date`, `time`) VALUES ('', '38.107.191.105', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '/index.php?option=com_content&task=blogcategory&id=14&Itemid=40', '', '09.08.10', '11:50:39')
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Conteúdo'
 AND published = 1
 ORDER BY parent, ordering
36
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
37
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=1 )
38
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 1
39
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
40
SELECT guest, usertype
 FROM jos_session
41
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 0
42
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state, a.access
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-08 11:50' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 11:50' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND componentid = 76
44
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '76'
45
SELECT hits FROM jos_content WHERE id = '76'
46
SELECT id FROM jos_mambots WHERE element = 'joompie' AND folder = 'content'
47
SELECT *
 FROM jos_mambots
 WHERE id = '29'
48
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
49
SELECT *
 FROM jos_mambots
 WHERE id = '27'
50
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
51
SELECT *
 FROM jos_mambots
 WHERE id = '27'
52
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
53
SELECT *
 FROM jos_mambots
 WHERE id = '27'
54
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
55
SELECT *
 FROM jos_mambots
 WHERE id = '27'
56
SELECT COUNT( id ) AS count_users
 FROM jos_users
57
SELECT COUNT( id ) AS count_items
 FROM jos_content
58
SELECT COUNT( id ) AS count_links
 FROM jos_weblinks
 WHERE published = 1
59
SELECT SUM( hits ) AS count
 FROM jos_stats_agents
 WHERE type = 1
60
SELECT a.*, b.name AS bannerGroup FROM jos_banner AS a LEFT JOIN jos_bannerclient AS b ON a.cid = b.cid WHERE a.showBanner = '1' AND b.cid IN ('0') ORDER BY a.bid;