SELECT DISTINCT g.grupo, COUNT(*) AS operaciones, g.grupo,
(SELECT gruposVF.colorFamilia FROM gruposVF WHERE gruposVF.digitosCCR=g.CCRdigito) AS colorFamilia
FROM (incidencias i LEFT JOIN gruposVFdigitos g ON i.digitoCertificado = g.CCRdigito)
LEFT JOIN ordenes o ON i.orden_ID = o.n_orden
WHERE  o.enviada=1  AND i.esKit!=3 AND o.fecha_create BETWEEN ' 00:00:00' AND ' 23:59:59' AND o.segmentoT IN() AND o.tallerID IN() AND g.grupoCOD IN ()
ORDER BY operaciones DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND o.tallerID IN() AND g.grupoCOD IN () ORDER BY operaciones DESC' at line 5