Concert
Escorca - Torrent de Pareis - 17:30
XLIX Concert al Torrent de Pareis, a càrrec de Cap Pela
Commemoració Any Coll Bardolet en el centenari del seu naixement.
 |
juliol |
 |
Carnet Jove
Joves
Programa d'activitats educatives 2012/13
Web de BMN-SA NOSTRA
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-06-25') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-06-26') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-06-27') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-06-28') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-06-29') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-06-30') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC
SELECT `a`.`id` FROM `peagendas` AS `a`
INNER JOIN `presselements` AS `pe` ON a.id_presselement = pe.id
INNER JOIN `locations` AS `lo` ON lo.id = pe.id_location
INNER JOIN `zones` AS `zo` ON zo.id = lo.id_zone WHERE (a.end_date IS NULL) AND (pe.published = 1) AND (pe.id_creationdomain = 1) AND (DATE_FORMAT(start_date,'%Y-%m-%d')='2012-07-01') AND (zo.island LIKE 'Part Forana') ORDER BY `emphasized` DESC, `start_date` ASC