Указать типы для hardcoded select?

cross join 	(
  select null::INT as grainGroupCode, 
       null::TEXT as grainGroupName, 
       null::VARCHAR(4) as typeProductCode, 
       null::BLABLABLA as typeProductName, 
       null::DATE as date1 
  ) filters

https://postgrespro.ru/docs/postgrespro/10/datatype

Что не так с моим запросом?

select
main.id
count(news.id) as news,
count(articles.id) as articles
from main
LEFT JOIN news ON main.id = news.main_id
LEFT JOIN articles ON main.id = articles.main_id
group by main.id
order by news desc;