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 'n'B Meets Northern Soul*' IN BOOLEAN MODE)
AND LP.stat' 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 ('R'n'B Meets Northern Soul*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (27116)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Detail produktu
R'n'B Meets Northern Soul
R'n'B Meets Northern Soul Volume 1 ,2 ,3
Nosič: 33" LP
Rok vydání: 2009
původ: Německo
Lbl.: V.O.R. – V.O.R. LP 113
kat. číslo: PN 3320367
jazz, swing, R 'n' B, soul, funk
Stav desky: M
- nová, nehraná deska
Stav obalu: M
- bezchybný, nový nebo jako nový
Pozn.: znaménko + nebo - upřesňuje stav desky, obalu
A1 –Willie Jones Where's My Money
A2 –Fred Bridges Baby Don't You Weep
A3 –Curtis Knight Voodoo Woman
A4 –Len Johnson) One Day
A5 –Bobby Marchan Booty Green
A6 –Gene Martin Lonely Nights
A7 –Sarah Vaughn Mama (He Treats Your Daughter Mean)
A8 –Gene Martin I Got The Blues
A9 –Diane Barnes I Need Your Love Tonight
A10 –Little Sonny We Got A Groove
B1 –Billy Preston Volcano
B2 –Dorothy Prince I Lost A Love
B3 –Bill Baker Another Sleepless Night
B4 –John Scott It's You
B5 –Leroy Jones It's All Right
B6 –Big Boy Myles She's So Fine
B7 –Jimmy Outle It's All Over
B8 –The Captions Hanky Panky
B9 –Eli Lee I Get The Feelin'
A1 –Sherri Taylor He's The One Who Rings My Bell
A2 –George Allan Come On Home
A3 –Jimmy Ellis Puttin It On Your Mind
A4 –Mary Ann Fisher It's A Man's World
A5 –Cornerstone Trio Summertime
A6 –Willie Mabon Got To Have Some
A7 –Jimmy Braswell* Some Changes Made
A8 –Tony Clarke Love Must Be Taboo
A9 –Tammy James That's Fat Jack
A10 –Fred Lowery Can't Get Enough Of My Baby's Lovin
B1 –Sarah Vaughn Mama
B2 –A.C. Reed I Got Money To Burn
B3 –Johnny Williams Honey Child
B4 –Buddy Ace True Love Money Can't Buy
B5 –Pat Harvey Pain
B6 –Dorothy Price I Lost A Love
B7 –Nelson Sanders Your Sweet Love
B8 –Susan King Building A Wall Arond My Heart
B9 –Betty Everett My Love
B10 –Jimmy Ricks Oh! What A Feeling
A1 –The Peaches Don't Take My Man
A2 –Frances Burr With The K. J. Trio I Say No, No More
A3 –George Lee Don't Let Him In
A4 –Ted Taylor Look Out
A5 –Ludaway The Pig
A6 –Marty Barris You're My Thrill
A7 –James Velvet Bouquet Of Flowers
A8 –David Gibson Can't Do Nothing
A9 –Chris & Stella Towns Nearer & Dearer
A10 –Junior Wells Cha Cha Cha In Blue
B1 –Allen Wayne Chills & Fever
B2 –Rosco Gordon Just A Little Bit
B3 –Piney Brown Sugar In My Tea
B4 –Ted Taylor Dancing Annie
B5 –Big Mama Thornton My Man Called Me
B6 –Jimmy Greene Girl Like Mine
B7 –Barbara Randolph Sweet Daddy Tree Top Tall
B8 –Junior Wells Little By Little
B9 –Lamp Sisters No Cure For The Blues
B10 –Jimmy Johnson & The Lucky Hearts Get It
Cena: 3 000 CZK (119.8 €)
