[CDB::fetch_array] SQLSTATE: 42S02, code: 208
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name 'LUNA2_LOGDB.dbo.TB_ITEM_LOG_20181022'.
QUERY:
SELECT TOP 100 A.[ItemIdx], MAX(B.[ItemName]) [ItemName], MAX(B.[Image2DNum]) [Image2DNum], MAX(B.[SellPrice]) [UnitPrice], MAX(B.[Kind]) [ItemKind], MAX(B.[LimitLevel]) [ItemLevel], SUM(CASE WHEN A.[ItemDur] = 0 THEN 1 ELSE A.[ItemDur] END) [TotalCount], MAX(B.[SellPrice]) * SUM(CASE WHEN A.[ItemDur] = 0 THEN 1 ELSE A.[ItemDur] END) [TotalPrice], 'item:' + CONVERT(VARCHAR(20), MAX(B.[EquipSlot])) + ':' + CONVERT(VARCHAR(20), CAST(A.[ItemIdx] AS DECIMAL(10,0))) + ':' + CONVERT(VARCHAR(20), CAST(MAX(B.[ItemTooltipIdx]) AS DECIMAL(10,0))) [TooltipData] FROM [LUNA2_LOGDB].[dbo].[TB_ITEM_LOG_20181022] A LEFT JOIN [LUNA2_RESRCDB].[dbo].[TB_BIN_ItemList] B ON A.[ItemIdx] = B.[ItemIdx] WHERE A.[LogType] IN( 300 ) AND A.[ItemIdx] NOT BETWEEN 21101001 AND 21101005 GROUP BY A.[ItemIdx]ORDER BY TotalPrice DESC