problema con consulta where y signo de $

[jaivaman]

Gracias por responder te lo pongo aqui

Código MySQL:

SELECT 
 
IFNULL(A.Id, 'TOTAL') AS ID , A.nombrem, A.login, A.CLAVE, A.MATERIA, A.SEMGRUPO, 
 
COUNT(B.t1) AS 'TOTAL MAT.', SUM(C.t1) AS 'CALEND. REGISTRADAS', AVG(IF (C.t1 >= 13, 3, 0)) AS 'CALND. PUNTOS', SUM(D.t1) AS 'CRITERIOS REGISTRADOS',AVG( IF (D.t1 >= 3, 1, 0)) AS 'CRITERIOS PUNTOS', 
 
/*.......   avance programatico P1........*/
E.t1 AS 'cia', AVG( IF(E.t1 >= 1,1,0)) AS 'ciap', F.t1 AS 'ava', AVG( IF(F.t1 = 'TOTAL',1,0)) AS 'avap',  AVG(G.t1) AS 'cafa' ,  AVG( IF (G.t1 >= 0, 100, 0)) AS 'cafap' , AVG(G.t2) AS 'asia', AVG(IF(G.t1 >0, 1,0)) AS cafap, SUM(H.t1) AS proba , A. ACADEMIA , AVG( IF (H.t1 >= 1, 1, 0) ) AS probap, CONTANDO
 
 
 
FROM `maestrros` AS A
 
LEFT JOIN
    (SELECT nombrem, login, CLAVE, SEMGRUPO, COUNT(login) AS t1
    FROM `maestrros`
    GROUP BY login, CLAVE) AS B
ON A.login=B.login AND A.CLAVE=B.CLAVE 
 
 
LEFT JOIN 
    (SELECT NAME, maestroid, CLAVE, SEMGRUPO, ACCESO, BANDERA, COUNT(ACCESO) AS t1
    FROM `calendarizacion_maestros` 
    WHERE ACCESO='GUARDADO' 
    GROUP BY maestroid, CLAVE) AS C
ON A.login=C.maestroid AND A.CLAVE=C.CLAVE 
 
LEFT JOIN
    (SELECT Maestroid, CLAVE, ACCESO, SEMGRUPO, COUNT(ACCESO) AS t1
    FROM `criterios`
    WHERE ACCESO='GUARDADO'
    GROUP BY Maestroid, CLAVE) AS D
ON A.login=D.Maestroid AND A.CLAVE=D.CLAVE 
 
/*..... apartir de aqui avanceprogramatico parcial 1.....*/
 
LEFT JOIN
    (SELECT login, SEMGRUPO, CLAVE, cimp AS t1
    FROM `maestrros` 
    GROUP BY login, CLAVE, SEMGRUPO) as E
ON A.login=E.login AND A.CLAVE=E.CLAVE AND A.SEMGRUPO=E.SEMGRUPO
 
 
LEFT JOIN
    (SELECT login, SEMGRUPO, CLAVE, AvcReal01 AS t1
    FROM `maestrros` 
    GROUP BY login, CLAVE, SEMGRUPO) as F
ON A.login=F.login AND A.CLAVE=F.CLAVE AND A.SEMGRUPO=F.SEMGRUPO
 
 
LEFT JOIN
    (SELECT CLAVE, SEMGRUPO, NUSUARIO, AVG(CALFa) AS t1, AVG(ASISa) AS t2
    FROM `alumnos`
    WHERE CALFa != 'NP'
    GROUP BY NUSUARIO, CLAVE, SEMGRUPO
    ORDER BY CALFa, ASISa DESC
    ) AS G
ON A.login=G.NUSUARIO AND A.CLAVE=G.CLAVE AND A.SEMGRUPO=G.SEMGRUPO
 
 
LEFT JOIN
    (SELECT CLAVE, SEMGRUPO, maestroid, COUNT(parcial) AS t1
    FROM `images`
    WHERE parcial='1'
    GROUP BY  maestroid, CLAVE, SEMGRUPO) AS H
ON A.login=H.maestroid AND A.CLAVE=H.CLAVE AND A.SEMGRUPO=H.SEMGRUPO
 
LEFT JOIN
( SELECT ACADEMIA, login, SEMGRUPO, CLAVE, COUNT(CLAVE) AS CONTANDO
    FROM `maestrros` 
    GROUP BY ACADEMIA ) AS I 
ON  A.ACADEMIA=I.ACADEMIA
 
 
WHERE   A.ACADEMIA like '%buscar%' OR A.nombrem like '%$buscando%'
 
GROUP BY A.ACADEMIA, A.Id
with rollup