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)

query = """
SELECT t.id, t.descripcion, t.tipo, t.es_articulo FROM (
  SELECT 
    mp.id, 
    CONVERT(mp.descripcion USING utf8mb4) COLLATE utf8mb4_general_ci AS descripcion, 
    CONVERT('Materia Prima' USING utf8mb4) COLLATE utf8mb4_general_ci AS tipo, 
    0 AS es_articulo 
  FROM ge_materias_primas mp 
  WHERE mp.activo = 1 

  UNION ALL 

  SELECT 
    a.id, 
    CONVERT(a.descripcion USING utf8mb4) COLLATE utf8mb4_general_ci AS descripcion, 
    CONVERT('Artículo' USING utf8mb4) COLLATE utf8mb4_general_ci AS tipo, 
    1 AS es_articulo 
  FROM ge_articulos a 
  WHERE a.activo = 1 AND a.ingrediente = 1
) t 
WHERE t.descripcion LIKE '%MASA MADRE%'
ORDER BY t.descripcion;
"""

cursor.execute(query)
rows = cursor.fetchall()
print(f"Selector results found: {len(rows)}")
for r in rows:
    print(r)

cursor.close()
conn.close()