remso.eu

Sounding Calendar for Europe


Media List of
  (2)


  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.

2 data records found

Interpret
Titel
  <= click   enter new media (Audio, Video)
  Die Erkenntnis   video/de 3:48   no
Shanty Chor "Die Luttermöwen"
  Shanty Chor "Die Luttermöwen" 20. FrieFrüh   video/ 8:18   no
Shanty Chor "Die Luttermöwen"

x   p531_de | remso's gast | 0.008 sec.


# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#  veranstalter lesen
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT
 adr1.id      VIP
,adr1.firma1
FROM      bia_adressen adr1
WHERE     adr1.id     = '858'
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 = '858' # sql_adress_id
 # sql_titel
 # sql_interpret
ORDER BY  sort_mainka, med1.interpret, med1.titel