join_tab[0]:
((geo.moderationstatus = 1) and (geo.vhost = 123) and (geo.datatype = 1) and (geo.morton between getGeoMorton(45.99290006,-(64.76185116)) and getGeoMorton(46.44290006,-(64.31185116))) and (geo.latitude between 45.99290006 and 46.44290006) and (geo.longitude between -(64.76185116) and -(64.31185116)))
join_tab[1]:
((data_mediagallery.vhost = 123) and (data_mediagallery.status = 3) and (data_mediagallery.moderationstatus = 1) and (data_mediagallery.hidden = 0) and (data_mediagallery.context = 1) and (data_mediagallery.channelleft between 158 and 199) and (data_mediagallery.id = geo.foreignid))
5.2:
join_tab[0]:
((geo.moderationstatus = 1) and (geo.vhost = 123) and (geo.datatype = 1) and (geo.morton between 4107809683888424684 and 4108989545352957023) and (geo.latitude between 45.99290006 and 46.44290006) and (geo.longitude between -(64.76185116) and -(64.31185116)))
join_tab[1]:
((data_mediagallery.vhost = 123) and (data_mediagallery.status = 3) and (data_mediagallery.moderationstatus = 1) and (data_mediagallery.hidden = 0) and (data_mediagallery.context = 1) and (data_mediagallery.channelleft between 158 and 199) and (data_mediagallery.id = geo.foreignid))"
Parts of WHERE conditions attached to tables:
5.3:
join_tab[0]: nstatus = 1) and (geo.vhost = 123) and (geo.datatype = 1) and (geo.morton between getGeoMorton( 45.99290006, -(64.76185116) ) and getGeoMorton( 46.44290006, -(64.31185116) )) and (geo.latitude between 45.99290006 and 46.44290006) and (geo.longitude between -(64.76185116) and -(64.31185116)))
((geo.moderatio
join_tab[1]: mediagallery. vhost = 123) and (data_mediagall ery.status = 3) and (data_mediagall ery.moderations tatus = 1) and (data_mediagall ery.hidden = 0) and (data_mediagall ery.context = 1) and (data_mediagall ery.channelleft between 158 and 199) and (data_mediagall ery.id = geo.foreignid))
((data_
5.2:
join_tab[0]: nstatus = 1) and (geo.vhost = 123) and (geo.datatype = 1) and (geo.morton between 4107809683888424684 and 410898954535295 7023) and (geo.latitude between 45.99290006 and 46.44290006) and (geo.longitude between -(64.76185116) and -(64.31185116)))
((geo.moderatio
join_tab[1]: mediagallery. vhost = 123) and (data_mediagall ery.status = 3) and (data_mediagall ery.moderations tatus = 1) and (data_mediagall ery.hidden = 0) and (data_mediagall ery.context = 1) and (data_mediagall ery.channelleft between 158 and 199) and (data_mediagall ery.id = geo.foreignid))"
((data_