Inicio Identificar setas Identificar Setas

• Enlaces
• Contactar
• Foro
• Galería
• Artículos
• Eventos
• 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 Usuario clave Recordarme ¿Recuperar clave? ¿Quién está en línea? Contador Visitas ayer: 61 Visitas hoy: 11 Total Visitas: 4060 Bots Hoy: 1 Secciones Socios Gastronomia Identificar Setas Eventos Última hora

A Zarrota by A.E.S.

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 template
 FROM aza_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 61 )
 ORDER BY menuid DESC
LIMIT 0, 1
5
DELETE FROM aza_session
 WHERE (
 ( time < '1675038145' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1675038145' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT jaclplus FROM aza_core_acl_aro_groups WHERE group_id='29'
7
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM aza_stats_agents
 WHERE agent = 'com'
 AND type = 2
12
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
13
SELECT *
 FROM aza_menu
 WHERE id = 61
14
SELECT * FROM aza_jaclplus WHERE aro_section ='users' AND aro_value ='public frontend' AND enable=1
15
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'
16
SELECT value FROM aza_jstats_configuration WHERE description = 'onlinetime'
17
SELECT exclude,type from aza_jstats_ipaddresses where ip='3.235.195.196' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
18
SELECT LENGTH( browser_string ) AS strlen, browser_string, browser_fullname FROM aza_jstats_browsers ORDER BY strlen DESC
19
SELECT LENGTH(bot_string) AS strlen, bot_string,bot_fullname FROM aza_jstats_bots ORDER BY strlen DESC
20
SELECT LENGTH(sys_string) AS strlen,sys_string,sys_fullname FROM aza_jstats_systems ORDER BY strlen DESC
21
insert into aza_jstats_ipaddresses (ip,nslookup,useragent,tld,system,browser,type) values ('3.235.195.196','ec2-3-235-195-196.compute-1.amazonaws.com','ccbot/2.0 (https://commoncrawl.org/faq/)','com','','Unknown robot (identified by crawl)',2)
22
SELECT id from aza_jstats_ipaddresses where ip='3.235.195.196' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
23
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='3636' and time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL 0 HOUR), INTERVAL -10 MINUTE)
24
INSERT INTO aza_jstats_visits (ip_id,hour,day,month,year,time) values (3636,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))
25
SELECT page_id, page_title FROM aza_jstats_pages WHERE page='/index.php?option=com_content&task=view&id=21&Itemid=61'
26
INSERT INTO aza_jstats_page_request (page_id,hour,day,month,year,ip_id) values (504,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)),7045)
27
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 = '61' )
 ORDER BY ordering
28
SELECT id, name, link, parent, type, menutype, access
 FROM aza_menu
 WHERE published = 1
 AND access IN ( 0 )
 ORDER BY menutype, parent, ordering
29
SELECT title, catid, id
 FROM aza_content
 WHERE id = 21
 AND access IN ( 0 )
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=29 AND aza_jstats_visits.month=01 AND aza_jstats_visits.year=2023 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=30 AND aza_jstats_visits.month=1 AND aza_jstats_visits.year=2023 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 '30') AND (aza_jstats_visits.month LIKE '1') AND (aza_jstats_visits.year LIKE '2023')
39
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 <= '2023-01-30 01:37' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2023-01-30 01:37' )
 WHERE a.scope = 'content'
 AND a.published = 1
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
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 = 5
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
41
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
42
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
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 = 4
 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 = 6
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
45
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
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 = 2
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id