Skip to content

Instantly share code, notes, and snippets.

@justinvt
Created June 9, 2009 20:08
Show Gist options
  • Save justinvt/126755 to your computer and use it in GitHub Desktop.
Save justinvt/126755 to your computer and use it in GitHub Desktop.
tweety_jobs_development.job_sources' doesn't exist: SELECT 'Job' AS polymorphic_parent_class, 'sources' AS polymorphic_association_id, channels.created_at AS t0_r4, channels.description AS t0_r2, channels.frequency AS t0_r6, channels.id AS t0_r0, channels.max_id AS t0_r7, channels.name AS t0_r1, channels.read_at AS t0_r3, channels.updated_at AS t0_r5, feeds.created_at AS t1_r6, feeds.fields AS t1_r2, feeds.id AS t1_r0, feeds.method AS t1_r3, feeds.name AS t1_r4, feeds.read_at AS t1_r5, feeds.updated_at AS t1_r7, feeds.url AS t1_r1, hash_tags.average_frequency AS t2_r5, hash_tags.created_at AS t2_r6, hash_tags.description AS t2_r2, hash_tags.id AS t2_r0, hash_tags.name AS t2_r1, hash_tags.next_read AS t2_r4, hash_tags.read_at AS t2_r3, hash_tags.updated_at AS t2_r7, users.access_secret AS t4_r52, users.access_token AS t4_r51, users.activated_at AS t4_r59, users.activation_code AS t4_r57, users.address_1 AS t4_r42, users.address_2 AS t4_r43, users.avatar_content_type AS t4_r34, users.avatar_file_name AS t4_r33, users.avatar_file_size AS t4_r35, users.avatar_updated_at AS t4_r36, users.cell_phone AS t4_r10, users.citizenship_status_id AS t4_r18, users.city AS t4_r4, users.company_id AS t4_r1, users.created_at AS t4_r45, users.crypted_password AS t4_r47, users.deleted_at AS t4_r31, users.desired_position_type AS t4_r12, users.email AS t4_r7, users.employment_type_id AS t4_r14, users.experience_level_id AS t4_r19, users.first_name AS t4_r2, users.home_phone AS t4_r9, users.hourly_rate_id AS t4_r22, users.id AS t4_r0, users.industry_id AS t4_r17, users.last_login_at AS t4_r30, users.last_name AS t4_r3, users.linked_in_profile AS t4_r25, users.location AS t4_r41, users.name AS t4_r60, users.placemark AS t4_r44, users.position_type_id AS t4_r20, users.private AS t4_r32, users.profile_image_url AS t4_r55, users.remember_token AS t4_r49, users.remember_token_expires_at AS t4_r50, users.reset_code AS t4_r58, users.resume_content_type AS t4_r38, users.resume_file_name AS t4_r37, users.resume_file_size AS t4_r39, users.resume_updated_at AS t4_r40, users.salary_id AS t4_r23, users.salt AS t4_r48, users.scraped_at AS t4_r56, users.screen_name AS t4_r54, users.search_status_id AS t4_r21, users.skills_microsummary AS t4_r27, users.skills_summary AS t4_r26, users.sms_phone AS t4_r11, users.state AS t4_r5, users.travel_status_id AS t4_r16, users.twitter_id AS t4_r53, users.type AS t4_r29, users.updated_at AS t4_r46, users.url AS t4_r13, users.will_relocate AS t4_r28, users.work_eligibility_status_id AS t4_r24, users.work_phone AS t4_r8, users.years_experience_id AS t4_r15, users.zip AS t4_r6 FROM `job_sources` JOIN `jobs` AS polymorphic_parent ON `job_sources`.job_id = polymorphic_parent.id LEFT JOIN `users` ON `job_sources`.source_id = `users`.id AND `job_sources`.source_type = 'User' LEFT JOIN `feeds` ON `job_sources`.source_id = `feeds`.id AND `job_sources`.source_type = 'Feed' LEFT JOIN `hash_tags` ON `job_sources`.source_id = `hash_tags`.id AND `job_sources`.source_type = 'HashTag' LEFT JOIN `channels` ON `job_sources`.source_id = `channels`.id AND `job_sources`.source_type = 'Channel' WHERE ((`job_sources`.job_id = 1))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment