<?php namespace Podlove\Modules\RelatedEpisodes\Model; use Podlove\Model\Base; use Podlove\Model\Episode; class EpisodeRelation extends Base { public static function get_related_episodes($episode_id = FALSE) { global $wpdb; if (!$episode_id) { return array(); } $sql = sprintf('SELECT * FROM ' . Episode::table_name() . ' e WHERE id IN ( SELECT right_episode_id FROM ' . self::table_name() . ' WHERE left_episode_id = %1$d UNION SELECT left_episode_id FROM ' . self::table_name() . ' WHERE right_episode_id = %1$d )', $episode_id); return Episode::find_all_by_sql($sql); } } EpisodeRelation::property('id', 'INT NOT NULL AUTO_INCREMENT PRIMARY KEY'); EpisodeRelation::property('left_episode_id', 'INT'); EpisodeRelation::property('right_episode_id', 'INT');