SELECT *
FROM amaf_session
WHERE session_id = '06l42dgr8la9q5kih5ohovbgg6'
DELETE
FROM amaf_session
WHERE ( TIME < '1680345467' )
SELECT *
FROM amaf_session
WHERE session_id = '06l42dgr8la9q5kih5ohovbgg6'
INSERT INTO `amaf_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '06l42dgr8la9q5kih5ohovbgg6','1680346367','','0','1','0' )
SELECT *
FROM amaf_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM amaf_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM amaf_menu AS m
LEFT JOIN amaf_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM amaf_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 18)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM amaf_content AS a
LEFT JOIN amaf_categories AS cc
ON cc.id = a.catid
LEFT JOIN amaf_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN amaf_users AS u
ON u.id = a.created_by
LEFT JOIN amaf_groups AS g
ON a.access = g.id
WHERE a.id = 57
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-04-01 10:52:47' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-04-01 10:52:47' ) ) OR ( a.state = -1 ) )
UPDATE amaf_content
SET hits = ( hits + 1 )
WHERE id='57'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM amaf_modules AS m
LEFT JOIN amaf_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 18 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *, RAND() AS ordering
FROM amaf_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 33
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT sectionid
FROM amaf_content
WHERE id=57
SELECT s.*
FROM amaf_sections AS s
WHERE s.scope = "content"
AND s.access <= 0
AND (s.id=9)
AND s.id=9
AND s.published = 1
ORDER BY s.title ASC
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM amaf_content AS a
INNER JOIN amaf_categories AS cc
ON cc.id = a.catid
INNER JOIN amaf_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 <= '2023-04-01 10:52:47' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-04-01 10:52:47' )
AND (a.created_by <> 0
AND a.modified_by <> 0)
AND s.id > 0
AND a.access <= 0
AND s.published = 1
AND a.sectionid = 9
AND (a.catid=41)
ORDER BY a.created DESC
LIMIT 0, 5
SELECT id
FROM amaf_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published = 1
AND access IN (0)
SELECT guest, usertype, client_id
FROM amaf_session
WHERE client_id = 0
Modelismo
Esta maqueta, es un modelo de Ibertren, cedida por un querido socio llamado D. José Campoy. Es una maqueta de 1mx2m aproximadamente, la cual ya ha...Read more...
Esta maqueta es la joya de la asociación, es la más antigua y la que más trabajo ha dado, pero los resultados son del todo para sentirse...Read more...