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 Last Recording feat. Jimmy Page, Brian Auger, Joe Harriot, Alan Skidmore*' IN ' 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 ('Rock Generation - Sonny Boy Williamson's Last Recording feat. Jimmy Page, Brian Auger, Joe Harriot, Alan Skidmore*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (42782)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Rock Generation - Sonny Boy Williamson's Last Recording feat. Jimmy Page, Brian Auger, Joe Harriot, Alan Skidmore
Rock Generation Volume 10 - Julie Driscoll's First Recordings And Sonny Boy Williamson's Last
Nosič: 33" LP
Rok vydání: 1972
původ: Francie
Lbl.: BYG Records 529.710
kat. číslo: VT 3329735
blues, rock
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
Julie Driscoll's First Recordings
Recorded In London Between 1964 & 1967
A1 –Julie Driscoll I Know You Love Me Not
A2 –Julie Driscoll I Didn't Want To Have To Do It
A3 –Julie Driscoll If You Should Ever Leave Me
A4 –Julie Driscoll Don't Do It No More
A5 –Julie Driscoll I Don't Know Where You Are
A6 –Julie Driscoll Shadows Of You
Sonny Boy Williamson's Last Recording
Recorded London, April 1964
B1 –Sonny Boy Williamson (2) Walking
B2 –Sonny Boy Williamson (2) Little Girl, How Old Are You
B3 –Sonny Boy Williamson (2) It's A Bloody Life
B4 –Sonny Boy Williamson (2) Getting Out Of Town
Cena: 500 CZK (19.8 €)
