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 And The Papa's*' IN BOOLEAN MODE)
AND LP.state IN (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 ('Mama's And The Papa's*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (53172)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
Mama's And The Papa's
If You Can Believe Your Eyes And Ears
Nosič: 33" LP
Rok vydání: 1966
původ: Spojené státy americké
Lbl.: Dunhill – DS-50006
kat. číslo: VT 3337496
folk, ethno, trampské, rock
Stav desky: EX
- hraná deska, běžné stopy používání (drobné škrábance a šum nebránící normálnímu poslechu)
Stav obalu: EX
- stopy běžného používání
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
A1 Monday, Monday
A2 Straight Shooter
A3 Got A Feelin'
A4 I Call Your Name
A5 Do You Wanna Dance
A6 Go Where You Wanna Go
B1 California Dreamin'
B2 Spanish Harlem
B3 Somebody Groovy
B4 Hey Girl
B5 You Baby
B6 In Crowd
Cena: 800 CZK (31.9 €)
