| 1 | SELECT `InstitutePackage`.`id`, `InstitutePackage`.`institute_id`, `InstitutePackage`.`name`, `InstitutePackage`.`url`, `InstitutePackage`.`title`, `InstitutePackage`.`language_id`, `InstitutePackage`.`description`, `InstitutePackage`.`content`, `InstitutePackage`.`package_image`, `InstitutePackage`.`og_banner`, `InstitutePackage`.`referral_description`, `InstitutePackage`.`video_type`, `InstitutePackage`.`video_url`, `InstitutePackage`.`exam_id`, `InstitutePackage`.`total_price`, `InstitutePackage`.`discount`, `InstitutePackage`.`final_price`, `InstitutePackage`.`addons`, `InstitutePackage`.`status`, `InstitutePackage`.`plan`, `InstitutePackage`.`is_home_page`, `InstitutePackage`.`institute_percentage`, `InstitutePackage`.`is_buy_subject_wise`, `InstitutePackage`.`start_date`, `InstitutePackage`.`end_date`, `InstitutePackage`.`live_class_start_date`, `InstitutePackage`.`live_class_end_date`, `InstitutePackage`.`offer_end_date`, `InstitutePackage`.`is_fee`, `InstitutePackage`.`is_optional`, `InstitutePackage`.`package_order`, `InstitutePackage`.`demo_video`, `InstitutePackage`.`is_fetched`, `InstitutePackage`.`banner_url`, `InstitutePackage`.`is_hide`, `InstitutePackage`.`is_out_of_stock`, `InstitutePackage`.`is_live`, `InstitutePackage`.`exam_date`, `InstitutePackage`.`created`, `InstitutePackage`.`modified`, `Page`.`id`, `Page`.`name`, `Page`.`logo`, `Page`.`url` FROM `livedb`.`institute_packages` AS `InstitutePackage` LEFT JOIN `livedb`.`pages` AS `Page` ON (`InstitutePackage`.`institute_id` = `Page`.`id`) WHERE `InstitutePackage`.`url` = 'ssc-constable-gd-course' AND `InstitutePackage`.`status` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `InstitutePackagePrice`.`id`, `InstitutePackagePrice`.`institute_package_id`, `InstitutePackagePrice`.`subject_id`, `InstitutePackagePrice`.`amount`, `InstitutePackagePrice`.`discount`, `InstitutePackagePrice`.`faculty_id`, `InstitutePackagePrice`.`created`, `InstitutePackagePrice`.`total_quiz`, `InstitutePackagePrice`.`order`, `InstitutePackagePrice`.`sectional_test`, `InstitutePackagePrice`.`full_mocktest`, `InstitutePackagePrice`.`old_paper`, `InstitutePackagePrice`.`modified`, `InstitutePackagePrice`.`status` FROM `livedb`.`institute_packages_prices` AS `InstitutePackagePrice` WHERE `InstitutePackagePrice`.`institute_package_id` = (12) | | 7 | 7 | 1 |
| 3 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"32\"]' | | 0 | 0 | 0 |
| 4 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"28\"]' | | 0 | 0 | 0 |
| 5 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"31\",\"21\",\"20\",\"30\"]' | | 0 | 0 | 0 |
| 6 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"40\",\"36\"]' | | 0 | 0 | 0 |
| 7 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"41\",\"42\"]' | | 0 | 0 | 0 |
| 8 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"34\"]' | | 0 | 0 | 0 |
| 9 | SELECT `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_faculties` AS `InstituteFaculty` WHERE `InstituteFaculty`.`id` = '[\"33\"]' | | 0 | 0 | 0 |
| 10 | SELECT `UserPackageOrder`.`id`, `UserPackageOrder`.`package_id`, `UserPackageOrder`.`package_name`, `UserPackageOrder`.`ras_package_id`, `UserPackageOrder`.`ras_package_name`, `UserPackageOrder`.`series_id`, `UserPackageOrder`.`series_name`, `UserPackageOrder`.`subscription_id`, `UserPackageOrder`.`subscription_name`, `UserPackageOrder`.`subject_id`, `UserPackageOrder`.`institute_id`, `UserPackageOrder`.`institute_name`, `UserPackageOrder`.`order_id`, `UserPackageOrder`.`user_id`, `UserPackageOrder`.`user_name`, `UserPackageOrder`.`txn_id`, `UserPackageOrder`.`amount`, `UserPackageOrder`.`is_series`, `UserPackageOrder`.`is_ras_package`, `UserPackageOrder`.`is_subscription`, `UserPackageOrder`.`is_free_subscription`, `UserPackageOrder`.`coupon_code`, `UserPackageOrder`.`is_referral`, `UserPackageOrder`.`discount`, `UserPackageOrder`.`status`, `UserPackageOrder`.`is_refund`, `UserPackageOrder`.`txn_date`, `UserPackageOrder`.`checksumhash`, `UserPackageOrder`.`payment_mode`, `UserPackageOrder`.`bank_txn_id`, `UserPackageOrder`.`tex_section`, `UserPackageOrder`.`vendor_tex_section`, `UserPackageOrder`.`institute_tex_section`, `UserPackageOrder`.`created`, `UserPackageOrder`.`payfromwallet`, `UserPackageOrder`.`vendor_id`, `UserPackageOrder`.`deviceId`, `UserPackageOrder`.`phoneId`, `UserPackageOrder`.`days`, `UserPackageOrder`.`is_exam_date`, `UserPackageOrder`.`razorpay_order_id`, `UserPackageOrder`.`remark`, `UserPackageOrder`.`language_id` FROM `livedb`.`user_package_orders` AS `UserPackageOrder` WHERE `UserPackageOrder`.`user_id` IS NULL AND `UserPackageOrder`.`package_id` = 12 AND `UserPackageOrder`.`status` = 0 ORDER BY `id` DESC LIMIT 1 | | 0 | 0 | 0 |
| 11 | SELECT `InstitutePackagePrice`.`id`, `InstitutePackagePrice`.`institute_package_id`, `InstitutePackagePrice`.`subject_id`, `InstitutePackagePrice`.`amount`, `InstitutePackagePrice`.`discount`, `InstitutePackagePrice`.`faculty_id`, `InstitutePackagePrice`.`created`, `InstitutePackagePrice`.`total_quiz`, `InstitutePackagePrice`.`order`, `InstitutePackagePrice`.`sectional_test`, `InstitutePackagePrice`.`full_mocktest`, `InstitutePackagePrice`.`old_paper`, `InstitutePackagePrice`.`modified`, `InstitutePackagePrice`.`status`, `InstituteFaculty`.`id`, `InstituteFaculty`.`name`, `InstituteFaculty`.`photo` FROM `livedb`.`institute_packages_prices` AS `InstitutePackagePrice` LEFT JOIN `livedb`.`institute_faculties` AS `InstituteFaculty` ON (`InstitutePackagePrice`.`faculty_id` = `InstituteFaculty`.`id`) WHERE `InstitutePackagePrice`.`institute_package_id` = 12 | | 7 | 7 | 1 |
