SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 2)
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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.section
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 36
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 10:17:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 10:17:13' ) ) OR ( a.state = -1 ) )
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(36)
AND jf_content.reference_table='content'
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='36'
SELECT a.id, 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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 3
AND a.state = 1
AND a.access <= 0
AND ( a.state = 1 OR a.state = -1 )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-21 10:17:13' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-21 10:17:13' )
ORDER BY a.ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(110,109,108,107,104,106,105,101,100,99,98,96,95,93,80,79,78,77,76,75,51,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,3,2)
AND jf_content.reference_table='content'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_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 = 2 OR mm.menuid = 0 )
ORDER BY position, ordering
Este viernes participamos en la presentación de la revista en línea de Hangar con una nueva propuesta de arte codeco muy dulce, el BITELATE, para la que recomendamos que vengas con un lector de códigos QR preparado en tu móvil. El evento tendrá lugar en el Espai UBU en Barcelona, este viernes 18 a partir de las 20:30h. ¡¡Os esperamos!!
También este viernes. El programa de TVE Metrópolis estádedicado al Arte Low Tech, e incluirán nuestro vídeo ANIM 01, que recientemente ha recibido el primer premio en la categoría experimental en Curtas na rede. Metrópolis se emite el viernes 18 en el canal Cultural.es y el domingo 20 a las 00:30 en La 2. También se repite en el canal internacional de TVE.
