CA
EN
ES
Inici
Actualitat
L'Ajuntament
Persones
Temes
Tràmits
Contacte
SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.language, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured,a.state,a.created,a.created_by,cc.title AS category_title, cc.path AS category_route, cc.access AS category_access, cc.alias AS category_alias FROM #__content AS a INNER JOIN #__categories AS cc ON cc.id = a.catid WHERE a.state = 1 AND ((a.publish_down<>'0000-00-00 00:00:00' and (((a.created<'2018-04-24 00:00:00' and a.publish_down>='2018-04-23 00:00:00') or (a.created<'2018-04-24 00:00:00' and a.publish_down>='2018-04-24 00:00:00')) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 14:46:22' ) AND a.publish_down >= '2018-04-20 14:46:22')) or (a.publish_down='0000-00-00 00:00:00' and (a.created >= '2018-04-23 00:00:00' AND a.created < '2018-04-24 00:00:00' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 14:46:22' )))) AND (not a.metakey like '%cod:4230-%' and not a.metakey like '%cod:4104-%' and not a.metakey like '%cod:4105-%') AND a.language IN ('es-ES','*') AND a.access IN (1,1,5) AND cc.published = 1 AND (cc.id=174) ORDER BY if (date_format(a.created,'%Y%m%d')=date_format( '2018-04-23 00:00:00','%Y%m%d') and (date_format(a.created,'%Y%m%d')=date_format(a.publish_down, '%Y%m%d') or a.publish_down is null) ,0,1), a.ordering ASC
23 Abril 2018
PARADETA VENDA DE ROSES DE SANT JORDI
PARADETA VENDA DE ROSES DE SANT JORDI
Dilluns 23 d'abril de 2018, De 8 a 20 h
Església de la Puríssima Concepció.
Leer más..
ARBRE DE PARAULES. TALLER
ARBRE DE PARAULES. TALLER
Dilluns 23 d'abril de 2018, De 9 a 21 h
Passeig de la Plaça Major.
Leer más..
PARADETA VENDA SANT JORDI DE L'AMPA ESCOLA TERESA CLARAMUNT
PARADETA VENDA SANT JORDI DE L'AMPA ESCOLA TERESA CLARAMUNT
Dilluns 23 d'abril de 2018, De 9 a 19 h
Escola Teresa Claramunt.
Leer más..
DIADA DE SANT JORDI: FIRA D'ENTITATS AL PASSEIG
DIADA DE SANT JORDI: FIRA D'ENTITATS AL PASSEIG
Dilluns 23 d'abril de 2018, A les 9 h
Passeig de la Plaça Major.
Leer más..
CONTES PELS PETITS
CONTES PELS PETITS
Dilluns 23 d'abril de 2018, De 9 a 11 h
Biblioteca del Nord.
Leer más..
FIRA DE SANT JORDI
FIRA DE SANT JORDI
Dilluns 23 d'abril de 2018, A les 9 h
Passeig de la Plaça Major.
Leer más..
Página 1 de 104
Inicio
Anterior
1
2
3
4
5
6
7
8
9
10
Siguiente
Final