SELECT COUNT(*) AS total_paginas FROM articulos AS a LEFT JOIN revistas AS c ON c.codrevista = a.codrevista LEFT JOIN revistamov AS d ON d.nromovimiento = a.nrorevistamov LEFT JOIN articautores AS e ON e.nroartic = a.nroartic WHERE ((a.fechapublicacion=curdate()) OR (a.fechapublicacion<=curdate() AND a.fechaprimerapublicacion<=curdate() AND a.fechaprimerapublicacion<>'0000-00-00')) and (a.codestilo = 'ENSIIC' || a.codestilo='ENSIICAS') and a.nroartic IN (SELECT artiespec.nroartic FROM artiespec WHERE artiespec.principal = 1 AND codigoespe = 'obs')#con esto no duplica nroartic, en LEFT JOIN si lo haría. #and e.principal = 1 #GROUP BY a.nroartic ORDER BY a.fechapublicacion DESC ;