class MapPizzaToppingListView(ListView):
    model = MapPizzaTopping
    paginate_by = 20
    template_name = 'onboardingWebApp/mappizzatopping_list.html'

    def get_queryset(self):
        cursor = connections["default"].cursor()
        cursor.execute("""SELECT map.*
                          FROM map_pizza_topping as map
                          INNER JOIN pizza
                              ON (map.pizza_id = pizza.id)
                          ORDER BY pizza.name""")
        queryset = dictfetchall(cursor)
        for row in queryset:
            pizza = Pizza.objects.get(id=row['pizza_id'])
            topping = Topping.objects.get(id=row['topping_id'])
            row['pizza_name'] = "%s (%s)" % (pizza.name, pizza.merchant.name)
            row['topping_name'] = topping.name
        return queryset