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-02') AND (zo.island LIKE 'Pitiusas') 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-03') AND (zo.island LIKE 'Pitiusas') 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-04') AND (zo.island LIKE 'Pitiusas') 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-05') AND (zo.island LIKE 'Pitiusas') 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-06') AND (zo.island LIKE 'Pitiusas') 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-07') AND (zo.island LIKE 'Pitiusas') 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-08') AND (zo.island LIKE 'Pitiusas') ORDER BY `emphasized` DESC, `start_date` ASC