Cultura i esdeveniments

Equipaments

Òrgans de participació

Plans i projectes

select DINAMIC_ITEMS.*,date_format(DINAMIC_ITEMS.Date,'%d') as sday,date_format(DINAMIC_ITEMS.Date,'%m') as smes,date_format(DINAMIC_ITEMS.Date,'%Y') as sany,date_format(DINAMIC_ITEMS.Enddate,'%d-%m-%Y') as datafi from DINAMIC_ITEMS,AMBIT_RELACIO where AMBIT_RELACIO.ID_RELACIO=DINAMIC_ITEMS.Item and DINAMIC_ITEMS.Type=1 and DINAMIC_ITEMS.Published=1 and AMBIT_RELACIO.ID_ITEM=2092 and DINAMIC_ITEMS.Enddate>=SYSDATE() order by Position

Destacats