import sqlite3

c = sqlite3.connect(r'D:\db.sqlite3')
c.row_factory = sqlite3.Row
cur = c.cursor()
cur.execute(
    """
    SELECT s.id, s.user_id, s.status, s.package_id, s.expiry_date, s.added_date,
           u.email, u.account_type, p.name AS pkg_name, p.user_type, p.subscription_type
    FROM profile_store_subscription s
    JOIN accounts_user u ON u.id = s.user_id
    LEFT JOIN profile_store_pricing p ON p.id = s.package_id
    WHERE s.status IN ('paid', 'delivered')
    ORDER BY s.id
    """
)
for r in cur.fetchall():
    print(dict(r))