Ver originalSELECT camposFROM tablasJOIN (SELECT campos2 FROM tablas WHERE conditions) AS tabla2 ON conditionsWHERE conditions