CA
EN
ES
Inici
Actualitat
L'Ajuntament
Persones
Temes
Tràmits
Contacte
CULTURA
Cultura
Inici
Activitats per tema
Arts escèniques
Música
Festes i tradicions
Literatura i pensament
Arts i patrimoni
Ciencia i tecnologia
Familiar
Cinema i Imatge
Equipaments culturals
Teatre Principal
La Faràndula
Estruch
LaSala
Arxiu històric de Sabadell
Biblioteques
Museus
Casal Pere Quart
Centres Cívics
Entitats culturals
Cartes de Serveis
Publicacions
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<'2017-07-01 00:00:00' and a.publish_down>='2017-06-30 00:00:00') or (a.created<'2017-07-01 00:00:00' and a.publish_down>='2017-07-01 00:00:00')) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 14:49:18' ) AND a.publish_down >= '2018-04-20 14:49:18')) or (a.publish_down='0000-00-00 00:00:00' and (a.created >= '2017-06-30 00:00:00' AND a.created < '2017-07-01 00:00:00' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 14:49:18' )))) AND ((a.metakey like '%cod:4060%' or a.metakey like '%cod:4061%' or a.metakey like '%cod:4062%' or a.metakey like '%cod:4063%' or a.metakey like '%cod:4064%' or a.metakey like '%cod:4065%' or a.metakey like '%cod:4066%' or a.metakey like '%cod:4067%' or a.metakey like '%cod:4095%') ) AND a.language IN ('ca-ES','*') AND a.access IN (1,1,5) AND cc.published = 1 AND (cc.id=174 OR cc.id=255 OR cc.id=542 OR cc.id=583) ORDER BY if (date_format(a.created,'%Y%m%d')=date_format( '2017-06-30 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
30 Juny 2017
Publicacions cultura
Llibret temporada Principal-Faràndula gener-juny 2018
Llibret temporada Estruch gener-juny 2018
Programació LaSala Miguel Hernández 17-18
Programa de Sant Jordi 2018
SORTIM Abril 2018
Calendari Infantil Abril 2018
Butlletins electrònics
