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: 53 Visitas hoy: 1 Total Visitas: 40401 Bots Hoy: 4 Secciones Socios Gastronomia Identificar Setas Eventos Última hora

Comerciales Lugares de venta de productos micológicos o relacionados con la naturaleza.   Enlaces Web Accesos      Hogar Del Libro Libros 1192      Hifas da Terra 1603   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 < '1726697698' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1726697698' )
 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 = 22
14
SELECT id, url, title, description, date, hits, params
 FROM aza_weblinks
 WHERE catid = 14
 AND published = 1
 AND archived = 0
 ORDER BY ordering
15
SELECT *
 FROM aza_categories
 WHERE id = 14
 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='98.82.140.17' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
20
SELECT id from aza_jstats_ipaddresses where ip='98.82.140.17' and useragent='ccbot/2.0 (https://commoncrawl.org/faq/)'
21
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='26687' and time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL 0 HOUR), INTERVAL -10 MINUTE)
22
INSERT INTO aza_jstats_visits (ip_id,hour,day,month,year,time) values (26687,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))
23
SELECT page_id, page_title FROM aza_jstats_pages WHERE page='/index.php?option=com_weblinks&catid=14&Itemid=22'
24
INSERT INTO aza_jstats_page_request (page_id,hour,day,month,year,ip_id) values (517,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)),71246)
25
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
26
SELECT id, name, link, parent, type, menutype, access
 FROM aza_menu
 WHERE published = 1
 AND access IN ( 0 )
 ORDER BY menutype, parent, ordering
27
SELECT m.*
 FROM aza_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
28
SELECT m.*
 FROM aza_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
29
SELECT COUNT( id )
 FROM aza_menu 
 WHERE type = 'content_item_link'
 AND published = 1
30
SELECT id
 FROM aza_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=36'
31
SELECT guest, usertype
 FROM aza_session
32
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=18 AND aza_jstats_visits.month=09 AND aza_jstats_visits.year=2024 GROUP by aza_jstats_visits.day
33
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=19 AND aza_jstats_visits.month=9 AND aza_jstats_visits.year=2024 GROUP by aza_jstats_visits.day
34
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
35
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 '19') AND (aza_jstats_visits.month LIKE '9') AND (aza_jstats_visits.year LIKE '2024')
36
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-09-19 00:29' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-09-19 00:29' )
 WHERE a.scope = 'content'
 AND a.published = 1
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 0, 5
37
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
38
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
39
SELECT id 
 FROM aza_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
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 = 4
 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 = 6
 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 = 1
 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 = 2
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id