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 'Hara And Charlie Dobson Featuring Satellite Singers And Orchestra*' IN BOOLEAN M' 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 ('Hamilton O'Hara And Charlie Dobson Featuring Satellite Singers And Orchestra*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (58316)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Hamilton O'Hara And Charlie Dobson Featuring Satellite Singers And Orchestra
Journey To The Moon
Nosič: 33" LP
Rok vydání: 1974
původ: Spojené státy americké
Lbl.: Golden Records – LP 158
kat. číslo: VT 3342013
mluvené slovo, pohádky, pro děti
Stav desky: NM
- jako nová, téměř nehraná
Stav obalu: EX+
- stopy běžného používání
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
A1 With A Great Big Noise Like Thunder (Rocket Into Space)
A2 Meet Space Pilot Jones
A3 Rocket To The Moon (You Are A Space Scout)
A4 City In Space
A5 Is It Raining In Paris (Weather Satellite)
A6 The Story Of The Planets
B1 The Big T. V. Show In The Sky
B2 50 Round Trips
B3 Put A Penny In The Scale
B4 Window In Space
B5 Sea Of Showers
B6 Rainbow Bay
B7 Great Big Noise
Cena: 500 CZK (19.8 €)
