// SELECT z.zone_id AS z__0, z.item_id AS z__1, z.broken AS z__2, i.name AS i__3, i.url AS i__4, z.count AS z__5 FROM zone_item z LEFT JOIN zone z2 ON z.zone_id = z2.id LEFT JOIN item i ON z.item_id = i.id WHERE (z2.city_id = ?)