remso.eu

Sounding Calendar for Europe


Media List of
  (8)


  modify, copy or delete existing media

      Info:   Datei (URL) ist   ok erreichbar   no nicht erreichbar.

Suchbegriff

Es werden Interpreten / Titel gefunden, die den Suchbegriff enthalten.

8 data records found

Interpret
Titel
  <= click   enter new media (Audio, Video)
  De Hamborger Veermaster   mp3/nds 0:47   no
Album: Wenn leise die Wellen singen
Bremer Shanty-Chor von 1978
  Essequibo River   mp3/en 0:50   no
Album: The leaving of Liverpool
Solist: Friedhelm Heise
Bremer Shanty-Chor von 1978
  Leave Her, Johnny   mp3/en 1:36   no
Album: When The Ship Comes In
Bremer Shanty-Chor von 1978
  Leaving of Liverpool   mp3/en 1:02   no
Album: The leaving of Liverpool
Solist: C. Preiss-Daimler
Bremer Shanty-Chor von 1978
  Pressgang   mp3/en 3:48   no
Album: SEEKRANK
Bremer Shanty-Chor von 1978
  Rolling Home   mp3/nds 0:53   no
Album: Wenn leise die Wellen singen
Bremer Shanty-Chor von 1978
  The Bonny Ship The Diamond   mp3/en 1:27   no
Album: When The Ship Comes In
Bremer Shanty-Chor von 1978
  The Greenland whale fisheries   mp3/en 3:37   no
Album: SEEKRANK
Bremer Shanty-Chor von 1978

x   p531_de | remso's gast | 0.009 sec.


# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#  veranstalter lesen
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 adr1.id      VIP
,adr1.firma1
FROM      bia_adressen adr1
WHERE     adr1.id     = '571'
OR        adr1.firma1 = ''

# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#  LISTE ANZEIGEN, DIV. SORTIERUNGEN
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 SQL_CALC_FOUND_ROWS
 med1.medium_code
,med1.sprache
,med1.album
,med1.id
,med1.adress_id       VIP
,med1.interessent_id  ITR
,med1.dauer_min_sec
,IF ( med1.interpret IS NULL, adr1.firma1, med1.interpret ) interpret
,IF ( '' > ' ' AND INSTR(med1.interpret,'Mainka'), 0, 1 ) sort_mainka
,med1.titel
,med1.genre
,med1.solist
,med1.url
,med1.header_status
,med1.medien_art
,med1.video_embed
,med1.dauer_min_sec
,med1.zeit_erreichbar

FROM      bia_medien med1

LEFT JOIN bia_adressen adr1
ON        adr1.id     = med1.adress_id
AND       adr1.loe_kz = 0

WHERE     med1.owner_id = 1
AND med1.adress_id = '571' # sql_adress_id
 # sql_titel
 # sql_interpret
ORDER BY  sort_mainka, med1.interpret, med1.titel