mysql view to simple query

Для примера есть такая схема таблиц и view:

  create table first_table
  (
    id int auto_increment primary key,
    name varchar(50) null
  );
  create table second_table
  (
    id int not null primary key,
    name varchar(50) null,
    first_table_id int null,
    status_id int null
  );
  CREATE VIEW test_view AS
      SELECT
        second_table.id             AS id,
        second_table.name           AS name,
        second_table.first_table_id AS first_table_id
      FROM second_table
      WHERE (second_table.status_id = 1);

Есть такой запрос:

SELECT * FROM first_table
LEFT JOIN test_view ON test_view.first_table_id = first_table.id

Такой запрос будет соответствовать:

SELECT * FROM first_table
    LEFT JOIN (
      SELECT
        second_table.id             AS id,
        second_table.name           AS name,
        second_table.first_table_id AS first_table_id
      FROM second_table
      WHERE (second_table.status_id = 1)
    ) test ON test.first_table_id = first_table.id

или:

SELECT * FROM first_table
LEFT JOIN second_table 
  ON second_table.first_table_id = first_table.id 
 AND second_table.status_id = 1;