Ver originalSELECT a.idFROM avisos a INNER JOIN postulacion pON a.id=p.id_tabla_AWHERE p.id_usuario=3
Ver originalSELECT av.id, av.campo_texto, if(Sbc.id IS NULL, false, true) as POSTULADOFROM avisos av LEFT JOIN () as Sbc ON av.id=Sbc.id;
Ver originalSELECT av.id, av.campo_texto, if(Sbc.id IS NULL, false, true) as POSTULADOFROM avisos av LEFT JOIN (SELECT a.id FROM avisos a INNER JOIN postulacion p ON a.id=p.id_tabla_A WHERE p.id_usuario=3) as Sbc ON av.id=Sbc.id;