search for: t2_r0

...quot; AS t1_r3, teams_seasons."season_id" AS t0_r2, matches."venue_id" AS t2_r9, matches."division_id" AS t1_r10, matches."hometeam_id" AS t1_r4, teams_seasons."coach_id" AS t0_r3, matches."division_id" AS t2_r10, matches."id" AS t2_r0, matches."played" AS t1_r11, matches."matchtime_start" AS t1_r5, teams_seasons."manager_id" AS t0_r4, matches."played" AS t2_r11, matches."matchtime_stop" AS t1_r6, teams_seasons."league_id" AS t0_r5 FROM teams_seasons LEFT OUTER JOIN mat...

...tions.cvsdir AS t0_r6, publications.publishername AS t0_r7, publications.publisherorg AS t0_r8, publications.release_state_id AS t0_r9, doc_types.id AS t1_r0, doc_types.code AS t1_r1, doc_types.en AS t1_r2, doc_types.es AS t1_r3, doc_types.sv AS t1_r4, doc_types.descr AS t1_r5, release_states.id AS t2_r0, release_states.code AS t2_r1, release_states.name AS t2_r2, release_states.descr AS t2_r3 FROM publications LEFT OUTER JOIN doc_types ON doc_types.publication_id = publications.id LEFT OUTER JOIN release_states ON release_states.publication_id = publications.id Obviously, the joins should be:...

...(0.010000) [0;37mSELECT wheres.id AS t2_r1, todos.position AS t0_r6, wheres.category_id AS t2_r2, todos.due AS t0_r7, whens.todo_id AS t1_r0, whens.id AS t1_r1, todos.repeat_id AS t0_r0, whens.category_id AS t1_r2, todos.hour AS t0_r1, todos.priority AS t0_r2, todos.id AS t0_r3, wheres.todo_id AS t2_r0, todos.description AS t0_r4, todos.kind_id AS t0_r5 FROM todos LEFT OUTER JOIN whens ON whens.todo_id = todos.id LEFT OUTER JOIN wheres ON wheres.todo_id = todos.id ORDER BY position ASC [4;33mWhere Load (0.010000) [1;37mSELECT * FROM wheres WHERE wheres.todo_id = 416 LIMIT 1 [4;35mSQL (0.00...

...sponsor_agen cies.`created_on` AS t1_r6, sponsor_agencies.`updated_at` AS t1_r7, sponsor_agen cies.`updated_on` AS t1_r8, sponsor_agencies.`lock_version` AS t1_r9, sponsor_ag encies.`created_by` AS t1_r10, sponsor_agencies.`updated_by` AS t1_r11, mechanis ms.`id` AS t2_r0, mechanisms.`name` AS t2_r1, mechanisms.`description` AS t2_r2, mechanisms.`created_at` AS t2_r3, mechanisms.`created_on` AS t2_r4, mechanisms. `updated_at` AS t2_r5, mechanisms.`updated_on` AS t2_r6, mechanisms.`lock_versio n` AS t2_r7, mechanisms.`created_by` AS t2_r8, mecha...

...ls.user_id", :conditions => "mails.user_id=1", :include => { :user => :headshot }, :order => "u.name") Now, the following SQL will be generated for the above statement: SELECT `mails`.`id` AS t0_r0, `mails` ... `users`.`id` AS t1_r0, .. `photos`.`id` AS t2_r0, FROM `mails` LEFT OUT JOIN `users` ON `users`.id = `mails`.user_id LEFT OUTER JOIN `photos` ON photos.user_id = users.id INNER JOIN users u ON u.id = mails.user_id WHERE (mails.user_id=1) ORDER BY u.name Notice the LEFT OUTER join being added. While the SQL is okay and gets the right results, it...

...t1_r0, `resources`.`title` AS t1 _r1, `resources`.`restype` AS t1_r2, `resources`.`host_id` AS t1_r3, `resources`.`source_file_id` AS t1_r4, `resources`.`exported` AS t1_r5, `resources`.`line` AS t1_r6, `resources `.`updated_at` AS t1_r7, `resources`.`created_at` AS t1_r8, `param_values`.`id` AS t2_r0, `param_values`.`value` AS t2_r1, `param_values`.`param_name_id` AS t2_r2, `param_values`.` line` AS t2_r3, `param_values`.`resource_id` AS t2_r4, `param_values`.`updated_at` AS t2_r5, `param_values`.`created_at` AS t2_r6, `puppet_tags`.`id` AS t3_r0, `puppet_tags`.`name` AS t3_r1, `puppet_tags...

I offer my apologies in advance for the repost. On a list as busy as this, it is sometimes easy to get missed in the shuffle. I am trying to create, display and edit a referenced object''s text field on the same view as my root object. For example: ------------------------- Quiz: <<quiz.name>> Preamble: <<quiz.preamble_presentation.text>> Postamble: