Inicio

• 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: 78 Visitas hoy: 50 Total Visitas: 30543 Bots Hoy: 19 Secciones Socios Gastronomia Identificar Setas Eventos Última hora

Micologia Enlaces relacionados con la Micologia   Enlaces Web Accesos      Setas de Moncayo Una página recien nacida de nuestros compañeros Navarros 1534      Laboratorio de Micoloxía Universidad de Vigo 1502      Las Fotografias de Bryona Impresionantes fotos de setas de este colaborador de A Zarrota, muchas de sus fotos, las podemos disfrutar en nuestra Galería, 1627      A Cantarela (Vilagarcia) Pagina de la asociacion micologica "A Cantarela" de Villagarcia de Arosa 1823      O Coto Páxina Web da Asociación Cultural 'O Coto' 2723      Associació micológica Joaquim Codina Asociación Micológica Joaquim Codina 1397      Micologia.Net Excelente página sobre micología 1874   Comerciales   (2) Naturaleza   (2) Micologia   (7) [Volver]

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 = 22 )
 ORDER BY menuid DESC
LIMIT 0, 1
5
DELETE FROM aza_session
 WHERE (
 ( time < '1713985225' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713985225' )
 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 = 'Mozilla 5.0'
 AND type = 0
8
UPDATE aza_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 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 = 22
14
SELECT id, url, title, description, date, hits, params
 FROM aza_weblinks
 WHERE catid = 2
 AND published = 1
 AND archived = 0
 ORDER BY ordering
15
SELECT *
 FROM aza_categories
 WHERE id = 2
 AND published = 1
 AND access IN ( 0 )
16
SELECT cc.*, a.catid, a.title, a.url, COUNT(a.id) AS numlinks
 FROM aza_categories AS cc
 LEFT JOIN aza_weblinks AS a ON a.catid = cc.id
 WHERE a.published = 1
 AND section = 'com_weblinks'
 AND cc.published = 1
 AND cc.access IN ( 0 )
 GROUP BY cc.id
 ORDER BY cc.ordering
17
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'
18
SELECT value FROM aza_jstats_configuration WHERE description = 'onlinetime'
19
SELECT exclude,type from aza_jstats_ipaddresses where ip='18.119.131.178' and useragent='mozilla/5.0 applewebkit/537.36 (khtml, like gecko; compatible; claudebot/1.0; +claudebot@anthropic.com)'
20
SELECT LENGTH( browser_string ) AS strlen, browser_string, browser_fullname FROM aza_jstats_browsers 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 ('18.119.131.178','ec2-18-119-131-178.us-east-2.compute.amazonaws.com','mozilla/5.0 applewebkit/537.36 (khtml, like gecko; compatible; claudebot/1.0; +claudebot@anthropic.com)','com','','Mozilla ',1)
23
SELECT id from aza_jstats_ipaddresses where ip='18.119.131.178' and useragent='mozilla/5.0 applewebkit/537.36 (khtml, like gecko; compatible; claudebot/1.0; +claudebot@anthropic.com)'
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='20660' 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 (20660,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?option=com_weblinks&catid=2&Itemid=22'
27
INSERT INTO aza_jstats_page_request (page_id,hour,day,month,year,ip_id) values (499,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)),54053)
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 = '22' )
 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=23 AND aza_jstats_visits.month=04 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=24 AND aza_jstats_visits.month=4 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 '24') AND (aza_jstats_visits.month LIKE '4') AND (aza_jstats_visits.year LIKE '2024')
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 <= '2024-04-24 21:15' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-24 21:15' )
 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