SELECT * FROM Reviews ORDER by ID DESC SELECT * FROM Konzerte WHERE Datum >= '#DateFormat(Now(), "yyyy.mm.dd")#' ORDER by Datum ASC SELECT * FROM Konzert_berichte ORDER by KonzertID DESC SELECT * FROM Bands ORDER by BandID DESC SELECT * FROM News WHERE Startseite = 1 ORDER by NewsID DESC SELECT post_date, post_title, post_name FROM wp_posts WHERE post_status = 'publish' ORDER by post_date DESC SELECT wp_comments.comment_post_ID, wp_comments.comment_author, wp_comments.comment_date, wp_comments.comment_content, wp_posts.post_name, wp_posts.post_date FROM wp_comments JOIN wp_posts ON wp_comments.comment_post_ID = wp_posts.ID WHERE wp_comments.comment_approved = 1 ORDER by wp_comments.comment_date DESC SELECT * FROM News_Kommentar ORDER by Datum DESC SELECT Kommentar.Name, Kommentar.Datum, Kommentar.Kommentar, Reviews.Band, Reviews.Album FROM Kommentar JOIN Reviews ON Kommentar.BandID = Reviews.DiscoID ORDER BY Datum DESC SELECT Konzert_Kommentar.Name, Konzert_Kommentar.Datum, Konzert_Kommentar.Kommentar, Konzert_berichte.BandName, Konzert_berichte.Location FROM Konzert_Kommentar JOIN Konzert_berichte ON Konzert_Kommentar.BandID = Konzert_berichte.KonzertID ORDER BY Datum DESC

reviews

#Band# - #Album#

Tag: Remixalbum

Tag: out-of-space.ch-Tipp

Tag: out-of-space.ch-Classic

Tag: Mini-Review

Tag: Gurke

#Left(content, 100)#...

blog

#DateFormat(post_date, "dd.mm.yy")#:
#post_title#

konzertberichte

#DateFormat(Datum, "dd.mm.yy")#:
#BandName# @ #Location#

bandprofile

#BandName# #Left(Bio, 100)#...

neue

kommentare

#DateFormat(Datum, "dd.mm.yy")# #Left(Name, 7)#...: #Left(Kommentar, 30)#... #DateFormat(Datum, "dd.mm.yy")# #Name#: #Left(Kommentar, 30)#... #DateFormat(Datum, "dd.mm.yy")# #Left(Name, 7)#...: #Kommentar#... #DateFormat(Datum, "dd.mm.yy")# #Name#: #Kommentar#...

Zu Releases:

#DateFormat(Datum, "dd.mm.yy")# #Left(Name, 7)#...: #Left(Kommentar, 30)#... #DateFormat(Datum, "dd.mm.yy")# #Name#: #Left(Kommentar, 30)#... #DateFormat(Datum, "dd.mm.yy")# #Left(Name, 7)#...: #Kommentar#... #DateFormat(Datum, "dd.mm.yy")# #Name#: #Kommentar#...

Zu Konzertberichten:

#DateFormat(Datum, "dd.mm.yy")# #Left(Name, 7)#...: #Left(Kommentar, 30)#... #DateFormat(Datum, "dd.mm.yy")# #Name#: #Left(Kommentar, 30)#... #DateFormat(Datum, "dd.mm.yy")# #Left(Name, 7)#...: #Kommentar#... #DateFormat(Datum, "dd.mm.yy")# #Name#: #Kommentar#...

#DateFormat(comment_date, "dd.mm.yy")# #Left(comment_author, 7)#...: #Left(comment_content, 30)#... #DateFormat(comment_date, "dd.mm.yy")# #comment_author#: #Left(comment_content, 30)#... #DateFormat(comment_date, "dd.mm.yy")# #Left(comment_author, 7)#...: #comment_content#... #DateFormat(comment_date, "dd.mm.yy")# #comment_author#: #comment_content#...

out-of-space.ch

news

#DateFormat(Datum, "dd.mm.yy")#:

#Titel#

#Titel#

#Left(Content, 200)#...

termine

#DateFormat(Datum, "dd.mm.yy")# #Name#
Location: #Location#