エラーが発生しました 指定されたIDのデータはDBに登録されていません SELECT prodT.*, dateStr(salesDate) AS salesDay, CASE WHEN salesDate = 'INFINITY' THEN 0 ELSE (CASE WHEN salesDate::DATE> now()::DATE THEN 1 ELSE 0 END) END AS reserveProduct, commaNum(prodT.listPrice) AS cmListPrice, commaNum(prodT.salePrice) AS cmSalePrice, CASE prodT.salePrice WHEN -1 THEN commaNum(prodT.listPrice) ELSE commaNum(prodT.salePrice) END AS cmShowPrice, categoryT.name AS categoryName, pdMakerT.name AS pdMakerName, salesMakerT.name AS salesMakerName, catalogT.comment AS catalogComment, stockT.seikodoStat AS seikodoStock, stockT.stockCount AS shopStock, CASE WHEN stockT.ignoreReserved='t' THEN 1 ELSE 0 END AS ignoreReserved, genreSubGT.id AS sGenreId, genreSubGT.mainGroupId AS mGenreId, pnameT.personNameList AS personNameList, catVisualT.misc AS visualInfo, pendingT.expireDate AS pendingExpireDate FROM productTbl prodT LEFT OUTER JOIN productCategoryTbl categoryT ON prodT.categoryId=categoryT.id LEFT OUTER JOIN productMakerTbl pdMakerT ON prodT.pdMakerId=pdMakerT.id LEFT OUTER JOIN productMakerTbl salesMakerT ON prodT.salesMakerId=salesMakerT.id LEFT OUTER JOIN productCatalogTbl catalogT ON prodT.id=catalogT.id LEFT OUTER JOIN productStockTbl stockT ON prodT.id=stockT.productId LEFT OUTER JOIN productGenreTbl genreT ON prodT.genreId=genreT.id LEFT OUTER JOIN productGenreSubGroupTbl genreSubGT ON genreSubGT.id=genreT.subGroupId LEFT OUTER JOIN productPersonNameListTbl pnameT ON prodT.id=pnameT.prodId LEFT OUTER JOIN productCatVisualTbl catVisualT ON prodT.id=catVisualT.prodId LEFT OUTER JOIN productPendingTbl pendingT ON prodT.id=pendingT.prodId WHERE prodT.id='00000576213' LIMIT 1; BACK / TOP