example query:
select COUNT(*) AS count where duration>40 and views>2000 and (title like %filter% or title like %filter2%) and channel_id not in (180,200,40,20)

thinking of adding   and id not in (potentially,hundreds,of,ids)


CREATE TABLE `vids` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `yt_id` varchar(20) NOT NULL,
 `title` varchar(300) NOT NULL,
 `thumbnail` varchar(70) NOT NULL,
 `channel_id` smallint(6) NOT NULL,
 `channel_name` varchar(70) NOT NULL,
 `duration` smallint(6) DEFAULT NULL,
 `views` int(12) DEFAULT NULL,
 `likes` smallint(6) DEFAULT NULL,
 `dislikes` smallint(6) DEFAULT NULL,
 `like_pct` tinyint(4) DEFAULT NULL,
 `date` varchar(50) DEFAULT NULL,
 `gender` varchar(2) NOT NULL,
 `cth1` varchar(30) NOT NULL,
 `cth2` varchar(30) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `yt_id` (`yt_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29200 DEFAULT CHARSET=latin1


CREATE TABLE `bans` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `user_id` mediumint(9) DEFAULT NULL,
 `channel_id` smallint(6) DEFAULT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `user_id` (`user_id`,`channel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

CREATE TABLE `blocks` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `user_id` mediumint(9) DEFAULT NULL,
 `video_id` mediumint(9) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1