Advertisement
Guest User

Untitled

a guest
May 7th, 2012
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.41 KB | None | 0 0
  1. The FIRST one IS
  2. SELECT `t0`.`id` AS `t0_c0`, `t0`.`title` AS `t0_c1`, `t0`.`plot` AS `t0_c2`, `t0`.`plotsummary` AS `t0_c3`, `t0`.`tagline` AS `t0_c4`, `t0`.`rating` AS `t0_c5`, `t0`.`votes` AS `t0_c6`, `t0`.`released` AS `t0_c7`, `t0`.`runtime` AS `t0_c8`, `t0`.`runtime_file` AS `t0_c9`, `t0`.`contentrating` AS `t0_c10`, `t0`.`originaltitle` AS `t0_c11`, `t0`.`thumb` AS `t0_c12`, `t0`.`fanart` AS `t0_c13`, `t0`.`trailer_url` AS `t0_c14`, `t0`.`created_at` AS `t0_c15`, `t0`.`updated_at` AS `t0_c16`, `t0`.`file_id` AS `t0_c17`, `t1`.`id` AS `t1_c0`, `t1`.`path` AS `t1_c1`, `t1`.`created_at` AS `t1_c2`, `t1`.`updated_at` AS `t1_c3`, `t1`.`source_id` AS `t1_c4` FROM (SELECT `t0`.`id`, `t0`.`title`, `t0`.`plot`, `t0`.`plotsummary`, `t0`.`tagline`, `t0`.`rating`, `t0`.`votes`, `t0`.`released`, `t0`.`runtime`, `t0`.`runtime_file`, `t0`.`contentrating`, `t0`.`originaltitle`, `t0`.`thumb`, `t0`.`fanart`, `t0`.`trailer_url`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`file_id` FROM `movies` AS `t0` ORDER BY `t0`.`id` ASC LIMIT 1) AS `t0` LEFT JOIN `files` AS `t1` ON (`t0`.`file_id` = `t1`.`id`) WHERE `t1`.`path` = 'movies/about a Boy (2002)/about.a.boy.2002.mkv' ORDER BY `t0`.`id` ASC
  3.  
  4. SECOND one IS
  5. SELECT `t0`.`id` AS `t0_c0`, `t0`.`title` AS `t0_c1`, `t0`.`plot` AS `t0_c2`, `t0`.`plotsummary` AS `t0_c3`, `t0`.`tagline` AS `t0_c4`, `t0`.`rating` AS `t0_c5`, `t0`.`votes` AS `t0_c6`, `t0`.`released` AS `t0_c7`, `t0`.`runtime` AS `t0_c8`, `t0`.`runtime_file` AS `t0_c9`, `t0`.`contentrating` AS `t0_c10`, `t0`.`originaltitle` AS `t0_c11`, `t0`.`thumb` AS `t0_c12`, `t0`.`fanart` AS `t0_c13`, `t0`.`trailer_url` AS `t0_c14`, `t0`.`created_at` AS `t0_c15`, `t0`.`updated_at` AS `t0_c16`, `t0`.`file_id` AS `t0_c17`, `t1`.`id` AS `t1_c0`, `t1`.`path` AS `t1_c1`, `t1`.`created_at` AS `t1_c2`, `t1`.`updated_at` AS `t1_c3`, `t1`.`source_id` AS `t1_c4` FROM (SELECT `t0`.`id`, `t0`.`title`, `t0`.`plot`, `t0`.`plotsummary`, `t0`.`tagline`, `t0`.`rating`, `t0`.`votes`, `t0`.`released`, `t0`.`runtime`, `t0`.`runtime_file`, `t0`.`contentrating`, `t0`.`originaltitle`, `t0`.`thumb`, `t0`.`fanart`, `t0`.`trailer_url`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`file_id` FROM `movies` AS `t0` ORDER BY `t0`.`id` ASC LIMIT 1) AS `t0` LEFT JOIN `files` AS `t1` ON (`t0`.`file_id` = `t1`.`id`) WHERE `t1`.`path` = 'movies/Cell 211 (2009)/cell.211.2009.mkv' ORDER BY `t0`.`id` ASC
  6.  
  7. The ONLY thing that differs IS the path, but the query RESULT IS different
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement