Movies like Cabin Fever 2002

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_movie`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_movie`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_movie`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_movie`)

begin:system.db.CDbCommand.query(SELECT * FROM `en_movie` `t` WHERE
`t`.`id`=10203 LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `en_movie` `t` WHERE
`t`.`id`=10203 LIMIT 1)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_movie_tag`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_movie_tag`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_movie_tag`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_movie_tag`)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_tag`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_tag`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_tag`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_tag`)

begin:system.db.CDbCommand.query(SELECT `t`.`movie_id` AS `t0_c0`,
`t`.`tag_id` AS `t0_c1`, `t`.`rel` AS `t0_c2`, `t`.`mark_sum` AS `t0_c3`,
`t`.`mark_num` AS `t0_c4`, `t`.`mark_rat` AS `t0_c5`, `t`.`sort_best` AS
`t0_c6`, `t`.`sort_new` AS `t0_c7`, `t`.`page_index` AS `t0_c8`,
`t`.`sort_tag` AS `t0_c9`, `tag`.`id` AS `t1_c0`, `tag`.`slug_en` AS
`t1_c1`, `tag`.`slug_de` AS `t1_c2`, `tag`.`name` AS `t1_c3`,
`tag`.`mod_name_rus` AS `t1_c4`, `tag`.`mod_name_de` AS `t1_c5`,
`tag`.`mod_group_id` AS `t1_c6`, `tag`.`movie_num` AS `t1_c7`,
`tag`.`movie_num_live` AS `t1_c8`, `tag`.`best_movie_data_en` AS `t1_c9`,
`tag`.`best_movie_data_de` AS `t1_c10`, `tag`.`picture` AS `t1_c11`,
`tag`.`picture_status` AS `t1_c12`, `tag`.`ws` AS `t1_c13`,
`tag`.`page_index` AS `t1_c14`, `tag`.`best_movie_ids` AS `t1_c15`,
`tag`.`new_movie_ids` AS `t1_c16`, `tag`.`create_at` AS `t1_c17`,
`tag`.`posting` AS `t1_c18` FROM `en_movie_tag` `t`  INNER JOIN `en_tag`
`tag` ON (`t`.`tag_id`=`tag`.`id`) WHERE (t.movie_id = 10203) ORDER BY rel
DESC, tag.ws DESC)

end:system.db.CDbCommand.query(SELECT `t`.`movie_id` AS `t0_c0`,
`t`.`tag_id` AS `t0_c1`, `t`.`rel` AS `t0_c2`, `t`.`mark_sum` AS `t0_c3`,
`t`.`mark_num` AS `t0_c4`, `t`.`mark_rat` AS `t0_c5`, `t`.`sort_best` AS
`t0_c6`, `t`.`sort_new` AS `t0_c7`, `t`.`page_index` AS `t0_c8`,
`t`.`sort_tag` AS `t0_c9`, `tag`.`id` AS `t1_c0`, `tag`.`slug_en` AS
`t1_c1`, `tag`.`slug_de` AS `t1_c2`, `tag`.`name` AS `t1_c3`,
`tag`.`mod_name_rus` AS `t1_c4`, `tag`.`mod_name_de` AS `t1_c5`,
`tag`.`mod_group_id` AS `t1_c6`, `tag`.`movie_num` AS `t1_c7`,
`tag`.`movie_num_live` AS `t1_c8`, `tag`.`best_movie_data_en` AS `t1_c9`,
`tag`.`best_movie_data_de` AS `t1_c10`, `tag`.`picture` AS `t1_c11`,
`tag`.`picture_status` AS `t1_c12`, `tag`.`ws` AS `t1_c13`,
`tag`.`page_index` AS `t1_c14`, `tag`.`best_movie_ids` AS `t1_c15`,
`tag`.`new_movie_ids` AS `t1_c16`, `tag`.`create_at` AS `t1_c17`,
`tag`.`posting` AS `t1_c18` FROM `en_movie_tag` `t`  INNER JOIN `en_tag`
`tag` ON (`t`.`tag_id`=`tag`.`id`) WHERE (t.movie_id = 10203) ORDER BY rel
DESC, tag.ws DESC)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `adsense_policy`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `adsense_policy`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `adsense_policy`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `adsense_policy`)

begin:system.db.CDbCommand.query(SELECT * FROM `adsense_policy` `t` WHERE
`t`.`lang`=:yp0 AND `t`.`page_type`=:yp1 AND `t`.`page_id`=:yp2 LIMIT 1.
Bound with :yp0='en', :yp1=1, :yp2='10203')

