...
def list(request):
    shop_list = Shop.objects.raw('SELECT * FROM test JOIN test1 p ON .....')
    shops = [ {'id':s.id, 'name':s.name,.....} for s in shop_list]
    return render_to_response("list.html", {"shops":shops}, context_instance=RequestContext(request))