blob: 633c64283c675fee1030866124d64009e9963034 [file] [log] [blame]
select * from (select s1.type type, flatten(s1.rms.rptd) rptds from (select d.type type, flatten(d.map.rm) rms from `data.json` d) s1 where s1.rms.mapid='m2') s2 where s2.rptds.c > 0 and s2.type='web';