Succursales

• Magog
• Jacques Cartier

À venir . . . SELECT caffu_postmeta.meta_value date FROM caffu_posts, caffu_postmeta, caffu_term_relationships, caffu_term_taxonomy, caffu_terms WHERE caffu_posts.ID = caffu_postmeta.post_id AND caffu_posts.ID = caffu_term_relationships.object_id AND caffu_term_relationships.term_taxonomy_id = caffu_term_taxonomy.term_taxonomy_id AND caffu_term_taxonomy.term_id = caffu_terms.term_id AND caffu_posts.post_type = 'evenements' AND caffu_posts.post_status = 'publish' AND caffu_postmeta.meta_key = 'evm_date' AND caffu_term_taxonomy.taxonomy = 'restaurants' AND caffu_terms.slug IN ('magog','jacques-cartier') GROUP BY YEAR(STR_TO_DATE(caffu_postmeta.meta_value, '%%Y%%m%%d')), MONTH(STR_TO_DATE(caffu_postmeta.meta_value, '%%Y%%m%%d')) ORDER BY caffu_postmeta.meta_value ASC mai 2020