SELECT assets.`id` AS t0_r0, assets.`sti_type` AS t0_r1, assets.`label` AS t0_r2, assets.`updated_at` AS t0_r3, assets.`created_at` AS t0_r4, assets.`content_type` AS t0_r5, assets.`filename` AS t0_r6, assets.`size` AS t0_r7, assets.`width` AS t0_r8, assets.`height` AS t0_r9, assets.`parent_id` AS t0_r10, assets.`thumbnail` AS t0_r11, users.`id` AS t1_r0, users.`login` AS t1_r1, users.`crypted_password` AS t1_r2, users.`salt` AS t1_r3, users.`created_at` AS t1_r4, users.`updated_at` AS t1_r5, users.`remember_token` AS t1_r6, users.`remember_token_expires_at` AS t1_r7, users.`activation_code` AS t1_r8, users.`activated_at` AS t1_r9, users.`full_name` AS t1_r10, users.`phone` AS t1_r11, users.`fax` AS t1_r12, users.`company_name` AS t1_r13, users.`address1` AS t1_r14, users.`address2` AS t1_r15, users.`city` AS t1_r16, users.`state` AS t1_r17, users.`zipcode` AS t1_r18, users.`country` AS t1_r19 FROM assets LEFT OUTER JOIN asset_mappings ON (assets.id = asset_mappings.owner_id AND asset_mappings.`owner_type` = 'Asset' AND asset_mappings.`target_type` = 'User') LEFT OUTER JOIN users ON (users.id = asset_mappings.target_id)