Música

Publicacions cultura

Opuscle dels 100 Anys de la Colla de Sabadell

Agenda cultural

Consulta totes les entitats culturals de Sabadell

Butlletins electrònics

No s'han trobats resultats.

SELECT distinct date_format(a.created,'%Y-%m-%d') as created ,date_format(a.publish_down,'%Y-%m-%d') as publish_down 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<'2020-05-01 00:00:00' and a.publish_down>='2020-04-01 00:00:00') or (a.created<'2020-05-01 00:00:00' and a.publish_down>='2020-05-01 00:00:00')) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-08 06:45:10' ) AND a.publish_down >= '2020-04-08 06:45:10')) or (a.publish_down='0000-00-00 00:00:00' and (a.created >= '2020-04-01 00:00:00' AND a.created < '2020-05-01 00:00:00' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-04-08 06:45:10' )))) 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 cc.published = 1 AND (cc.id=174 OR cc.id=255 OR cc.id=542 OR cc.id=583)

abril 2020