end:system.db.CDbCommand.query(SELECT * FROM `adsense_policy` `t` WHERE
`t`.`lang`=:yp0 AND `t`.`page_type`=:yp1 AND `t`.`page_id`=:yp2 LIMIT 1.
Bound with :yp0='en', :yp1=1, :yp2='10203')

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_movie_rel`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_movie_rel`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_movie_rel`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_movie_rel`)

begin:system.db.CDbCommand.query(SELECT `t`.`movie_id_1` AS `t0_c0`,
`t`.`movie_id_2` AS `t0_c1`, `t`.`mark_sum` AS `t0_c2`, `t`.`mark_num` AS
`t0_c3`, `t`.`rating` AS `t0_c4`, `t`.`sort_best` AS `t0_c5`,
`t`.`rating_percent` AS `t0_c6`, `t`.`mark_percent` AS `t0_c7`,
`movie_2`.`id` AS `t1_c0`, `movie_2`.`imdb_id` AS `t1_c1`,
`movie_2`.`imdb_id_int` AS `t1_c2`, `movie_2`.`status` AS `t1_c3`,
`movie_2`.`slug_en` AS `t1_c4`, `movie_2`.`name_en` AS `t1_c5`,
`movie_2`.`full_name` AS `t1_c6`, `movie_2`.`original_title` AS `t1_c7`,
`movie_2`.`year` AS `t1_c8`, `movie_2`.`imdb_rating` AS `t1_c9`,
`movie_2`.`imdb_vote` AS `t1_c10`, `movie_2`.`popularity` AS `t1_c11`,
`movie_2`.`weight` AS `t1_c12`, `movie_2`.`picture` AS `t1_c13`,
`movie_2`.`duration` AS `t1_c14`, `movie_2`.`genre` AS `t1_c15`,
`movie_2`.`country` AS `t1_c16`, `movie_2`.`mpaa_rating` AS `t1_c17`,
`movie_2`.`serial` AS `t1_c18`, `movie_2`.`animation` AS `t1_c19`,
`movie_2`.`nominations` AS `t1_c20`, `movie_2`.`awards` AS `t1_c21`,
`movie_2`.`oscars` AS `t1_c22`, `movie_2`.`budget` AS `t1_c23`,
`movie_2`.`story_en` AS `t1_c24`, `movie_2`.`updated_en` AS `t1_c25`,
`movie_2`.`tags_data` AS `t1_c26`, `movie_2`.`tags_count` AS `t1_c27`,
`movie_2`.`tags_full_data_en` AS `t1_c28`, `movie_2`.`rel_count` AS
`t1_c29`, `movie_2`.`parent_id` AS `t1_c30`, `movie_2`.`video_key_en` AS
`t1_c31`, `movie_2`.`picture_status` AS `t1_c32`, `movie_2`.`page_index` AS
`t1_c33`, `movie_2`.`weight_movie_ids` AS `t1_c34`,
`movie_2`.`best_movie_ids` AS `t1_c35`, `movie_2`.`new_movie_ids` AS
`t1_c36` FROM `en_movie_rel` `t`  INNER JOIN `en_movie` `movie_2` ON
(`t`.`movie_id_2`=`movie_2`.`id`) WHERE (t.movie_id_1 = 10203) ORDER BY
t.rating DESC LIMIT 30)

