SELECT GROUP_CONCAT(p.vertrekmaand) AS maanden FROM shop_products AS p JOIN shop_pro_cat AS pc ON pc.product_id=p.id JOIN shop_category AS c2 ON c2.id=pc.cat_id JOIN shop_category AS c1 ON c1.id=c2.parent_cat_id WHERE p.tonen<>0 AND p.tonen_overzicht<>0 AND p.`Start datum (jjjjmmdd)`<=CURDATE() AND p.`Eind datum (jjjjmmdd)`>CURDATE() AND p.vertrekmaand<>'' AND c2.id IN (26 ) AND p.reissoort IN ('Strandvakanties' ) ORDER BY p.aanbieding, p.volgorde DESC, p.vanafprijs ASC