output1.txt

1
0
0
0
0
0
0
0
2
11
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0

output2.txt

1
0
0
0
0
0
0
0
2
11
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0

query1.sql

SELECT COUNT("localtv_watch"."id") AS "watch_count" FROM "localtv_video" LEFT OUTER JOIN "localtv_watch" ON ("localtv_video"."id" = "localtv_watch"."video_id") GROUP BY "localtv_video"."id";

query2.sql

SELECT COUNT("localtv_watch"."id") AS "watch_count" FROM "localtv_video" LEFT OUTER JOIN "localtv_watch" ON ("localtv_video"."id" = "localtv_watch"."video_id") GROUP BY "localtv_video"."id", "localtv_video"."has_thumbnail", "localtv_video"."thumbnail_extension", "localtv_video"."name", "localtv_video"."description", "localtv_video"."thumbnail_url", "localtv_video"."site_id", "localtv_video"."file_url", "localtv_video"."file_url_length", "localtv_video"."file_url_mimetype", "localtv_video"."when_modified", "localtv_video"."when_submitted", "localtv_video"."when_approved", "localtv_video"."when_published", "localtv_video"."last_featured", "localtv_video"."status", "localtv_video"."feed_id", "localtv_video"."website_url", "localtv_video"."embed_code", "localtv_video"."flash_enclosure_url", "localtv_video"."guid", "localtv_video"."user_id", "localtv_video"."search_id", "localtv_video"."video_service_user", "localtv_video"."video_service_url", "localtv_video"."contact", "localtv_video"."notes", "localtv_video"."calculated_source_type", "localtv_video"."id", "localtv_video"."has_thumbnail", "localtv_video"."thumbnail_extension", "localtv_video"."name", "localtv_video"."description", "localtv_video"."thumbnail_url", "localtv_video"."site_id", "localtv_video"."file_url", "localtv_video"."file_url_length", "localtv_video"."file_url_mimetype", "localtv_video"."when_modified", "localtv_video"."when_submitted", "localtv_video"."when_approved", "localtv_video"."when_published", "localtv_video"."last_featured", "localtv_video"."status", "localtv_video"."feed_id", "localtv_video"."website_url", "localtv_video"."embed_code", "localtv_video"."flash_enclosure_url", "localtv_video"."guid", "localtv_video"."user_id", "localtv_video"."search_id", "localtv_video"."video_service_user", "localtv_video"."video_service_url", "localtv_video"."contact", "localtv_video"."notes", "localtv_video"."calculated_source_type";