An exception was thrown :
Exception code : 0
Exception message :
#0 /data/web/virtuals/38425/virtual/www/inc/mysql.class.php(173): mysql->error('SELECT LP.*,CAT...',...)
#1 /data/web/virtuals/38425/virtual/www/inc/lp.class.php(62): mysql->query('SELECT LP.*,CAT...',...)
#2 /data/web/virtuals/38425/virtual/www/templates/vinyl-detail.tpl(78): LP->getLP('SELECT LP.*,CAT...',...)
#3 /data/web/virtuals/38425/virtual/www/inc/phptemplate.class.php(81): require_once('/data/web/virtu...')
#4 /data/web/virtuals/38425/virtual/www/inc/phptemplate.class.php(138): PHPTemplate->fetch('templates/vinyl...')
#5 /data/web/virtuals/38425/virtual/www/index.php(105): PHPTemplate->load('content',...)
#6 {main}
error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Chorus, Jiří Chvála, Prague Radio Symphony Orchestra, František Vajnar*' I' at line 10
query: SELECT LP.*,CAT.name_cz as catname, CNT.name_cz as countryname, CNT.code as countrycode, GROUP_CONCAT(GEN.name_cz ORDER BY GEN.name_cz SEPARATOR ', ') as genres,
COALESCE((SELECT IM.name FROM lpimage AS IM WHERE IM.position='1' AND IM.idlp=LP.id),0) as mainimg, USR.inicials,
DATE_FORMAT(LP.dt_insert,'%Y') as year_insert, DATE_FORMAT(LP.dt_insert,'%m') as month
FROM lp AS LP
JOIN user USR ON USR.id = LP.iduser
JOIN country CNT ON CNT.id = LP.idcountry
JOIN category CAT ON CAT.id = LP.idcategory
JOIN vz_lp_genre VZLG ON VZLG.idlp = LP.id
JOIN genre GEN ON GEN.id = VZLG.idgenre
WHERE MATCH(groupname) AGAINST ('Erwin Schulhoff, Prague Radio Chorus, Milan Malý, Kühn Children's Chorus, Jiří Chvála, Prague Radio Symphony Orchestra, František Vajnar*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (71282)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Erwin Schulhoff, Prague Radio Chorus, Milan Malý, Kühn Children's Chorus, Jiří Chvála, Prague Radio Symphony Orchestra, František Vajnar
The Communist Manifesto
Nosič: 33" LP
Rok vydání: 1977
původ: Česká republika
Lbl.: Supraphon – 1 12 2100
kat. číslo: AD 3352281
klasická hudba, opera
Stav desky: NM
- jako nová, téměř nehraná
Stav obalu: M-
- bezchybný, nový nebo jako nový
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
A1 It Is High Time (a. Moderato) 4:00
A2 It Is High Time (b. Marcia) 2:00
A3 Ours Is The World (a. Allegro ma non troppo - Andante) 4:55
A4 Ours Is The World (b. Moderato pesante) 1:45
A5 Ours Is The World (c. Marcia) 2:40
A6 Ours Is The World (d. Allegro pesante) 1:15
A7 Ours Is The World (e. Tempo di Marcia) 3:55
B1 That Is Just What We Intend! (a. Allegro pesante) 5:30
B2 That Is Just What We Intend! (b. Largo pesante) 6:45
B3 Unite! (Marcia) 3:20100
Cena: 1 000 CZK (39.6 €)
