I have a N1QL query , in it I need add subquery with COUNT
SELECT col_doc.*, game_count FROM `cms-deploy` col_doc game_count=( select count(*) from `cms-deploy` AS col_g where _type="game" AND col_g.data.en.provider.id = ( SELECT raw col_d.id FROM `cms-deploy` AS col_d USE KEYS META(col_doc).id where _type="providers_game" ) ) WHERE col_doc._type="providers_game"
(This is a short query and in full query a can not use group by)
But game_count does not contain correct COUNT information only first “providers_game”
Could help me ?