SELECT `platform`.* FROM (`platform`) LEFT OUTER JOIN `parentplatforms_platforms` parentplatform_parentplatforms_platforms ON `platform`.`id` = `parentplatform_parentplatforms_platforms`.`platform_id` WHERE `parentplatform_parentplatforms_platforms`.`parentplatform_id` = 4