|
| エラー |
指定されたIDのデータはDBに登録されていません
SELECT prod.id, prod.categoryId, prod.name AS name, prod.brandNewPrice, prod.usedPrice, currStr(prod.brandNewPrice) AS brandNewPriceStr, currStr(prod.usedPrice) AS usedPriceStr, CASE WHEN prod.taxFree='f' THEN taxedVal(prod.brandNewPrice, 5) ELSE prod.brandNewPrice END AS taxedBrandNewPrice, currStr(CASE WHEN prod.taxFree='f' THEN taxedVal(prod.brandNewPrice, 5) ELSE prod.brandNewPrice END) AS taxedBrandNewPriceStr, CASE WHEN prod.taxFree='f' THEN taxedVal(prod.usedPrice, 5) ELSE prod.usedPrice END AS taxedUsedPrice, currStr(CASE WHEN prod.taxFree='f' THEN taxedVal(prod.usedPrice, 5) ELSE prod.usedPrice END) AS taxedUsedPriceStr, prod.mainChara, prod.comment, team.name AS teamName, prod.brandNewStatId, prod.usedStatId, prod.brandNewStockCount, prod.usedStockCount, CASE prod.saleDate WHEN 'INFINITY' THEN '不明' ELSE to_char(prod.saleDate, 'YY.MM.DD') END AS saleDay, prod.saleDate > now() AS beforeSale, prod.performedDate, CASE prod.performedDate WHEN '-INFINITY' THEN '' ELSE to_char(performedDate, 'YY.MM.DD') END AS performedDay, prod.performedHole, prod.originalAuther, prod.director, prod.imageDisp, categoryT.imgMethod AS imgMethod, categoryT.name AS categoryName FROM productTbl prod LEFT OUTER JOIN teamTbl team ON prod.teamId=team.id LEFT OUTER JOIN productCategoryTbl categoryT ON prod.categoryId=categoryT.id WHERE prod.id='IMP-45'; |
|
