Salut i prevenció

Agenda d'activitats

ESTIMA'T

De dimecres 10 d'octubre de 2018 a dimecres 28 de novembre de 2018, dimecres de 17 a 18.30 h

Complex Gent Gran Sant Oleguer.

Llegir més...

XERRADA DIVULGATIVA SOBRE EL CÀNCER

Dimarts 4 de desembre de 2018, A les 17 h

Complex Parc Central.

Llegir més...

Agost 2018

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<'2018-09-01 00:00:00' and a.publish_down>='2018-08-01 00:00:00') or (a.created<'2018-09-01 00:00:00' and a.publish_down>='2018-09-01 00:00:00')) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-21 04:48:31' ) AND a.publish_down >= '2018-08-21 04:48:31')) or (a.publish_down='0000-00-00 00:00:00' and (a.created >= '2018-08-01 00:00:00' AND a.created < '2018-09-01 00:00:00' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-21 04:48:31' )))) AND (a.metakey like '%cod:41281-------%' or a.metakey like '%cod:41282-------%' or a.metakey like '%cod:41283-------%' or a.metakey like '%cod:41284-------%' or a.metakey like '%cod:41285-------%' or a.metakey like '%cod:41286-------%') AND a.language IN ('ca-ES','*') AND cc.published = 1 AND (cc.id=174)