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(111): 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 Friend*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,' 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 ('Lucifer's Friend*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (91575)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Lucifer's Friend
Lucifer's Friend - 2 Original LP's
Nosič: 33" LP
Rok vydání: 1979
původ: Německo
Lbl.: Philips – 6623 132
kat. číslo: B1 3370033
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
2LP
Lucifer's Friend
A1 Ride The Sky
A2 Everybody's Clown
A3 Keep Goin'
A4 Toxic Shadows
B1 Free Baby
B2 Baby You're A Liar
B3 In The Time Of Job When Mammon Was A Yippie
B4 Lucifer's Friend
Where The Groupies Killed The Blues
C1 Hobo
C2 Rose On The Vine
C3 Mother
D1 ...Where The Groupies Killed The Blues
D2 Prince Of Darkness
D3 Summerdream / Delirium / No Reason Or Rhyme
D4 Burning Ships
Cena: 2 000 CZK (79.8 €)
