sql = """
    SELECT core_wallpaper.id, SUM(core_rating.value) AS val 
    FROM core_wallpaper INNER JOIN core_rating ON 
        core_wallpaper.id = core_rating.wallpaper_id
    WHERE core_wallpaper.name LIKE "%s"  
    GROUP BY core_wallpaper.id    
    ORDER BY val DESC;
    """
    cursor = connection.cursor()
    cursor.execute(sql, ["%" + query + "%"])
    print sql % query
    result = cursor.fetchall()
    print len(result)
    return HttpResponse(result)

SELECT core_wallpaper.id, SUM(core_rating.value) AS val 
    FROM core_wallpaper INNER JOIN core_rating ON 
        core_wallpaper.id = core_rating.wallpaper_id
    WHERE core_wallpaper.name LIKE "111"
    GROUP BY core_wallpaper.id    
    ORDER BY val DESC;