whatsapp group picture extractor

whatsapp_group_imgs.py

import sqlite3

DB_FILE = r"PATH\TO\DB\FILE"
GROUP_ID = GROUP_ID \\ see messages.key_remote_jid, appears after the "@" sign

con = sqlite3.connect(DB_FILE)
with con:
    cur = con.cursor()

    image_paths = cur.execute(f"select file_path from message_media where "
                              f"message_media.file_hash in (SELECT media_hash from messages "
                              f"WHERE key_remote_jid LIKE '%{GROUP_ID}%' "
                              f"and media_hash is not null)").fetchall()
print(image_paths)