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 €)
 

Ostatní náhledy

R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3 R'n'B Meets Northern Soul-R'n'B Meets Northern Soul Volume 1 ,2 ,3