I have a query that I am making in mysql, the problem is that the condition of STORE_REP is not being met since it would have to bring everything that has 'BM' together with the following TYPE condition as seen in the example
SELECT * FROM transformadores
where (ALMACEN_REP = 'BM') AND (TIPO = 'TND') OR (TIPO = 'TNE') OR (TIPO = 'TNM') OR
(TIPO = 'TNP') OR (TIPO = 'TNS') OR (TIPO = 'TNZ') OR
(TIPO = 'TUE') order by ID desc;