Musik
Frittenbude
Video via Youtube streamen
- Highfield Festival 2020
- Open Flair Festival 2019
- Deichbrand Rockfestival 2019
- Taubertal Festival 2019
- Highfield Festival 2017
- Southside Festival 2017
- Hurricane Festival 2017
- Rock am Ring 2016
- Rock im Park 2016
 / 180) * SIN(postmeta.meta_value * PI() / 180) + COS(52.376482509 * PI() / 180) * COS(postmeta.meta_value * PI() / 180) * COS((9.71097958017 - place_longitude.meta_value) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance,
FROM wp_postmeta,
wp_posts,
wp_postmeta AS postmeta
LEFT JOIN wp_postmeta as place_longitude ON postmeta.post_id = place_longitude.post_id
INNER JOIN wp_posts ON wp_posts.ID = postmeta.post_id
WHERE wp_posts.post_type = 'event' AND (wp_.postmeta.meta_key = 'start_time'
AND wp_postmeta.meta_value BETWEEN '2017-11-07%' AND '2017-11-13%') AND postmeta.meta_key = 'place_latitude' AND place_longitude.meta_key = 'place_longitude'
HAVING distance < 35
ORDER BY distance ASC
/sddefault.jpg)
ZSK
Video via Youtube streamen
- With Full Force Festival 2020
- Open Flair Festival 2019
- Punk im Pott 2019
- Highfield Festival 2018
- Ruhrpott Rodeo 2018
- Ruhrpott Rodeo 2017
