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 's Solid Senders / Steve Hillage / Can / Peter Baumann / Ashra / U-Roy / Johnny C' 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 ('Captain Beefheart / Motors / X Ray Spex / XTC / Penetration / Wilko Johnson's Solid Senders / Steve Hillage / Can / Peter Baumann / Ashra / U-Roy / Johnny Clarke / Mighty Diamonds*' IN BOOLEAN MODE)
																         AND LP.state IN (1,3,11,5,4,13,14,15,8)
											 								 	 AND LP.id NOT IN (14834) 
												 								 AND CNT.state = 1
												 								 AND CAT.state = 1
												 								 AND GEN.state = 1
																				 GROUP BY	LP.id			
																				 ORDER BY LP.state	
																				 LIMIT 54

Detail produktu

Captain Beefheart / Motors / X Ray Spex / XTC / Penetration / Wilko Johnson's Solid Senders / Steve Hillage / Can / Peter Baumann / Ashra / U-Roy / Johnny Clarke / Mighty Diamonds

Dead On Arrival

Nosič: 33" LP
Rok vydání: 1978
původ: Velká Británie
Lbl.: Virgin ‎– VD2508
kat. číslo: PN 3311643

rock, ska, reggae

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

obal viz foto
desky vyborny stav

A1 – Motors Dancing The Night Away
    Producer – R. J. Lange Written-By – McMaster, Garvey 6:33
A2 – X Ray Spex Oh Bondage
    Producer – Falcon Stuart Written-By – P. Styrene 2:48
A3 – XTC Radios In Motion
    Producer – John Leckie Written-By – Andy Partridge 2:52
A4 – Penetration Firing Squad
    Producer – Mike Howlett Written-By – Chaplin, Murray 3:01
A5 – Wilko Johnson's Solid Senders Walking On The Edge
    Producer – David Bachelor Written-By – Wilko Johnson 2:51
B1 – Captain Beefheart New Electric Ride
    Producer – A. Di Martino* Written-By – Andy Di Martino, Don Vanvliet, Jan Vanvliet 3:00
B2 – Steve Hillage Hurdy Gurdy Men
    Producer – Todd Rundgren Written-By – Donovan P. Leitch 6:32
B3 – Can Full Moon On The Highway
    Producer – Can Written-By – Can, Peter Gilmore 3:29
B4 – Peter Baumann Bicentennial Present
    Producer, Written-By – Peter Baumann 4:46
B5 – Ashra 77 Slightly Delayed
    Producer, Written-By – Manuel Gottsching 6:42
C1 – U-Roy Babylon Burning
    Producer – Tony Robinson Written-By – U-Roy 2:40
C2 – Johnny Clarke Let's Give Jah Jah Praise
    Producer – Bunny Lee Written-By – Johnny Clarke 3:00
C3 – Mighty Diamonds Them Never Love Poor Marcus
    Producer – Joseph Hoo Kim Written-By – Mighty Diamonds 2:45
C4 – I-Roy Satta
    Producer – Bunny Lee Written-By – Carlton Manning 3:47
C5 – Delroy Washington Freedom Fighters
    Producer – D. Washington, M. Campbell Written-By – D. Washington 3:47
C6 – U-Roy Fire In A Trenchtown
    Producer – Tony Robinson Written-By – Owen Grey 2:48
D1 – Roogalator Love And The Single Girl
    Producer – Robin Scott Written-By – Nick Plytas 3:15
D2 – Link Wray I'm So Glad I'm So Proud
    Producer – Steve Verroca Written-By – Link Wray, Yvonne Verroca 7:57
D3 – Slapp Happy Casablanca Moon
    Producer – Slapp Happy, Steve Morse (4) Written-By – Moore, Blegvad 2:43
D4 – Elkie Brooks Women's Lib Song
    Producer – Steve York, Vic Smith* Written-By – Burrel, York, Hinkley 5:25
D5 – Mallard Desperados Waiting For A Train
    Arranged By – Jim Dickinson Producer – Bill Harkleroad, Robin Black Written-By – Guy Clark 3:35
D6 – Kevin Coyne Good Boy
    Producer – Steve Verroca Written-By – K. Coyne 2:40
D7 – Derek And Clive Members Only
    Producer – Dudley Moore, Peter Cook Written-By – Dudley Moore, Peter Cook

Cena: 800 CZK (31.9 €)

Ostatní náhledy