MySQL - insertar datos en una tabla

CREATE TABLE `table_listnames` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(255) NOT NULL,

  `address` varchar(255) NOT NULL,

  `tele` varchar(255) NOT NULL,

  PRIMARY KEY  (`id`)

) ENGINE=InnoDB;

//quiero entender la siguiente consulta sql

INSERT INTO table_listnames (name, address, tele)

SELECT * FROM (SELECT 'Rupert', 'Somewhere', '022') AS tmp

WHERE NOT EXISTS (

    SELECT name FROM table_listnames WHERE name = 'Rupert'

) LIMIT 1;