end:system.db.CDbCommand.query(SELECT `t`.`movie_id_1` AS `t0_c0`,
`t`.`movie_id_2` AS `t0_c1`, `t`.`mark_sum` AS `t0_c2`, `t`.`mark_num` AS
`t0_c3`, `t`.`rating` AS `t0_c4`, `t`.`sort_best` AS `t0_c5`,
`t`.`rating_percent` AS `t0_c6`, `t`.`mark_percent` AS `t0_c7`,
`movie_2`.`id` AS `t1_c0`, `movie_2`.`imdb_id` AS `t1_c1`,
`movie_2`.`imdb_id_int` AS `t1_c2`, `movie_2`.`status` AS `t1_c3`,
`movie_2`.`slug_en` AS `t1_c4`, `movie_2`.`name_en` AS `t1_c5`,
`movie_2`.`full_name` AS `t1_c6`, `movie_2`.`original_title` AS `t1_c7`,
`movie_2`.`year` AS `t1_c8`, `movie_2`.`imdb_rating` AS `t1_c9`,
`movie_2`.`imdb_vote` AS `t1_c10`, `movie_2`.`popularity` AS `t1_c11`,
`movie_2`.`weight` AS `t1_c12`, `movie_2`.`picture` AS `t1_c13`,
`movie_2`.`duration` AS `t1_c14`, `movie_2`.`genre` AS `t1_c15`,
`movie_2`.`country` AS `t1_c16`, `movie_2`.`mpaa_rating` AS `t1_c17`,
`movie_2`.`serial` AS `t1_c18`, `movie_2`.`animation` AS `t1_c19`,
`movie_2`.`nominations` AS `t1_c20`, `movie_2`.`awards` AS `t1_c21`,
`movie_2`.`oscars` AS `t1_c22`, `movie_2`.`budget` AS `t1_c23`,
`movie_2`.`story_en` AS `t1_c24`, `movie_2`.`updated_en` AS `t1_c25`,
`movie_2`.`tags_data` AS `t1_c26`, `movie_2`.`tags_count` AS `t1_c27`,
`movie_2`.`tags_full_data_en` AS `t1_c28`, `movie_2`.`rel_count` AS
`t1_c29`, `movie_2`.`parent_id` AS `t1_c30`, `movie_2`.`video_key_en` AS
`t1_c31`, `movie_2`.`picture_status` AS `t1_c32`, `movie_2`.`page_index` AS
`t1_c33`, `movie_2`.`weight_movie_ids` AS `t1_c34`,
`movie_2`.`best_movie_ids` AS `t1_c35`, `movie_2`.`new_movie_ids` AS
`t1_c36` FROM `en_movie_rel` `t`  INNER JOIN `en_movie` `movie_2` ON
(`t`.`movie_id_2`=`movie_2`.`id`) WHERE (t.movie_id_1 = 10203) ORDER BY
t.rating DESC LIMIT 30)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_genre`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_genre`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_genre`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_genre`)

begin:system.db.CDbCommand.query(SELECT * FROM `en_genre` `t`)

end:system.db.CDbCommand.query(SELECT * FROM `en_genre` `t`)

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_mix`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_mix`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_mix`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_mix`)

begin:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0,
:yp1='11', :yp2=0, :yp3=0, :yp4='0')

end:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0,
:yp1='11', :yp2=0, :yp3=0, :yp4='0')

begin:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0, :yp1='2',
:yp2=0, :yp3=0, :yp4='0')

end:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0, :yp1='2',
:yp2=0, :yp3=0, :yp4='0')

begin:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0, :yp1=0,
:yp2='3', :yp3=0, :yp4='0')

end:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0, :yp1=0,
:yp2='3', :yp3=0, :yp4='0')

begin:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0, :yp1=16,
:yp2=0, :yp3=0, :yp4='0')

end:system.db.CDbCommand.query(SELECT * FROM `en_mix` `t` WHERE
`t`.`tag_id`=:yp0 AND `t`.`genre_id`=:yp1 AND `t`.`country_id`=:yp2 AND
`t`.`year`=:yp3 AND `t`.`serial`=:yp4 LIMIT 1. Bound with :yp0=0, :yp1=16,
:yp2=0, :yp3=0, :yp4='0')

