CA
EN
ES
Inauguració
Cloenda
Fils de la festa
La festa tradicional
L'envelat i els balls
I a la nit...
La Festa dels Joves
La Festa de Punta a Punta
Activitats
Cultura popular
La festa familiar i infantil
Música i balls
Exposicions
Fires
Itineraris i visites
Teatre i humor
Barraques
Altres activitats
Espais
Equipaments
Casal Pere Quart
L'Estruch
Museu d'Art
Museu d'Història
Espais oberts
Eix Macià-Parc Catalunya
Passeig de la Plaça Major
Avinguda Concòrdia
Plaça St. Roc
Avinguda Barberà
Plaça Vallès
Plaça Marcet
Plaça de Gabriel Pujol
Plaça del Gas
Altres
Festa esportiva
Curses
Bicicletades
Torneigs
Exhibicions
Altres
Info general
Mobilitat i Transport
Informació per a cercaviles segures
Seguretat a la Festa Major
Organització i patrocini
Avisos
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.created >= '2018-02-14 00:00:00' AND a.created < '2018-02-15 00:00:00' AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-14 14:20:20' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-08-14 14:20:20' ) AND a.language IN ('ca-ES','*') AND a.access IN (1,1,5) AND cc.published = 1 AND (cc.id=255) ORDER BY a.created ASC
14 Febrer 2018
