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 'Arthur Smith And The Dixieliners*' IN BOOLEAN MODE)
AN' at line 10
query: SELECT LP.*,CAT.name_en as catname, CNT.name_en as countryname, CNT.code as countrycode, GROUP_CONCAT(GEN.name_en ORDER BY GEN.name_en 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 ('Fiddlin' Arthur Smith And The Dixieliners*' IN BOOLEAN MODE)
AND LP.state IN (1,3,11,5,4,13,14,15,8)
AND LP.id NOT IN (50294)
AND CNT.state = 1
AND CAT.state = 1
AND GEN.state = 1
GROUP BY LP.id
ORDER BY LP.state
LIMIT 54
Product detail
Fiddlin' Arthur Smith And The Dixieliners
Rare Old Time Fiddle Tunes
Type: 33" LP
Year: 1962
Origin: United states
Lbl.: Starday Records – SLP 202
cat. no: VT 3334912
country, folk, ethno, tramp
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 Orange Blossom Special
A2 Paris Waltz
A3 Dixieliner's Ramble
A4 North Carolina Breakdown
A5 Cumberland Waltz
A6 Dickson County Blues
B1 K. C. Stomp
B2 Louise
B3 Indian Creek
B4 Darling Honey
B4 Whistler's Fever
B5 Maple Leaf Waltz
B6 Tulsa Hop
B7 Cheatham County Hoedown
Fiddle – Arthur Smith
Guitar [Open String Martin] – Earnest Smith
Price: 2 000 CZK (79.7 €)
