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(114): 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 Oblivion Express*' IN BOOLEAN MODE)
AND LP.state 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 ('Brian Auger's Oblivion Express*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (14040)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Artist
Brian Auger's Oblivion Express
Album
A Better Land
Nosič:
33" LP
Rok vydání:
1971
původ:
Spojené státy americké
kat. číslo:
PN 3311003
Label:
RCA – LSP 4540
jazz, swing, rock, soul, funk
A1 Dawn Of Another Day 4:18
A2 Marai's Wedding 4:22
A3 Trouble 8:12
A4 Women Of The Seasons 5:00
B1 Fill Your Head With Laughter 3:49
B2 On Thinking It Over 5:23
B3 Tomorrow City 3:30
B4 All The Time There Is 3:29
B5 A Better Land 5:30
Bass, Vocals – Barry Dean
Drums, Percussion – Robbie McIntosh (2)
Electric Guitar, Acoustic Guitar, Vocals – Jim Mullen
Engineer – Eddie "The Knife" Offord*
Organ, Electric Piano, Piano, Vocals – Brian Auger
Producer – Brian Auger
Very mellow album - I don't like saying this about music but it happens to be great to put on in the background. "Marai's Wedding" does stand out from the rest, though, featuring some very catchy hooks.
The spectacular album artwork really shines on the vinyl release
================================================================
Exelent.
The band concentrates on songwriting (and do this very well) rather than endless fusion jamming.
Consistent songwriting, great songs.
great album to start Your introduction to this band.
Highly recomended :)
===============================================================