TOURNOI TENNIS OPEN SUPER U
Du 08/06/2019 au 23/06/2019
à BRETIGNOLLES-SUR-MER

loisirs-festifs

Tournoi de Tennis Open Super U.|Tournoi organisé par ATC85. Inscriptions par mail à contact@atc85.fr
  • 46.6277584|-1.8572536
SELECT cpap1.id_product, cpap1.value as gps, rm.path FROM cat_product_additionnal_properties cpap1 JOIN cat_product_additionnal_properties cpap2 ON cpap1.id_product =  cpap2.id_product JOIN zephyr_marker_event zem ON cpap2.value = zem.value JOIN ressource_media rm ON rm.id_media = zem.id_media WHERE cpap1.id_champs = 5 AND cpap2.id_champs = 9 AND cpap1.id_product = "23454"