Email   Heslo nová registrace
 

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 'Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richa' 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 ('Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard "Groove" Holmes*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (27086) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54
																 			 
Detail produktu 

Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard "Groove" Holmes

The Blues Box

 

Nosič: 33" LP
Rok vydání: 1966
původ: Spojené státy americké
Lbl.: Verve Folkways ‎– FT-3011-3
kat. číslo: PN 3320337

 

blues, R 'n' B

Stav desky: NM
- jako nová, téměř nehraná


Stav obalu: VG+
- větší pomačkání obalu, můžou být odřeniny apod.


Pozn.: znaménko + nebo - upřesňuje stav desky, obalu


A1  –Lightnin' Hopkins  Big Car Blues  7:13
A2  –Lightnin' Hopkins  Coffee House Blues  2:15
A3  –Lightnin' Hopkins  Stool Pigeon Blues  3:15
A4  –Lightnin' Hopkins  Ball Of Twine  2:30

B1  –Sonny Terry & Brownie McGhee  Walk On  4:20
B2  –Sonny Terry & Brownie McGhee  Blues For The Lowlands  4:50
B3  –Sonny Terry & Brownie McGhee  Gonna Lay My Body Down  3:17
B4  –Sonny Terry & Brownie McGhee  Just Rode In Your Town  3:59
B5  –Sonny Terry & Brownie McGhee  Sun's Gonna Shine  3:15

C1  –Sonny Terry & Brownie McGhee  Drinking In The Blues  5:08
C2  –Sonny Terry & Brownie McGhee  Po' Boy  3:05
C3  –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams  Everybody's Blues (Three Aces On The Bottom Of The Deal)  6:42
C4  –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams  Razor Sharp Blues  4:50

D1  –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams  Chain Gang Blues  5:17
D2  –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams  Brand New Car  5:29
D3  –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams  I've Been Scorned  5:10
D4  –Sonny Terry & Brownie McGhee, Lightnin' Hopkins, Big Joe Williams  Great Gospel Blues  2:50

E1  –Jimmy Witherspoon, Richard "Groove" Holmes  Tell Him I Was Flyin', Pt. 1  2:09
E2  –Jimmy Witherspoon, Richard "Groove" Holmes  Goin' To Chicago Blues  3:57
E3  –Jimmy Witherspoon, Richard "Groove" Holmes  In Blues  3:31
E4  –Jimmy Witherspoon, Richard "Groove" Holmes  Gee Baby, Ain't I Good To You?  2:35
E5  –Jimmy Witherspoon, Richard "Groove" Holmes  Loser's Blues  2:10
E6  –Jimmy Witherspoon, Richard "Groove" Holmes  Please Send Me Someone To Love  2:20

F1  –Jimmy Witherspoon, Richard "Groove" Holmes  Life's Highway (Key To The Highway)  2:25
F2  –Jimmy Witherspoon, Richard "Groove" Holmes  Cry The Blues  2:05
F3  –Jimmy Witherspoon, Richard "Groove" Holmes  Out Blues  2:30
F4  –Jimmy Witherspoon, Richard "Groove" Holmes  Since I Fell For You  3:35
F5  –Jimmy Witherspoon, Richard "Groove" Holmes  Everything  2:18
F6  –Jimmy Witherspoon, Richard "Groove" Holmes  Tell Him I Was Flyin', Pt. 2  3:05

 
Cena: 3 000 CZK   (118.4 €)
 

Ostatní náhledy

Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard Lightnin' Hopkins, Brownie McGhee, Sonny Terry, Jimmy Witherspoon, Big Joe Williams, Richard