Skip to content

Instantly share code, notes, and snippets.

@piyushranjan

piyushranjan/gist:389373

Created May 4, 2010 12:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save piyushranjan/389373 to your computer and use it in GitHub Desktop.
Save piyushranjan/389373 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
>> Loan.first(:amount.not => :amount_applied_for)
~ (0.001025) SELECT `id`, `discriminator`, `amount`, `amount_applied_for`, `amount_sanctioned`, `interest_rate`, `installment_frequency`, `number_of_installments`, `scheduled_disbursal_date`, `scheduled_first_payment_date`, `applied_on`, `approved_on`, `rejected_on`, `disbursal_date`, `written_off_on`, `validated_on`, `created_at`, `updated_at`, `loan_product_id`, `applied_by_staff_id`, `approved_by_staff_id`, `rejected_by_staff_id`, `disbursed_by_staff_id`, `written_off_by_staff_id`, `validated_by_staff_id`, `verified_by_user_id`, `created_by_user_id`, `cheque_number`, `cycle_number`, `original_amount`, `original_disbursal_date`, `original_first_payment_date`, `taken_over_on`, `taken_over_on_installment_number`, `occupation_id`, `funding_line_id`, `client_id` FROM `loans` WHERE `deleted_at` IS NULL AND `discriminator` IN ('Loan', 'DefaultLoan', 'A50Loan', 'EquatedWeekly', 'BulletLoan', 'BulletLoanWithPeriodicInterest', 'PararthRounded', 'TakeOverLoan', 'TakeOverDefaultLoan', 'TakeOverA50Loan', 'TakeOverEquatedWeekly', 'TakeOverBulletLoan', 'TakeOverBulletLoanWithPeriodicInterest', 'TakeOverPararthRounded') AND `amount` <> 97801 ORDER BY `id` LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment