Agrandar Reducir Reiniciar

    Inicio

Menú principal

Inicio
Eventos
Artículos
Gastronomía
Identificar setas
Clave dicotómica
Glosario
Socios
Histórico Eventos
Calendario Setero
Archivos

Setas de la galería

Formulario de acceso






¿Recuperar clave?

¿Quién está en línea?

Contador

Visitas ayer: 86
Visitas hoy: 76
Total Visitas: 41764
Bots Hoy: 0

Lo mas visto

Secciones

A Zarrota by A.E.S.
52 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT jaclplus FROM aza_core_acl_aro_groups WHERE group_id='29'
3
SELECT folder, element, published, params
 FROM aza_mambots
 WHERE published >= 1
 AND access IN ( 0 )
 AND folder = 'system'
 ORDER BY ordering
4
SELECT id, link
 FROM aza_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 0, 1
5
SELECT template
 FROM aza_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 0, 1
6
DELETE FROM aza_session
 WHERE (
 ( time < '1728329441' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1728329441' )
 AND guest = 1
 AND userid = 0
 )
7
SELECT jaclplus FROM aza_core_acl_aro_groups WHERE group_id='29'
8
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'com'
 AND type = 2
13
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
14
SELECT *
 FROM aza_menu
 WHERE id = 1
15
SELECT * FROM aza_jaclplus WHERE aro_section ='users' AND aro_value ='public frontend' AND enable=1
16
SELECT a.*
 FROM aza_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'
17
SELECT value FROM aza_jstats_configuration WHERE description = 'onlinetime'
18
SELECT exclude,type from aza_jstats_ipaddresses where ip='44.220.184.63' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
19
SELECT LENGTH( browser_string ) AS strlen, browser_string, browser_fullname FROM aza_jstats_browsers ORDER BY strlen DESC
20
SELECT LENGTH(bot_string) AS strlen, bot_string,bot_fullname FROM aza_jstats_bots ORDER BY strlen DESC
21
SELECT LENGTH(sys_string) AS strlen,sys_string,sys_fullname FROM aza_jstats_systems ORDER BY strlen DESC
22
insert into aza_jstats_ipaddresses (ip,nslookup,useragent,tld,system,browser,type) values ('44.220.184.63','ec2-44-220-184-63.compute-1.amazonaws.com','ccbot/2.0 (https://commoncrawl.org/faq/)','com','','Unknown robot (identified by crawl)',2)
23
SELECT id from aza_jstats_ipaddresses where ip='44.220.184.63' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
24
SELECT id from aza_jstats_visits WHERE month=MONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)) AND year=YEAR(DATE_ADD(NOW(), INTERVAL 0 HOUR)) AND ip_id='27453' and time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL 0 HOUR), INTERVAL -10 MINUTE)
25
INSERT INTO aza_jstats_visits (ip_id,hour,day,month,year,time) values (27453,HOUR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),DAYOFMONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),MONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),YEAR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),DATE_ADD(NOW(), INTERVAL 0 HOUR))
26
SELECT page_id, page_title FROM aza_jstats_pages WHERE page='/index.php'
27
INSERT INTO aza_jstats_page_request (page_id,hour,day,month,year,ip_id) values (1,HOUR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),DAYOFMONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),MONTH(DATE_ADD(NOW(), INTERVAL 0 HOUR)),YEAR(DATE_ADD(NOW(), INTERVAL 0 HOUR)),73376)
28
SELECT id, title, module, position, content, showtitle, params
 FROM aza_modules AS m
 INNER JOIN aza_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.access IN ( 0 )
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = '1' )
 ORDER BY ordering
29
SELECT id, name, link, parent, type, menutype, access
 FROM aza_menu
 WHERE published = 1
 AND access IN ( 0 )
 ORDER BY menutype, parent, ordering
30
SELECT m.*
 FROM aza_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
31
SELECT m.*
 FROM aza_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
32
SELECT COUNT( id )
 FROM aza_menu 
 WHERE type = 'content_item_link'
 AND published = 1
33
SELECT id
 FROM aza_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=36'
34
SELECT guest, usertype
 FROM aza_session
35
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_visits LEFT JOIN aza_jstats_ipaddresses ON (aza_jstats_visits.ip_id=aza_jstats_ipaddresses.id) WHERE aza_jstats_ipaddresses.type=1 AND aza_jstats_visits.day=06 AND aza_jstats_visits.month=10 AND aza_jstats_visits.year=2024 GROUP by aza_jstats_visits.day
36
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_visits LEFT JOIN aza_jstats_ipaddresses ON (aza_jstats_visits.ip_id=aza_jstats_ipaddresses.id) WHERE aza_jstats_ipaddresses.type=1 AND aza_jstats_visits.day=07 AND aza_jstats_visits.month=10 AND aza_jstats_visits.year=2024 GROUP by aza_jstats_visits.day
37
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_visits LEFT JOIN aza_jstats_ipaddresses ON (aza_jstats_visits.ip_id=aza_jstats_ipaddresses.id) WHERE aza_jstats_ipaddresses.type=1
38
SELECT SQL_BIG_RESULT count(*) FROM aza_jstats_ipaddresses, aza_jstats_visits WHERE (aza_jstats_visits.ip_id = aza_jstats_ipaddresses.id) AND (aza_jstats_ipaddresses.browser !='') AND (aza_jstats_ipaddresses.type =2) AND (aza_jstats_visits.day LIKE '07') AND (aza_jstats_visits.month LIKE '10') AND (aza_jstats_visits.year LIKE '2024')
39
SELECT a.id, a.title, a.sectionid, a.catid
 FROM aza_content AS a
 LEFT JOIN aza_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN aza_categories AS cc ON cc.id = a.catid
 INNER JOIN aza_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 <= '2024-10-07 21:45' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-07 21:45' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
LIMIT 0, 5
40
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 36
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
41
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 58
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
42
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 35
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
43
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 32
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 21
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
45
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM aza_sections as a
 LEFT JOIN aza_content as b ON a.id = b.sectionid
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-10-07 21:45' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-10-07 21:45' )
 WHERE a.scope = 'content'
 AND a.published = 1
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 0, 5
46
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 5
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
47
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
48
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
49
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 4
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
50
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 6
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
51
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 1
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
52
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 aza_content AS i
 LEFT JOIN aza_sections AS s ON i.sectionid = s.id
 LEFT JOIN aza_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN aza_categories AS c ON i.catid = c.id
 LEFT JOIN aza_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 = 2
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id