DB Error: unknown error<br><br>SELECT g.*, 
                              CONCAT(FORMAT(g.nprice, 2), ' ', c.vcshortname) as vcprice, 
                              u.vclogin, 
                          (SELECT vcvalue 
                             FROM attributedata as ad, goodattribute as ga 
                            WHERE ga.igoodattributeid=ad.igoodattributeid
                              AND UPPER(ga.vcsysname)='AUTHOR' 
                              AND ad.igoodid=g.igoodid) as vcauthor, 
                          (SELECT vcvalue 
                             FROM attributedata as ad, goodattribute as ga 
                            WHERE ga.igoodattributeid=ad.igoodattributeid
                              AND UPPER(ga.vcsysname)='PUBLISHER' 
                              AND ad.igoodid=g.igoodid) as vcpublisher, 
                          (SELECT vcvalue 
                             FROM attributedata as ad, goodattribute as ga 
                            WHERE ga.igoodattributeid=ad.igoodattributeid
                              AND UPPER(ga.vcsysname)='YEAR' 
                              AND ad.igoodid=g.igoodid) as vcyear, 
                          (SELECT vcvalue 
                             FROM attributedata as ad, goodattribute as ga 
                            WHERE ga.igoodattributeid=ad.igoodattributeid
                              AND UPPER(ga.vcsysname)='PAGES' 
                              AND ad.igoodid=g.igoodid) as vcpages,
                           0 as comment_count  
                         FROM good as g, currency as c, users as u 
                        WHERE g.icatalogid='207' AND g.icurrencyid=c.icurrencyid 
                          AND g.bactive=1 AND g.bdeleted=0 AND g.iuserid=u.iusersid ORDER BY bavailable DESC, bnew DESC, isort LIMIT 20, 10 [nativecode=1030 ** Got error 28 from storage engine]