Hi I have a question about a section in your sproc "FNS_CatalogModelFactory_ProductLoadAllPaged".
declare @countLanguage int
from Language L WITH (NOLOCK)
and (@StoreId=0 or L.LimitedToStores=0 or Exists(select Top 1 Id from StoreMapping sm WITH (NOLOCK)
where sm.EntityName = 'Language' and sm.StoreId=@StoreId and sm.EntityId=L.Id))
My site it using your plugin, and i noticed that this sporc returns Name of category with languageId = 0.
So the sproc always gets into this if
My problem is solved just by removing this, or set set @LanguageId=@LanguageId.
Is there any particular reason to have this check, when do i want to set LanguageId to 0?