import mysql.connector

conn = mysql.connector.connect(
    host="85.215.144.168",
    port=3306,
    database="pastelerias",
    user="asesoft",
    password="Pantera1"
)
cursor = conn.cursor(dictionary=True)

cursor.execute("SELECT COUNT(*) as cnt FROM ob_procesos_ingredientes;")
total_ings = cursor.fetchone()['cnt']
print("Total ingredients in ob_procesos_ingredientes:", total_ings)

cursor.execute("""
    SELECT COUNT(*) as cnt FROM ob_procesos_ingredientes 
    WHERE proceso_id NOT IN (SELECT id FROM ob_recetas_procesos);
""")
orphaned = cursor.fetchone()['cnt']
print("Orphaned ingredients (proceso_id not in ob_recetas_procesos):", orphaned)

cursor.close()
conn.close()