begin:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_country`)

end:system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `en_country`)

begin:system.db.CDbCommand.query(SHOW CREATE TABLE `en_country`)

end:system.db.CDbCommand.query(SHOW CREATE TABLE `en_country`)

begin:system.db.CDbCommand.query(SELECT * FROM `en_country` `t`)

end:system.db.CDbCommand.query(SELECT * FROM `en_country` `t`)

begin:system.db.CDbCommand.query(SELECT `t`.`movie_id_1` AS `t0_c0`,
`t`.`movie_id_2` AS `t0_c1`, `t`.`mark_sum` AS `t0_c2`, `t`.`mark_num` AS
`t0_c3`, `t`.`rating` AS `t0_c4`, `t`.`sort_best` AS `t0_c5`,
`t`.`rating_percent` AS `t0_c6`, `t`.`mark_percent` AS `t0_c7`,
`movie_2`.`id` AS `t1_c0`, `movie_2`.`imdb_id` AS `t1_c1`,
`movie_2`.`imdb_id_int` AS `t1_c2`, `movie_2`.`status` AS `t1_c3`,
`movie_2`.`slug_en` AS `t1_c4`, `movie_2`.`name_en` AS `t1_c5`,
`movie_2`.`full_name` AS `t1_c6`, `movie_2`.`original_title` AS `t1_c7`,
`movie_2`.`year` AS `t1_c8`, `movie_2`.`imdb_rating` AS `t1_c9`,
`movie_2`.`imdb_vote` AS `t1_c10`, `movie_2`.`popularity` AS `t1_c11`,
`movie_2`.`weight` AS `t1_c12`, `movie_2`.`picture` AS `t1_c13`,
`movie_2`.`duration` AS `t1_c14`, `movie_2`.`genre` AS `t1_c15`,
`movie_2`.`country` AS `t1_c16`, `movie_2`.`mpaa_rating` AS `t1_c17`,
`movie_2`.`serial` AS `t1_c18`, `movie_2`.`animation` AS `t1_c19`,
`movie_2`.`nominations` AS `t1_c20`, `movie_2`.`awards` AS `t1_c21`,
`movie_2`.`oscars` AS `t1_c22`, `movie_2`.`budget` AS `t1_c23`,
`movie_2`.`story_en` AS `t1_c24`, `movie_2`.`updated_en` AS `t1_c25`,
`movie_2`.`tags_data` AS `t1_c26`, `movie_2`.`tags_count` AS `t1_c27`,
`movie_2`.`tags_full_data_en` AS `t1_c28`, `movie_2`.`rel_count` AS
`t1_c29`, `movie_2`.`parent_id` AS `t1_c30`, `movie_2`.`video_key_en` AS
`t1_c31`, `movie_2`.`picture_status` AS `t1_c32`, `movie_2`.`page_index` AS
`t1_c33`, `movie_2`.`weight_movie_ids` AS `t1_c34`,
`movie_2`.`best_movie_ids` AS `t1_c35`, `movie_2`.`new_movie_ids` AS
`t1_c36` FROM `en_movie_rel` `t`  INNER JOIN `en_movie` `movie_2` ON
(`t`.`movie_id_2`=`movie_2`.`id`) WHERE (t.movie_id_1 = 10203) ORDER BY
movie_2.weight DESC LIMIT 5)

end:system.db.CDbCommand.query(SELECT `t`.`movie_id_1` AS `t0_c0`,
`t`.`movie_id_2` AS `t0_c1`, `t`.`mark_sum` AS `t0_c2`, `t`.`mark_num` AS
`t0_c3`, `t`.`rating` AS `t0_c4`, `t`.`sort_best` AS `t0_c5`,
`t`.`rating_percent` AS `t0_c6`, `t`.`mark_percent` AS `t0_c7`,
`movie_2`.`id` AS `t1_c0`, `movie_2`.`imdb_id` AS `t1_c1`,
`movie_2`.`imdb_id_int` AS `t1_c2`, `movie_2`.`status` AS `t1_c3`,
`movie_2`.`slug_en` AS `t1_c4`, `movie_2`.`name_en` AS `t1_c5`,
`movie_2`.`full_name` AS `t1_c6`, `movie_2`.`original_title` AS `t1_c7`,
`movie_2`.`year` AS `t1_c8`, `movie_2`.`imdb_rating` AS `t1_c9`,
`movie_2`.`imdb_vote` AS `t1_c10`, `movie_2`.`popularity` AS `t1_c11`,
`movie_2`.`weight` AS `t1_c12`, `movie_2`.`picture` AS `t1_c13`,
`movie_2`.`duration` AS `t1_c14`, `movie_2`.`genre` AS `t1_c15`,
`movie_2`.`country` AS `t1_c16`, `movie_2`.`mpaa_rating` AS `t1_c17`,
`movie_2`.`serial` AS `t1_c18`, `movie_2`.`animation` AS `t1_c19`,
`movie_2`.`nominations` AS `t1_c20`, `movie_2`.`awards` AS `t1_c21`,
`movie_2`.`oscars` AS `t1_c22`, `movie_2`.`budget` AS `t1_c23`,
`movie_2`.`story_en` AS `t1_c24`, `movie_2`.`updated_en` AS `t1_c25`,
`movie_2`.`tags_data` AS `t1_c26`, `movie_2`.`tags_count` AS `t1_c27`,
`movie_2`.`tags_full_data_en` AS `t1_c28`, `movie_2`.`rel_count` AS
`t1_c29`, `movie_2`.`parent_id` AS `t1_c30`, `movie_2`.`video_key_en` AS
`t1_c31`, `movie_2`.`picture_status` AS `t1_c32`, `movie_2`.`page_index` AS
`t1_c33`, `movie_2`.`weight_movie_ids` AS `t1_c34`,
`movie_2`.`best_movie_ids` AS `t1_c35`, `movie_2`.`new_movie_ids` AS
`t1_c36` FROM `en_movie_rel` `t`  INNER JOIN `en_movie` `movie_2` ON
(`t`.`movie_id_2`=`movie_2`.`id`) WHERE (t.movie_id_1 = 10203) ORDER BY
movie_2.weight DESC LIMIT 5)

begin:system.db.CDbCommand.query(SELECT * FROM `en_movie` `t` WHERE
`t`.`id`=38371 LIMIT 1)

end:system.db.CDbCommand.query(SELECT * FROM `en_movie` `t` WHERE
`t`.`id`=38371 LIMIT 1)