Ver originalSELECT campo1,campo2 FROM tabla1INNER JOIN tabla2ON tabla1.id1=tabla2.id2 AND tabla2.otrocampo IN(1,2,4)WHERE ......
Ver originalSELECT campo1,campo2 FROM tabla1INNER JOIN tabla2ON tabla1.id1=tabla2.id2 WHERE tabla2.otrocampo IN(1,2,4)