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 'Roses*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,1' 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 ('Guns N' Roses*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (83362)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Guns N' Roses
Greatest Hits [Grey Vinyls + příloha]
Nosič: 33" LP
Rok vydání: -
původ: -
Lbl.: Not On Label (Guns N' Roses) – 9862108
kat. číslo: B1 3363159
nové zboží, picture disc, barevné, rock
Stav desky: M
- nová, nehraná deska
Stav obalu: M
- bezchybný, nový nebo jako nový
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
zabaleno v originálním celofánu
2LP
Grey Vinyls
+ příloha
A1 Welcome To The Jungle
A2 Sweet Child O' Mine
A3 Patience
A4 Paradise City
B1 Knockin' On Heaven's Door
B2 Civil War
B3 You Could Be Mine
B4 Don't Cry (Original)
C1 November Rain
C2 Live And Let Die
C3 Yesterdays
D1 Ain't It Fun
D2 Since I Don't Have You
D3 Sympathy For The Devil
Cena: 2 000 CZK (79.7 €)
