SELECT [t0].[class_id]
FROM [dbo].[mvc_class_channel] AS [t0]
WHERE ([t0].[class_id] = @p0) OR ([t0].[class_id_path] LIKE @p1) OR ([t0].[class_id_path] LIKE @p2)
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [200]
-- @p1: Input NVarChar (Size = 7; Prec = 0; Scale = 0) [%|200|%]
-- @p2: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [200|%]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT COUNT(*) AS [value]
FROM [dbo].[mvc_content_view] AS [t0]
WHERE ([t0].[a_isimg] = 1) AND ([t0].[a_type] IN (@p0)) AND (NOT ([t0].[a_isRecycle] = 1)) AND ([t0].[a_model] = @p1)
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [200]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [234]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT TOP (24) [t0].[a_id], [t0].[a_type], [t0].[a_name], [t0].[a_create_date], [t0].[a_hits], [t0].[a_isimg], [t0].[a_imgurl], [t0].[a_ismedia], [t0].[a_mediaurl], [t0].[a_model_name]
FROM [dbo].[mvc_content_view] AS [t0]
WHERE ([t0].[a_isimg] = 1) AND ([t0].[a_type] IN (@p0)) AND (NOT ([t0].[a_isRecycle] = 1)) AND ([t0].[a_model] = @p1)
ORDER BY [t0].[a_id] DESC
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [200]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [234]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
