The queries you posted have some stuff missing.

In all cases you don't need to get the left 2 characters and then use like '%%'. The left can't possibly return anymore than 2 characters. Those could be greatly simplified to

LEFT (idDGIG, 2) in ('QM', 'QI', 'QO', 'QS')

Here is a snippet from your first query to show you what I mean about stuff missing.

SELECT

LEFT (idDGIG, 2) AS idDGIG,

COUNT(idDGIG) AS NUMBER

FROM

TABLE_LONG

WHERE

1

AND (

LEFT (idDGIG, 2) LIKE '%QM%'

OR LEFT (idDGIG, 2) LIKE '%QI%'

OR LEFT (idDGIG, 2) LIKE '%QO%'

OR LEFT (idDGIG, 2) LIKE '%QS%'

)

AND DATE_START = DATE_ADD(CURDATE(), INTERVAL - 1 DAY)

You have Where 1 and...

this doesn't work.