<p>The server side implementation of IContentDirectory::CountMediaItems generates invalid SQL.</p>

<p>&nbsp;</p>

<p><span style="background-color: rgb(250, 250, 250); color: rgb(0, 0, 0); font-family: 'Helvetica Neue', Helvetica-Neue, Arial, sans-serif; line-height: 20px;">[2014-01-20 22:47:27,850] [13748 ] [28 ] [DEBUG] - SQL command SELECT COUNT(V.C) </span><span style="color:#FF0000;"><span style="background-color: rgb(250, 250, 250); font-family: 'Helvetica Neue', Helvetica-Neue, Arial, sans-serif; line-height: 20px;"><b>C, FROM</b></span></span><span style="background-color: rgb(250, 250, 250); color: rgb(0, 0, 0); font-family: 'Helvetica Neue', Helvetica-Neue, Arial, sans-serif; line-height: 20px;"> (SELECT DISTINCT T0.MEDIA_ITEM_ID C FROM M_AUDIOITEM T0 LEFT OUTER JOIN NM_ARTISTS T3 ON T3.MEDIA_ITEM_ID = T0.MEDIA_ITEM_ID LEFT OUTER JOIN V_ARTISTS T1 ON T3.ID = T1.ID LEFT OUTER JOIN M_PROVIDERRESOURCE T2 ON T0.MEDIA_ITEM_ID = T2.MEDIA_ITEM_ID WHERE (T1.ATTRIBUTE_VALUE LIKE @V0 AND T2.SYSTEM_ID = @V1)) V [V0=% V1=03f6f4f8-f753-42a1-97b9-86ce01dab96d]</span></p>

<p><br style="color: rgb(0, 0, 0); font-family: 'Helvetica Neue', Helvetica-Neue, Arial, sans-serif; line-height: 20px; background-color: rgb(250, 250, 250);" />
<span style="color: rgb(0, 0, 0); font-family: 'Helvetica Neue', Helvetica-Neue, Arial, sans-serif; line-height: 20px; background-color: rgb(250, 250, 250);">MainQueryBuilder::GenerateSqlStatement has built groupClause as blank because qualifiedGroupByAliases is an empty set.</span></p>