SELECT a.id, a.title, a.alias, a.title_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, 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 <= '2017-08-19 13:10:32' ) AND a.publish_down >= '2017-08-19 13:10:32')) 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 <= '2017-08-19 13:10:32' )))) 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,7) 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

Agenda cultural

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<'2017-07-01 00:00:00' and a.publish_down>='2017-06-01 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 <= '2017-08-19 13:10:32' ) AND a.publish_down >= '2017-08-19 13:10:32')) or (a.publish_down='0000-00-00 00:00:00' and (a.created >= '2017-06-01 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 <= '2017-08-19 13:10:32' )))) 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,7) AND cc.published = 1 AND (cc.id=174 OR cc.id=255 OR cc.id=542 OR cc.id=583)

dl	dt	dc	dj	dv	ds	dg
<<	<	Juny 2017			>	>>
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30

@sbdcultura

Últim dia de FRESHQUIZ! el concurs cultural que es fa a pl. del Treball #Sabadell el 20 d'agost a les 22h.… https://t.co/WsTg0UpuP1

by sbdcultura

RT @Aj_Sabadell: Avui 5 minuts de silenci a les 12 del migdia a l'Ajuntament en solidaritat amb les víctimes de l'atemptat de Barcelona #To…

by sbdcultura

Els dijous d'agost a les 21.30h teniu #cinema a la fresca a La Capella #Sabadell . Trobeu tota la programació aquí:… https://t.co/K1CcKUOADx

by sbdcultura

30 Juny 2017

@sbdcultura

Butlletins electrònics