1186451 - Why is tile 529 classified as an android tile?

Status: RESOLVED INCOMPLETE

(Content Services Graveyard :: Tiles, defect)

Description

[Matthew Ruttley [:mruttley]]

This query looks for any tile in Channel 2 (Android):

SELECT tiles.id, tiles.adgroup_id, channels.id
FROM tiles
INNER JOIN adgroups ON adgroups.id = tiles.adgroup_id
INNER JOIN channels ON channels.id = adgroups.channel_id
WHERE channels.id = 2

This appears to include tile id 529 which is not a known Fennec Tile. Fennec tiles don't report impressions, and this one does. 

Is it misclassified or am I missing something?

Comment 1

[Olivier Yiptong [:oyiptong]]

You are correct. Tile 629-632 are android tiles.

There are a few more: 1791, 1792, 1793.

These should be all Android tiles

Comment 2

[Olivier Yiptong [:oyiptong]]

We just need a SQL query to fix this in production