-- ================================================================
-- Complete Grade 11 Physics Course Insert Commands
-- All videos from the text file included with hierarchical structure
-- ================================================================

-- 1. Insert the main course
INSERT INTO `courses` (`id`, `institute_id`, `primary_instructor_id`, `title`, `course_code`, `max_students`, `certificate_template`, `is_public`, `approval_status`, `approved_by`, `approved_at`, `subtitle`, `description`, `price`, `discount`, `image_url`, `video_preview_url`, `level`, `category_id`, `type`, `language`, `duration_hours`, `total_lessons`, `total_resources`, `prerequisites`, `outcomes`, `target_audience`, `publication_date`, `status`, `rating`, `reviews_count`, `enrollments_count`, `is_featured`, `is_top_selling`, `is_trending`, `tags`, `difficulty_score`, `created_at`, `updated_at`, `instructor_id`, `instructor_name`, `grade_level`) VALUES
(8, 1, 1, 'Grade 11 Physics Course', 'PHYS-11-001', 0, NULL, 1, 'approved', 1, NOW(), 'Complete Physics curriculum for Grade 11 students', 'Comprehensive Grade 11 Physics course covering all NEB syllabus topics including Mechanics, Heat and Thermodynamics, Optics, Electricity, and Modern Physics with detailed video lectures by expert instructor CLC Sir', 4200.00, 500.00, 'https://img.youtube.com/vi/LKqquATip3U/maxresdefault.jpg', 'https://www.youtube.com/watch?v=LKqquATip3U', 'Advanced', 1, 'Self-paced', 'English', 180, 89, 25, 'Successful completion of Grade 10 with strong foundation in mathematics and basic science', 'Master all Grade 11 Physics concepts, prepare for NEB board exams, and build foundation for higher studies in physics and engineering', 'Grade 11 students in Nepal following NEB curriculum, science stream students', '2024-01-01', 'active', 4.6, 450, 1200, 1, 1, 1, 'grade11,physics,neb,science,mechanics,thermodynamics,optics,electricity,modern physics', 4.2, NOW(), NOW(), 1, 'CLC Sir', 11);

-- 2. Add course to institute
INSERT INTO `institute_courses` (`id`, `institute_id`, `course_id`, `display_order`, `is_featured`, `custom_price`, `custom_description`, `status`, `created_at`) VALUES
(4, 1, 8, 4, 1, NULL, 'Complete Grade 11 Physics course with expert instruction by CLC Sir', 'active', NOW());

-- 3. Insert main subject topic (Physics)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1001, 8, 'Physics', 'Complete Physics curriculum for Grade 11 Course', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, NULL, 0, 'Grade 11 Physics Course/Physics');

-- 4. Insert main chapters (level 1)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1002, 8, 'Mechanics', 'Study of motion, forces, and energy', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, 1001, 1, 'Grade 11 Physics Course/Physics/Mechanics'),
(1003, 8, 'Heat and Thermodynamics', 'Study of heat, temperature, and thermal properties', 'video', NULL, 2, 0, 1, 'active', NOW(), NOW(), 2, 1, 1001, 1, 'Grade 11 Physics Course/Physics/Heat and Thermodynamics'),
(1004, 8, 'Optics', 'Study of light and optical phenomena', 'video', NULL, 3, 0, 1, 'active', NOW(), NOW(), 3, 1, 1001, 1, 'Grade 11 Physics Course/Physics/Optics'),
(1005, 8, 'Electricity', 'Study of electric charges, fields, and circuits', 'video', NULL, 4, 0, 1, 'active', NOW(), NOW(), 4, 1, 1001, 1, 'Grade 11 Physics Course/Physics/Electricity'),
(1006, 8, 'Modern Physics', 'Study of nuclear physics and recent trends', 'video', NULL, 5, 0, 1, 'active', NOW(), NOW(), 5, 1, 1001, 1, 'Grade 11 Physics Course/Physics/Modern Physics');

-- 5. Insert Mechanics sub-topics (level 2)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1007, 8, 'Physical Quantities', 'Measurement, units, and dimensional analysis', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Physical Quantities'),
(1008, 8, 'Vectors', 'Vector algebra and applications', 'video', NULL, 2, 0, 1, 'active', NOW(), NOW(), 2, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Vectors'),
(1009, 8, 'Kinematics', 'Motion in one and two dimensions', 'video', NULL, 3, 0, 1, 'active', NOW(), NOW(), 3, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Kinematics'),
(1010, 8, 'Dynamics', 'Forces and Newton\'s laws', 'video', NULL, 4, 0, 1, 'active', NOW(), NOW(), 4, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Dynamics'),
(1011, 8, 'Work, Energy, and Power', 'Energy concepts and conservation laws', 'video', NULL, 5, 0, 1, 'active', NOW(), NOW(), 5, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Work, Energy, and Power'),
(1012, 8, 'Circular Motion', 'Uniform circular motion and applications', 'video', NULL, 6, 0, 1, 'active', NOW(), NOW(), 6, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Circular Motion'),
(1013, 8, 'Gravitation', 'Universal gravitation and orbital motion', 'video', NULL, 7, 0, 1, 'active', NOW(), NOW(), 7, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Gravitation'),
(1014, 8, 'Elasticity', 'Stress, strain, and elastic properties', 'video', NULL, 8, 0, 1, 'active', NOW(), NOW(), 8, 1, 1002, 2, 'Grade 11 Physics Course/Physics/Mechanics/Elasticity');

-- 6. Insert Heat and Thermodynamics sub-topics (level 2)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1015, 8, 'Heat and Temperature', 'Basic concepts of heat and temperature', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, 1003, 2, 'Grade 11 Physics Course/Physics/Heat and Thermodynamics/Heat and Temperature'),
(1016, 8, 'Thermal Expansion', 'Expansion of solids, liquids, and gases', 'video', NULL, 2, 0, 1, 'active', NOW(), NOW(), 2, 1, 1003, 2, 'Grade 11 Physics Course/Physics/Heat and Thermodynamics/Thermal Expansion'),
(1017, 8, 'Quantity of Heat', 'Specific heat, latent heat, and calorimetry', 'video', NULL, 3, 0, 1, 'active', NOW(), NOW(), 3, 1, 1003, 2, 'Grade 11 Physics Course/Physics/Heat and Thermodynamics/Quantity of Heat'),
(1018, 8, 'Rate of Heat Flow', 'Heat transfer mechanisms', 'video', NULL, 4, 0, 1, 'active', NOW(), NOW(), 4, 1, 1003, 2, 'Grade 11 Physics Course/Physics/Heat and Thermodynamics/Rate of Heat Flow'),
(1019, 8, 'Ideal Gas', 'Gas laws and kinetic theory', 'video', NULL, 5, 0, 1, 'active', NOW(), NOW(), 5, 1, 1003, 2, 'Grade 11 Physics Course/Physics/Heat and Thermodynamics/Ideal Gas');

-- 7. Insert Optics sub-topics (level 2)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1020, 8, 'Reflection at Curved Mirror', 'Spherical mirrors and their applications', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, 1004, 2, 'Grade 11 Physics Course/Physics/Optics/Reflection at Curved Mirror'),
(1021, 8, 'Refraction at Plane Surface', 'Laws of refraction and applications', 'video', NULL, 2, 0, 1, 'active', NOW(), NOW(), 2, 1, 1004, 2, 'Grade 11 Physics Course/Physics/Optics/Refraction at Plane Surface'),
(1022, 8, 'Refraction Through Prisms', 'Prism theory and applications', 'video', NULL, 3, 0, 1, 'active', NOW(), NOW(), 3, 1, 1004, 2, 'Grade 11 Physics Course/Physics/Optics/Refraction Through Prisms'),
(1023, 8, 'Lenses', 'Thin lenses and optical instruments', 'video', NULL, 4, 0, 1, 'active', NOW(), NOW(), 4, 1, 1004, 2, 'Grade 11 Physics Course/Physics/Optics/Lenses'),
(1024, 8, 'Dispersion', 'Color and dispersion of light', 'video', NULL, 5, 0, 1, 'active', NOW(), NOW(), 5, 1, 1004, 2, 'Grade 11 Physics Course/Physics/Optics/Dispersion');

-- 8. Insert Electricity sub-topics (level 2)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1025, 8, 'Electric Charges', 'Coulomb\'s law and electric charge', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, 1005, 2, 'Grade 11 Physics Course/Physics/Electricity/Electric Charges'),
(1026, 8, 'Electric Field', 'Electric field and field lines', 'video', NULL, 2, 0, 1, 'active', NOW(), NOW(), 2, 1, 1005, 2, 'Grade 11 Physics Course/Physics/Electricity/Electric Field'),
(1027, 8, 'Electric Potential and Energy', 'Electric potential and potential energy', 'video', NULL, 3, 0, 1, 'active', NOW(), NOW(), 3, 1, 1005, 2, 'Grade 11 Physics Course/Physics/Electricity/Electric Potential and Energy'),
(1028, 8, 'Capacitor', 'Capacitance and energy storage', 'video', NULL, 4, 0, 1, 'active', NOW(), NOW(), 4, 1, 1005, 2, 'Grade 11 Physics Course/Physics/Electricity/Capacitor'),
(1029, 8, 'DC Circuit', 'Direct current circuits and analysis', 'video', NULL, 5, 0, 1, 'active', NOW(), NOW(), 5, 1, 1005, 2, 'Grade 11 Physics Course/Physics/Electricity/DC Circuit');

-- 9. Insert Modern Physics sub-topics (level 2)
INSERT INTO `topics` (`id`, `course_id`, `title`, `description`, `content_type`, `content_url`, `order`, `duration_minutes`, `is_previewable`, `status`, `created_at`, `updated_at`, `order_sequence`, `is_active`, `parent_topic_id`, `level`, `full_path`) VALUES
(1030, 8, 'Nuclear Physics', 'Atomic nucleus and radioactivity', 'video', NULL, 1, 0, 1, 'active', NOW(), NOW(), 1, 1, 1006, 2, 'Grade 11 Physics Course/Physics/Modern Physics/Nuclear Physics'),
(1031, 8, 'Solid', 'Solid state physics', 'video', NULL, 2, 0, 1, 'active', NOW(), NOW(), 2, 1, 1006, 2, 'Grade 11 Physics Course/Physics/Modern Physics/Solid'),
(1032, 8, 'Recent Trends in Physics', 'Modern developments in physics', 'video', NULL, 3, 0, 1, 'active', NOW(), NOW(), 3, 1, 1006, 2, 'Grade 11 Physics Course/Physics/Modern Physics/Recent Trends in Physics');

-- 10. Insert ALL 89 Videos from the text file

-- Heat and Thermodynamics videos
INSERT INTO `videos` (`id`, `title`, `video_url`, `type`, `description`, `credit`, `for_which`, `level`, `image_url`, `video_duration`, `count_exercises`, `count_students`, `count_plays`, `count_views`, `count_likes`, `count_comments`, `short_description`, `course_id`, `is_live`, `chat_id`, `is_active`, `free`, `created_at`, `updated_at`, `topic_id`) VALUES
(5001, 'Principle of Calorimetry || Result of Mixing Hot water & Cold Ice || Grade-11 Physics NEB || CLC Sir', 'https://www.youtube.com/watch?v=6kvrGIzwqII', 'youtube', 'Principle of Calorimetry || Result of Mixing Hot water & Cold Ice || Grade-11 Physics NEB || Full Solution By CLC Sir # Numerical-2', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/6kvrGIzwqII/sddefault.jpg', '00:18:19', 0, 0, 0, 282, 21, 7, 'Calorimetry principle with ice water mixing', 8, 0, 'calorimetry_1', 1, 1, '2024-05-01 16:34:40', NOW(), 1017),

(5002, 'Quantity of Heat, Grade-11 Physics NEB || Convert -10°C  Ice into 100°C Steam ||Solution By CLC Sir', 'https://www.youtube.com/watch?v=tog0xt167fI', 'youtube', 'Quantity of Heat, Grade-11 Physics NEB || Conversion of  -10°C  Ice into 100°C Steam ||Complete & Easy Solution By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/tog0xt167fI/sddefault.jpg', '00:12:10', 0, 0, 0, 138, 16, 6, 'Ice to steam heat conversion calculation', 8, 0, 'ice_steam_1', 1, 1, '2024-05-03 03:39:58', NOW(), 1017),

(5003, 'Result of mixing  10 gm of ice at -10°C With 10 gm of water at 90°C || Principle of Calorimetry', 'https://www.youtube.com/watch?v=pryfafDtvCg', 'youtube', 'Result of mixing  10 gm of ice at -10°C With 10 gm of water at 90°C || Principle of Calorimetry Grade-11 Physics NEB By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/pryfafDtvCg/sddefault.jpg', '00:10:36', 0, 0, 0, 216, 18, 0, 'Ice water mixing numerical solution', 8, 0, 'ice_water_mix_1', 1, 1, '2024-05-03 15:26:56', NOW(), 1017),

-- Optics videos
(5004, 'Refraction Through Prism Important Numericals || Grade-11 Physics CTEVT & NEB || By CLC Sir', 'https://www.youtube.com/watch?v=B5DLXPMFTUA', 'youtube', 'Refraction Through Prism 3 Important Numericals || Grade-11  CTEVT & NEB Physics || Easy & Complete Solution By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/B5DLXPMFTUA/sddefault.jpg', '00:11:41', 0, 0, 0, 780, 48, 10, 'Prism refraction numerical problems', 8, 0, 'prism_numericals_1', 1, 1, '2024-05-10 03:43:34', NOW(), 1022),

-- Full Course Revision videos
(5005, 'Full Course Revision Series of Grade-11 Physics Part #01 || Exam Oriented Power Class By CLC Sir', 'https://www.youtube.com/watch?v=LKqquATip3U', 'youtube', 'Full Course Revision Series of Grade-11 Physics || Board Exam Oriented Power Classes By CLC Sir || CLC Physics Tutorials || With Crystal Clear Concept || Revise Full Course In a Copule of Hours', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/LKqquATip3U/sddefault.jpg', '01:21:58', 0, 0, 0, 3011, 195, 66, 'Full course revision part 1', 8, 0, 'revision_1', 1, 1, '2024-05-27 13:47:28', NOW(), 1001),

(5006, 'Full Course Revision Series of Grade-11 NEB Physics Part#02 ||Exam Oriented Power Classes By CLC Sir', 'https://www.youtube.com/watch?v=gTTQHKaDOF4', 'youtube', 'Full Course Revision Series of Grade-11 NEB Physics || Board Exam Oriented Power Classes By CLC Sir || CLC Physics Tutorials || With Crystal Clear Concept || Revise Full Course In a Copule of Hours', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/gTTQHKaDOF4/sddefault.jpg', '01:02:32', 0, 0, 0, 1428, 99, 27, 'Full course revision part 2', 8, 0, 'revision_2', 1, 1, '2024-05-28 00:47:52', NOW(), 1001),

(5007, 'Full Course Revision Series of Grade-11NEB Physics Part#03 ||Exam Oriented Power Classe By CLC Sir||', 'https://www.youtube.com/watch?v=ruPvq5sQCyA', 'youtube', 'Full Course Revision Series of Grade-11 NEB Physics Part#03 || Board Exam Oriented Power Classes By CLC Sir || CLC Physics Tutorials || With Crystal Clear Concept || Revise Full Course In a Copule of Hours', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/ruPvq5sQCyA/sddefault.jpg', '01:24:44', 0, 0, 0, 983, 94, 16, 'Full course revision part 3', 8, 0, 'revision_3', 1, 1, '2024-05-28 15:18:41', NOW(), 1001),

-- Mechanics videos
(5008, 'Important Questions Collection | Unit-1 Mechanics | Grade-11 Physics | 20 Days Exam Plan By CLC Sir', 'https://www.youtube.com/watch?v=dAwD-izYPwY', 'youtube', 'Important Questions Collection for Unit-1 Mechanics with 20 days exam preparation plan for Grade-11 Physics students.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/dAwD-izYPwY/maxresdefault.jpg', '00:24:12', 0, 0, 0, 844, 80, 21, 'Mechanics important questions collection', 8, 0, 'mech_questions_1', 1, 1, '2024-12-18 12:14:05', NOW(), 1002),

-- Heat Transfer videos
(5009, 'Heat Transfer: IMP Numerical Collection || Grade-11 Physics Thermal Conductivity || By CLC Sir', 'https://www.youtube.com/watch?v=iRaljAyJ65E', 'youtube', 'Welcome to CLC Physics & Maths Space! 🚀 In this video, we dive into the most important numerical problems on Heat Transfer and Thermal Conductivity for Grade 11 Physics. These problems are carefully selected to help you strengthen your concepts and excel in exams.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/iRaljAyJ65E/sddefault.jpg', '01:11:37', 0, 0, 0, 227, 22, 8, 'Heat transfer numerical problems', 8, 0, 'heat_transfer_1', 1, 1, '2025-03-31 04:36:42', NOW(), 1018),

(5010, 'Heat Transfer Numericals || Stefan\'s Law of Black Body Radiation || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=oAkPr3pbKDw', 'youtube', 'In this video, we explore Stefan\'s Law of Black Body Radiation and solve important numerical problems related to heat transfer. This topic is crucial for Grade-11 Physics students as it helps in understanding how a perfect black body emits energy based on its temperature.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/oAkPr3pbKDw/sddefault.jpg', '01:08:44', 0, 0, 0, 178, 14, 3, 'Stefan\'s law heat transfer numericals', 8, 0, 'stefan_law_1', 1, 1, '2025-03-31 15:09:25', NOW(), 1018),

-- Physical Quantities videos
(5011, 'Physical Quantities: One Shot Lecture || Grade-11 Physics || Grand Revision || Powered By CLC Sir', 'https://www.youtube.com/watch?v=8M9jcyC9MOM', 'youtube', 'Struggling with the basics of Physical Quantities in Grade 11 Physics? In this one-shot revision lecture, CLC Sir explains fundamental concepts, units, and dimensional analysis with clarity and real-life examples.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/8M9jcyC9MOM/sddefault.jpg', '02:36:15', 0, 0, 0, 612, 51, 16, 'Complete physical quantities concepts', 8, 0, 'phys_quantities_1', 1, 1, '2025-05-03 02:18:55', NOW(), 1007),

-- Vectors videos
(5012, 'Scalars & Vectors One Shot Lecture || Grand Revision Series || Grade-11 Physics || Powerd By CLC Sir', 'https://www.youtube.com/watch?v=rt0MborZPX8', 'youtube', 'Welcome to another powerful session by CLC Physics & Maths Space! In this One Shot Lecture, CLC Sir covers the complete concept of Scalars and Vectors—perfect for your Grade-11 Physics revision.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/rt0MborZPX8/maxresdefault.jpg', '02:02:01', 0, 0, 0, 298, 25, 7, 'Complete scalars and vectors concepts', 8, 0, 'vectors_1', 1, 1, '2025-05-06 00:03:40', NOW(), 1008),

(5013, 'Uses of Dimensional Analysis One Shot || 100% Fixed Questions || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=jjTMFhJYIsw', 'youtube', 'In this comprehensive one-shot video, CLC Sir explains the Uses of Dimensional Analysis—a crucial topic for Grade 11 Physics students. This session is specially designed to help you master all the 100% fixed questions that frequently appear in board exams and competitive tests.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/jjTMFhJYIsw/sddefault.jpg', '01:31:41', 0, 0, 0, 202, 20, 2, 'Dimensional analysis applications', 8, 0, 'dim_analysis_1', 1, 1, '2025-05-06 04:21:43', NOW(), 1007),

(5014, 'Accuracy & Precision | Significant Figure | Rounding off the numbers | One Shot Lecture | By CLC Sir', 'https://www.youtube.com/watch?v=UBp3_vncee0', 'youtube', 'Welcome to CLC Physics & Maths Space! In this One Shot Lecture, CLC Sir covers the most important and foundational topics in Grade-11 Physics — Accuracy & Precision, Significant Figures, and Rounding Off the Numbers.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/UBp3_vncee0/sddefault.jpg', '01:04:55', 0, 0, 0, 134, 14, 3, 'Accuracy precision significant figures', 8, 0, 'accuracy_1', 1, 1, '2025-05-06 14:08:36', NOW(), 1007),

(5015, 'Triangle, Parallelogram & Polygon Law of Vector Addition | 100% Fixed Derivation | Grade-11 By CLC', 'https://www.youtube.com/watch?v=zHGM_ZysiPQ', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir presents a 100% fixed and clear derivation of: Triangle Law of Vector Addition, Parallelogram Law of Vector Addition, Polygon Law of Vector Addition', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/zHGM_ZysiPQ/sddefault.jpg', '01:00:49', 0, 0, 0, 193, 25, 3, 'Vector addition laws derivation', 8, 0, 'vector_add_1', 1, 1, '2025-05-08 03:48:25', NOW(), 1008),

(5016, 'Resolution of vector || Dot product & cross product || Unit Vector || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=J_kmSRaCMg0', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir explains the fundamental concepts of Vectors for Grade-11 Physics, including: Resolution of Vectors, Dot Product & Cross Product, Unit Vector', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/J_kmSRaCMg0/sddefault.jpg', '01:02:03', 0, 0, 0, 201, 14, 10, 'Vector resolution and products', 8, 0, 'vector_res_1', 1, 1, '2025-05-09 01:18:28', NOW(), 1008),

(5017, 'Rate of Heat Transfer: Numerical Collection || Grade-11 Physics || B.E. Civil_I/B.E. Computer_II', 'https://www.youtube.com/watch?v=IgLU7ZheOsM', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, we dive into an important topic: Rate of Heat Transfer with a collection of solved numerical problems. This lesson is essential for Grade 11 Physics students, as well as B.E. Civil (I) and B.E. Computer (II) students.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/IgLU7ZheOsM/sddefault.jpg', '02:15:31', 0, 0, 0, 298, 28, 6, 'Heat transfer rate numerical problems', 8, 0, 'heat_rate_1', 1, 1, '2025-05-10 13:17:26', NOW(), 1018),

(5018, 'Grade-11 NEB Annual Examination || Syllabus, Question Pattern & Specification Grid   Discussion', 'https://www.youtube.com/watch?v=pkP1xVTS8_Y', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, we present a complete discussion on the Grade-11 NEB Annual Examination—covering the latest syllabus, question pattern, and specification grid as per the guidelines of the National Examination Board (NEB), Nepal.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/pkP1xVTS8_Y/sddefault.jpg', '00:26:58', 0, 0, 0, 1287, 86, 24, 'NEB exam pattern discussion', 8, 0, 'neb_pattern_1', 1, 1, '2025-05-15 11:22:47', NOW(), 1001),

-- Kinematics videos
(5019, 'Projectile Motion Theory  || Grade-11 Physics || 100% Sure Questions || Easy Explanation By CLC Sir', 'https://www.youtube.com/watch?v=gTKgwaT79OU', 'youtube', 'Welcome to CLC Physics & Maths Space – your trusted destination for fun and focused learning! In this video, CLC Sir breaks down the Projectile Motion Theory for Grade-11 Physics with easy explanations, clear concepts, and 100% sure-shot questions that are likely to be asked in exams.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/gTKgwaT79OU/maxresdefault.jpg', '01:26:26', 0, 0, 0, 499, 46, 18, 'Projectile motion theory and equations', 8, 0, 'proj_motion_1', 1, 1, '2025-05-17 13:50:13', NOW(), 1009),

(5020, 'Kinematics In One Shot || Grade-11 Physics || Grand Revision Series || 100% Syllabus || By CLC Sir', 'https://www.youtube.com/watch?v=ZYV2ZPgOlE8', 'youtube', 'Welcome to CLC Physics & Maths Space! In this power-packed One Shot Revision Session, CLC Sir covers the entire Kinematics chapter for Grade 11 Physics—perfect for last-minute preparation, quick revision, or conceptual clarity.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/ZYV2ZPgOlE8/maxresdefault.jpg', '02:51:09', 0, 0, 0, 340, 31, 8, 'Complete kinematics chapter revision', 8, 0, 'kinematics_1', 1, 1, '2025-05-18 23:37:40', NOW(), 1009),

(5021, 'Kinematical Equation of Motion || Proof With Graphical Method || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=jgFNGMn03uY', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir explains the Kinematical Equations of Motion using a graphical method, specially designed for Grade-11 Physics students.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/jgFNGMn03uY/maxresdefault.jpg', '00:40:12', 0, 0, 0, 186, 16, 1, 'Kinematic equations graphical derivation', 8, 0, 'kin_eq_1', 1, 1, '2025-05-19 13:28:56', NOW(), 1009),

(5022, 'Concept of Relative Velocity || How to calculate relative velocity ? || Grade-11 Physics By CLC Sir', 'https://www.youtube.com/watch?v=VLAeb8hglTA', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir explains the Concept of Relative Velocity in a simple and engaging way, specially designed for Grade-11 Physics students.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/VLAeb8hglTA/maxresdefault.jpg', '00:25:23', 0, 0, 0, 121, 13, 4, 'Relative velocity concepts and calculation', 8, 0, 'rel_vel_1', 1, 1, '2025-05-19 23:56:53', NOW(), 1009),

-- Dynamics videos
(5023, 'Principle of Conservation of Linear Momentum || Grade-11 Physics || 100% Sure Question || By CLC Sir', 'https://www.youtube.com/watch?v=jVzlF9ZNOO0', 'youtube', 'In this video, CLC Sir explains one of the most important and exam-focused topics of Grade-11 Physics – the Principle of Conservation of Linear Momentum. This is a 100% sure question for your board and entrance exams.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/jVzlF9ZNOO0/maxresdefault.jpg', '00:18:10', 0, 0, 0, 207, 20, 5, 'Linear momentum conservation principle', 8, 0, 'momentum_1', 1, 1, '2025-05-20 16:16:02', NOW(), 1010),

(5024, 'Dynamics In One Shot | Grand Revision Series | Grade-11 Physics | Full Syllabus Covered By CLC Sir', 'https://www.youtube.com/watch?v=-v5H3X4ajfw', 'youtube', 'Welcome to CLC Physics & Maths Space! In this Grand Revision Series, CLC Sir Presents "Dynamics in One Shot"—a complete and concise revision video that covers 100% of the Grade-11 Physics syllabus on Dynamics.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/-v5H3X4ajfw/sddefault.jpg', '03:02:37', 0, 0, 0, 322, 34, 21, 'Complete dynamics chapter revision', 8, 0, 'dynamics_1', 1, 1, '2025-05-21 05:37:30', NOW(), 1010),

-- Work Energy Power videos
(5025, 'Work, Energy & Power in One Shot || Grand Revision  || Grade-11 Physics NEB/CTEVT || By CLC Sir', 'https://www.youtube.com/watch?v=95MKaTcHg8E', 'youtube', 'Boost your Physics preparation with this power-packed one-shot revision of Work, Energy & Power – a must-watch for all Grade 11 NEB/CTEVT students!', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/95MKaTcHg8E/maxresdefault.jpg', '01:52:15', 0, 0, 0, 210, 17, 3, 'Work energy power complete revision', 8, 0, 'work_energy_1', 1, 1, '2025-05-22 03:33:22', NOW(), 1011),

(5026, 'One Dimensional Elastic Collision: With Proof || Most IMP Derivation || Grade-11 Physics || By CLC', 'https://www.youtube.com/watch?v=gQyU7MLdLxg', 'youtube', 'CLC Sir explains One-Dimensional Elastic Collision with full derivation – a most important concept for Grade-11 NEB/CTEVT Physics. Understand the formulas, steps, and logic clearly for exam success!', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/gQyU7MLdLxg/sddefault.jpg', '00:11:55', 0, 0, 0, 3, 0, 0, 'Elastic collision derivation and proof', 8, 0, 'elastic_col_1', 1, 1, '2025-05-22 12:28:27', NOW(), 1011),

-- Circular Motion videos
(5027, 'Chapter-6 Circular Motion in One Shot || Grand Revision Series || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=1TNVjI4Jckk', 'youtube', 'In this Grand Revision Series, CLC Sir presents a complete one-shot revision of Circular Motion for Grade-11 Physics (NEB/CTEVT). Whether you\'re preparing for exams or just revising, this session covers all key concepts, formulas, and problem-solving strategies in an easy-to-understand manner.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/1TNVjI4Jckk/maxresdefault.jpg', '02:06:49', 0, 0, 0, 5, 0, 0, 'Circular motion complete revision', 8, 0, 'circular_1', 1, 1, '2025-05-23 07:30:41', NOW(), 1012),

(5028, 'Angle of Friction & Angle of Repose are numerically equal || Most Imp question || Grade-11 Physics', 'https://www.youtube.com/watch?v=FMMOtKhuiE0', 'youtube', 'Welcome to CLC Physics & Maths Space! In this important Grade-11 Physics video, we explore the Angle of Friction and Angle of Repose — two crucial concepts in mechanics. Learn why these angles are numerically equal, understand the derivation, physical meaning, and how to tackle related numerical problems easily.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/FMMOtKhuiE0/maxresdefault.jpg', '00:16:49', 0, 0, 0, 157, 14, 8, 'Angle of friction equals angle of repose', 8, 0, 'angle_friction_1', 1, 1, '2025-05-23 13:29:11', NOW(), 1010),

(5029, 'Learn With CLC Sir:  Get A+ in Physics & Mathematics || 100% Guaranteed  || By CLC Sir', 'https://www.youtube.com/watch?v=WaODIr2hQao', 'youtube', 'Are you aiming for an A+ in Physics and Mathematics? You\'re in the right place! In this video, CLC Sir shares powerful tips, tricks, and strategies that are tested, trusted, and 100% effective for scoring top marks in your exams.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/WaODIr2hQao/sddefault.jpg', '00:02:17', 0, 0, 0, 291, 34, 6, 'Study tips for A+ grades in physics', 8, 0, 'study_tips_1', 1, 1, '2025-05-23 17:35:07', NOW(), 1001),

(5030, 'To Prove: linear momentum & Impulse are numerically equal || 100% Sure Question || Grade-11 Physics', 'https://www.youtube.com/watch?v=Mpr6zsxY1Qk', 'youtube', 'Welcome to CLC Physics & Maths Space – Learn With Enjoy with CLC Sir! In this must-watch video, we dive into one of the most important and guaranteed questions in Grade-11 Physics: "Prove that Linear Momentum and Impulse are numerically equal."', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/Mpr6zsxY1Qk/maxresdefault.jpg', '00:08:43', 0, 0, 0, 129, 14, 5, 'Linear momentum impulse equality proof', 8, 0, 'impulse_1', 1, 1, '2025-05-24 11:15:11', NOW(), 1010),

-- Gravitation videos
(5031, 'Gravitation in one shot lecture|| Grade-11 Physics NEB/CTEVT || Entrance Preparation || By CLC Sir', 'https://www.youtube.com/watch?v=rPuAjdlBT8Y', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, we cover the entire chapter of Gravitation in one shot—perfect for Grade 11 NEB/CTEVT students and those preparing for entrance exams like Engineering and Medical.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/rPuAjdlBT8Y/maxresdefault.jpg', '02:50:09', 0, 0, 0, 5, 1, 2, 'Complete gravitation chapter revision', 8, 0, 'gravitation_1', 1, 1, '2025-05-24 17:56:37', NOW(), 1013),

(5032, 'Escape Velocity of Earth: Derivation || Grade-11 Physics || How to Calculate || 11-Physics By CLC', 'https://www.youtube.com/watch?v=IM1m0aQ3AKg', 'youtube', 'Escape Velocity of Earth: Derivation || Grade-11 Physics || How to Calculate || 11-Physics By CLC', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/IM1m0aQ3AKg/maxresdefault.jpg', '00:15:58', 0, 0, 0, 3, 0, 0, 'Earth escape velocity derivation', 8, 0, 'escape_vel_1', 1, 1, '2025-05-25 05:34:42', NOW(), 1013),

(5033, 'Geostationary satellite || Height of geostationary satellite || Grade-11 Physics NEB || By CLC Sir', 'https://www.youtube.com/watch?v=be_hrBmFxiY', 'youtube', 'Geostationary satellite || Height of geostationary satellite || Grade-11 Physics NEB || By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/be_hrBmFxiY/maxresdefault.jpg', '00:10:15', 0, 0, 0, 4, 0, 0, 'Geostationary satellite height calculation', 8, 0, 'geostat_1', 1, 1, '2025-05-25 05:35:19', NOW(), 1013),

(5034, 'Time period of conical pendulum: Horizontal circle || 3 Marks Sure Derivation || By CLC Sir', 'https://www.youtube.com/watch?v=pkNCTMREOKI', 'youtube', 'In this video, CLC Sir presents the full derivation of the time period of a conical pendulum in a clear and systematic way. This is a very important topic for Grade 11 NEB and CTEVT Physics and is often asked for 3 marks in board exams.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/pkNCTMREOKI/sddefault.jpg', '00:17:45', 0, 0, 0, 212, 19, 5, 'Conical pendulum time period derivation', 8, 0, 'conical_1', 1, 1, '2025-05-25 13:28:10', NOW(), 1012),

(5035, 'Circular Motion in One Shot || Grand Revision Series || Grade-11 Physics NEB/CTEB || By CLC Sir', 'https://www.youtube.com/watch?v=a2NNaUvbRrQ', 'youtube', 'Welcome to CLC Physics & Maths Space – your trusted learning companion! In this Grand Revision Series, CLC Sir presents a complete one-shot revision of Circular Motion for Grade-11 Physics (NEB/CTEVT).', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/a2NNaUvbRrQ/sddefault.jpg', '02:06:49', 0, 0, 0, 266, 16, 2, 'Circular motion grand revision', 8, 0, 'circular_2', 1, 1, '2025-05-27 05:30:01', NOW(), 1012),

-- Elasticity videos
(5036, '📚 Elasticity in One Shot: Full Syllabus | Grand Revision | Grade-11 Physics NEB | By CLC Sir 🔍', 'https://www.youtube.com/watch?v=vrxjQg3NQkc', 'youtube', 'Welcome to CLC Physics & Maths Space – your ultimate destination for clear, concise, and complete learning in Physics and Mathematics! In this power-packed one-shot revision session, CLC Sir breaks down the entire chapter of Elasticity from Grade-11 NEB Physics in the simplest and most effective way.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/vrxjQg3NQkc/maxresdefault.jpg', '01:30:36', 0, 0, 0, 11, 1, 0, 'Complete elasticity chapter revision', 8, 0, 'elasticity_1', 1, 1, '2025-05-27 22:54:50', NOW(), 1014),

(5037, 'Derivation of v = rω || Relation between linear & angular velocity || 2 marks Sure || By CLC Sir', 'https://www.youtube.com/watch?v=Cr6vSF0W0e0', 'youtube', 'In this quick and clear explanation, CLC Sir proves the fundamental relation between linear velocity and angular velocity: v = rω — a sure-shot 2 marks question for Grade 11 Physics.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/Cr6vSF0W0e0/sddefault.jpg', '00:05:10', 0, 0, 0, 165, 15, 5, 'Linear angular velocity relation derivation', 8, 0, 'v_omega_1', 1, 1, '2025-05-28 02:39:57', NOW(), 1012),

(5038, 'Chapter-7 Gravitation in one shot || Grade-11 Physics || Grand Revision Series || By CLC Sir', 'https://www.youtube.com/watch?v=JnschjnGFfY', 'youtube', 'Welcome to CLC Physics & Maths Space! In this Grand Revision Series, CLC Sir covers Chapter-7: Gravitation in a clear, concise, and exam-focused way — all in one shot! Perfect for NEB Grade-11 students looking to revise quickly and effectively.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/JnschjnGFfY/sddefault.jpg', '02:50:09', 0, 0, 0, 246, 21, 8, 'Gravitation chapter grand revision', 8, 0, 'gravitation_2', 1, 1, '2025-05-28 03:43:58', NOW(), 1013),

(5039, 'Variation in \'g\' due to height & depth || 100% Fixed Derivation || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=FC0ChwlE2FI', 'youtube', 'Variation in \'g\' due to height & depth || 100% Fixed Derivation || Grade-11 Physics || By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/FC0ChwlE2FI/maxresdefault.jpg', '00:54:06', 0, 0, 0, 137, 14, 3, 'Variation of g with height and depth', 8, 0, 'g_variation_1', 1, 1, '2025-05-28 08:45:13', NOW(), 1013),

(5040, 'Conservation of Mechanical Energy: With Proof || 100% Fixed Question || Grade-11 Physics By CLC Sir', 'https://www.youtube.com/watch?v=W0FUO8b37pw', 'youtube', 'In this video, CLC Sir explains the Law of Conservation of Mechanical Energy with full theory and mathematical proof. This is a 100% fixed question for Grade 11 NEB/CTEVT Physics, and it\'s crucial for exam preparation.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/W0FUO8b37pw/sddefault.jpg', '00:15:42', 0, 0, 0, 187, 21, 8, 'Conservation of mechanical energy proof', 8, 0, 'energy_cons_1', 1, 1, '2025-05-28 12:15:10', NOW(), 1011),

(5041, '📚 Elasticity in One Shot || NEB Exam & Entrance Preparation || Grade-11 Physics NEB | By CLC Sir 🔍', 'https://www.youtube.com/watch?v=B7nhjmFHbaw', 'youtube', 'Welcome to CLC Physics & Maths Space – your ultimate destination for clear, concise, and complete learning in Physics and Mathematics! In this power-packed one-shot revision session, CLC Sir breaks down the entire chapter of Elasticity from Grade-11 NEB Physics in the simplest and most effective way.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/B7nhjmFHbaw/sddefault.jpg', '01:30:36', 0, 0, 0, 194, 19, 11, 'Elasticity exam preparation revision', 8, 0, 'elasticity_2', 1, 1, '2025-05-28 14:48:23', NOW(), 1014),

(5042, 'Total energy of satellite || Additional energy to uplift the satellite || IMP for numerical By CLC', 'https://www.youtube.com/watch?v=JdRKnVAQLk0', 'youtube', 'Total energy of satellite || Additional energy to uplift the satellite || IMP for numerical By CLC', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/JdRKnVAQLk0/maxresdefault.jpg', '00:09:18', 0, 0, 0, 136, 13, 13, 'Satellite total energy calculation', 8, 0, 'satellite_energy_1', 1, 1, '2025-05-28 23:57:35', NOW(), 1013),

(5043, 'Centripetal acceleration & force || 100% Fixed Derivation || Grade-11 Physics NEB/CTEVT | By CLC Sir', 'https://www.youtube.com/watch?v=2BuY5POmNd4', 'youtube', 'In this video, CLC Sir explains the concept and derivation of centripetal acceleration and centripetal force in a clear and simple way, perfect for Grade 11 NEB and CTEVT Physics students.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/2BuY5POmNd4/sddefault.jpg', '00:17:46', 0, 0, 0, 224, 19, 14, 'Centripetal acceleration force derivation', 8, 0, 'centripetal_1', 1, 1, '2025-05-29 04:41:06', NOW(), 1012),

(5044, 'Motion in a vertical circle: Calculation of maximum & minimum tension || critical velocity || By CLC', 'https://www.youtube.com/watch?v=sc3pU_m4Ne4', 'youtube', 'In this conceptual and exam-focused video, CLC Sir explains the Motion in a Vertical Circle in detail. Learn how to calculate maximum and minimum tension in the string and understand the concept of critical velocity needed to complete the circular motion safely.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/sc3pU_m4Ne4/sddefault.jpg', '00:24:40', 0, 0, 0, 151, 16, 3, 'Vertical circle motion tension calculation', 8, 0, 'vertical_circle_1', 1, 1, '2025-05-29 06:37:36', NOW(), 1012),

(5045, 'Work- Energy Theorem: With Proof || 100% Fixed Question || Grade-11 Physics NEB/CTEVT || By CLC Sir', 'https://www.youtube.com/watch?v=Da-LV4dK3tk', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir explains the Work-Energy Theorem with a complete and clear derivation – an important and frequently asked question for Grade 11 NEB/CTEVT exams.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/Da-LV4dK3tk/sddefault.jpg', '00:06:59', 0, 0, 0, 156, 21, 1, 'Work energy theorem proof derivation', 8, 0, 'work_theorem_1', 1, 1, '2025-05-29 11:01:11', NOW(), 1011),

(5046, '🎯 Grade-11 Physics || Most Important Question Collection📚 Chapterwise 100% Sure Topics || By CLC Sir', 'https://www.youtube.com/watch?v=GzHb7BtMi-w', 'youtube', '🎯 Grade-11 Physics || Most Important Question Collection 📚 Chapterwise 100% Sure Topics – Boost Your Exam Confidence! 👨‍🏫 By CLC Sir | CLC Physics & Maths Space', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/GzHb7BtMi-w/sddefault.jpg', '00:41:41', 0, 0, 0, 518, 45, 13, 'Important questions collection chapterwise', 8, 0, 'important_q_1', 1, 1, '2025-05-29 15:01:12', NOW(), 1001),

(5047, 'Newton\'s Law of Gravitation || Grade-11 Physics || Dimensions of Gravitational Constant ||By CLC Sir', 'https://www.youtube.com/watch?v=A1433mt3OZk', 'youtube', 'Newton\'s Law of Gravitation || Grade-11 Physics || Dimensions of Gravitational Constant ||By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/A1433mt3OZk/maxresdefault.jpg', '00:23:41', 0, 0, 0, 52, 6, 3, 'Newton\'s law gravitation and dimensions', 8, 0, 'newton_grav_1', 1, 1, '2025-05-29 23:42:28', NOW(), 1013),

(5048, 'Hooke\'s Law & Stress-Strain Curve || Grade-11 Physics || Easy Explanation By CLC Sir', 'https://www.youtube.com/watch?v=Kh04Fkzg3CA', 'youtube', '📚 Hooke\'s Law & Stress-Strain Curve Explained Like Never Before! 🔥 Grade-11 Physics Made Super Easy by CLC Sir! 🔥', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/Kh04Fkzg3CA/sddefault.jpg', '00:16:38', 0, 0, 0, 64, 10, 3, 'Hooke\'s law stress strain curve explanation', 8, 0, 'hookes_law_1', 1, 1, '2025-05-30 14:36:04', NOW(), 1014),

(5049, 'Stress Versus  Strain Curve for Elastomer Substance || Grade-11 Physics NEB || By CLC Sir', 'https://www.youtube.com/watch?v=IKq5OGQq3E0', 'youtube', '💥 Stress vs Strain Curve for Elastomer — Fully Explained by CLC Sir! 🎯 Grade-11 Physics NEB | Concept + Curve + Real-Life Examples!', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/IKq5OGQq3E0/sddefault.jpg', '00:07:44', 0, 0, 0, 67, 10, 4, 'Elastomer stress strain curve behavior', 8, 0, 'elastomer_1', 1, 1, '2025-05-31 03:03:32', NOW(), 1014),

(5050, 'Circular Motion Terminologies || Some General Terms Related to Circular Motion || Physics By CLC Sir', 'https://www.youtube.com/watch?v=AIcHsR0WWZk', 'youtube', 'Explore important terminologies and general concepts related to Circular Motion in this detailed Grade 11 Physics lesson by CLC Sir. Learn key terms like angular velocity, centripetal force, angular acceleration, and more in a simple and engaging way.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/AIcHsR0WWZk/sddefault.jpg', '00:29:12', 0, 0, 0, 55, 7, 3, 'Circular motion terminology and concepts', 8, 0, 'circular_terms_1', 1, 1, '2025-06-06 12:18:12', NOW(), 1012),

(5051, 'Poisson\'s  Ratio || Lateral & Longitudinal Strain ||Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=IxiQIGg3LCs', 'youtube', 'Poisson\'s Ratio Explained Super Easily! 🔍 Lateral & Longitudinal Strain Made Crystal Clear | Grade-11 Physics NEB', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/IxiQIGg3LCs/sddefault.jpg', '00:08:19', 0, 0, 0, 55, 6, 4, 'Poisson\'s ratio lateral longitudinal strain', 8, 0, 'poisson_1', 1, 1, '2025-06-09 10:32:50', NOW(), 1014),

(5052, 'Centre of Mass (C.M.) & Centre of Gravity (C.G.) | Grade-11 Physics | Ch-7 Gravitation | By CLC Sir', 'https://www.youtube.com/watch?v=D9GbViajST8', 'youtube', 'Centre of Mass (C.M.) & Centre of Gravity (C.G.) | Grade-11 Physics | Ch-7 Gravitation | By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/D9GbViajST8/maxresdefault.jpg', '00:08:14', 0, 0, 0, 25, 3, 2, 'Centre of mass and centre of gravity', 8, 0, 'center_mass_1', 1, 1, '2025-06-11 11:01:52', NOW(), 1013),

(5053, 'Elasticity & Plasticity | Stress & Strain | Super Easy Explanation | Grade-11 Physics | By CLCnSir', 'https://www.youtube.com/watch?v=uu3LsBUItVc', 'youtube', '🧠 Elasticity & Plasticity + Stress & Strain – Super Easy Explanation! 📚 Grade-11 Physics NEB | Most Basic + Most Important Concept!', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/uu3LsBUItVc/sddefault.jpg', '00:13:14', 0, 0, 0, 29, 1, 1, 'Elasticity plasticity stress strain basics', 8, 0, 'elastic_basic_1', 1, 1, '2025-06-12 05:01:23', NOW(), 1014),

(5054, 'Types of Stress & Strain || Most Important Concept for Numericals || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=RvzUiCVWtDI', 'youtube', '💥 Types of Stress & Strain – Master the Core of Elasticity! 📘 Most Important Concept for Numericals | Grade-11 Physics NEB', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/RvzUiCVWtDI/sddefault.jpg', '00:21:05', 0, 0, 0, 33, 4, 1, 'Types of stress and strain for numericals', 8, 0, 'stress_types_1', 1, 1, '2025-06-14 07:43:11', NOW(), 1014),

(5055, 'Workdone by constant & variable force || How to calculate workdone by variable force ? || By CLC Sir', 'https://www.youtube.com/watch?v=jldmCwStA2M', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir explains: What is work done by a constant force, How to calculate work done by a variable force, Graphical and mathematical understanding', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/jldmCwStA2M/sddefault.jpg', '00:34:00', 0, 0, 0, 45, 4, 3, 'Work by constant and variable force', 8, 0, 'work_variable_1', 1, 1, '2025-06-15 04:49:35', NOW(), 1011),

(5056, 'Bending of Cyclist || Circular Motion || Grade-11 Physics || Learn With CLC Sir', 'https://www.youtube.com/watch?v=K6Ftz0mKEV4', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, we explore the concept of bending of a cyclist on a circular track—a fundamental topic in Grade-11 Physics under Circular Motion.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/K6Ftz0mKEV4/sddefault.jpg', '00:08:06', 0, 0, 0, 32, 4, 1, 'Cyclist bending physics in circular motion', 8, 0, 'cyclist_1', 1, 1, '2025-06-16 17:31:42', NOW(), 1012),

(5057, 'Power & Energy || Derivation for K.E. & P.E. || Grade-11 Physics || Easy Explanation By CLC Sir', 'https://www.youtube.com/watch?v=lYnUqjsUxko', 'youtube', 'Power & Energy || Derivation for K.E. & P.E. || Grade-11 Physics || Easy Explanation By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/lYnUqjsUxko/sddefault.jpg', '00:17:30', 0, 0, 0, 48, 3, 2, 'Kinetic and potential energy derivations', 8, 0, 'ke_pe_1', 1, 1, '2025-06-17 15:56:42', NOW(), 1011),

(5058, 'Conservative & Non-Conservative Forces || Elastic & Inelastic Collisions With Examples || By CLC Sir', 'https://www.youtube.com/watch?v=Eewm0cktbVc', 'youtube', 'In this video, CLC Sir explains the difference between Conservative and Non-Conservative Forces, along with Elastic and Inelastic Collisions using clear examples. Perfect for Grade 11 NEB/CTEVT students to strengthen concept and exam preparation.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/Eewm0cktbVc/sddefault.jpg', '00:18:10', 0, 0, 0, 41, 2, 1, 'Conservative forces and collision types', 8, 0, 'conservative_1', 1, 1, '2025-06-24 07:08:09', NOW(), 1011),

(5059, 'Friction & It\'s Type || Laws of Solid Friction || Coefficient of Friction || Grade-11 Physics By CLC', 'https://www.youtube.com/watch?v=FF77iN7G37Q', 'youtube', 'In this video, CLC Sir covers the complete concept of Friction for Grade-11 Physics, including: What is Friction?, Types of Friction – Static, Limiting, and Kinetic, Laws of Solid Friction, Coefficient of Friction and its significance', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/FF77iN7G37Q/maxresdefault.jpg', '00:22:38', 0, 0, 0, 36, 2, 3, 'Friction types laws and coefficient', 8, 0, 'friction_1', 1, 1, '2025-06-25 04:16:04', NOW(), 1010),

(5060, 'Energy stored in a stretched wire || 100% Fixed Derivation || Grade-11 Physics NEB || By CLC Sir', 'https://www.youtube.com/watch?v=sTECkTSLLGs', 'youtube', '⚡ Energy Stored in a Stretched Wire — 100% Fixed Derivation! 🧠 Grade-11 Physics NEB | Super Easy by CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/sTECkTSLLGs/sddefault.jpg', '00:12:23', 0, 0, 0, 92, 6, 1, 'Energy stored in stretched wire derivation', 8, 0, 'wire_energy_1', 1, 1, '2025-06-26 02:23:52', NOW(), 1014),

(5061, 'Modulus of Elasticity & It\'s Types || 100% Fixed for Numericals || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=8hUSfatbtfg', 'youtube', '🎯 Modulus of Elasticity & Its Types – 100% Fixed for Numericals! 📘 Grade-11 Physics NEB | Easy Tricks by CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/8hUSfatbtfg/sddefault.jpg', '00:21:08', 0, 0, 0, 53, 2, 1, 'Modulus of elasticity types and numericals', 8, 0, 'modulus_1', 1, 1, '2025-06-26 13:31:24', NOW(), 1014),

(5062, 'Principle of Moment || Torque & Equilibrium || Torque due to couple || Grade-11 Physics By CLC Sir', 'https://www.youtube.com/watch?v=PDQaz39AEY0', 'youtube', 'Welcome to CLC Physics & Maths Space! In this video, CLC Sir explains one of the most important concepts in Grade-11 Physics – Torque and Equilibrium, including: The Principle of Moments, Torque (Moment of Force) and its calculation, Conditions for Rotational Equilibrium', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/PDQaz39AEY0/maxresdefault.jpg', '00:29:33', 0, 0, 0, 56, 3, 1, 'Torque equilibrium and principle of moments', 8, 0, 'torque_1', 1, 1, '2025-06-27 13:24:34', NOW(), 1014),

(5063, 'Motion of Satellite || Orbital Velocity & Time-period of Satellite || Most IMP Derivation By CLC Sir', 'https://www.youtube.com/watch?v=5PD_qhlu6Mc', 'youtube', 'Motion of Satellite || Orbital Velocity & Time-period of Satellite || Most IMP Derivation By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/5PD_qhlu6Mc/maxresdefault.jpg', '00:19:07', 0, 0, 0, 41, 5, 3, 'Satellite motion orbital velocity derivation', 8, 0, 'satellite_1', 1, 1, '2025-06-29 06:51:30', NOW(), 1013),

(5064, 'Instantaneous Velocity &  Relative Velocity | Speed versus Velocity |  Distance versus Displacement', 'https://www.youtube.com/watch?v=F-vqbLBe_CE', 'youtube', 'Welcome to CLC Physics & Maths Space! In this comprehensive video, CLC Sir covers the most important motion concepts for Grade-11 Physics students. This video will help you build a strong foundation in Kinematics.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/F-vqbLBe_CE/maxresdefault.jpg', '00:45:04', 0, 0, 0, 49, 6, 6, 'Velocity displacement concepts kinematics', 8, 0, 'inst_vel_1', 1, 1, '2025-07-02 16:36:55', NOW(), 1009),

(5065, 'Variation of K.E. with mass || A light body & a heavy body both have same K.E. which one will have', 'https://www.youtube.com/watch?v=cLuJLmOcMX4', 'youtube', 'In this video, CLC Sir explains how Kinetic Energy varies with mass and answers conceptual questions like: "If a light and a heavy body have the same K.E., which has more momentum?" – A must-watch for NEB/CTEVT Grade-11 Physics students!', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/cLuJLmOcMX4/sddefault.jpg', '00:10:34', 0, 0, 0, 46, 5, 4, 'Kinetic energy variation with mass', 8, 0, 'ke_variation_1', 1, 1, '2025-07-03 13:11:19', NOW(), 1011),

(5066, 'Banking of Curved Road || Application of Banking || Bending of Cyclist || Grade-11Physics By CLC Sir', 'https://www.youtube.com/watch?v=3wmTtooXwg8', 'youtube', 'In this important Grade-11 Physics video, CLC Sir explains the concepts of Banking of Curved Roads, its Applications, and Bending of a Cyclist with clear diagrams and real-life examples.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/3wmTtooXwg8/sddefault.jpg', '00:25:36', 0, 0, 0, 39, 2, 1, 'Banking of roads and cyclist bending', 8, 0, 'banking_1', 1, 1, '2025-07-04 23:50:36', NOW(), 1012),

(5067, 'Motion in Lift: Apparent Weight Calculation || Grade-11 Physics || Clear Concept By CLC Sir', 'https://www.youtube.com/watch?v=wDxz4VEpZDw', 'youtube', 'In this conceptual video, we explain the interesting topic of Motion in a Lift (Elevator) and how to calculate the Apparent Weight in different cases of motion — going up, down, and in free fall.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/wDxz4VEpZDw/maxresdefault.jpg', '00:13:00', 0, 0, 0, 54, 2, 3, 'Apparent weight in lift motion', 8, 0, 'lift_motion_1', 1, 1, '2025-07-09 16:02:19', NOW(), 1010),

(5068, 'Variation in \'g\' due to height || Grade-11 Physics NEB || Almost sure derivation || By CLC Sir', 'https://www.youtube.com/watch?v=7huJ3IpNgBg', 'youtube', 'Variation in \'g\' due to height || Grade-11 Physics NEB || Almost sure derivation || By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/7huJ3IpNgBg/maxresdefault.jpg', '00:24:22', 0, 0, 0, 100, 8, 4, 'Variation of g with height derivation', 8, 0, 'g_height_1', 1, 1, '2025-08-04 11:58:17', NOW(), 1013),

(5069, 'Variation in \'g\' due to depth || Chapter-7 Gravity & Gravitation || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=RRbji7JSRjQ', 'youtube', 'Variation in \'g\' due to depth || Chapter-7 Gravity & Gravitation || Grade-11 Physics || By CLC Sir', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/RRbji7JSRjQ/maxresdefault.jpg', '00:19:46', 0, 0, 0, 78, 9, 1, 'Variation of g with depth derivation', 8, 0, 'g_depth_1', 1, 1, '2025-08-11 10:35:13', NOW(), 1013),

(5070, 'Relation between Linear Momentum & Impulse: J=P || Fixed Question || Grade-11 Physics || By CLC Sir', 'https://www.youtube.com/watch?v=ZVxMYf1dgTI', 'youtube', 'In this video, we cover a fixed and most expected question in Grade-11 Physics: "What is the relation between Impulse (J) and Linear Momentum (P)?" We prove the relation J = ΔP with clear explanation and step-by-step derivation.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/ZVxMYf1dgTI/maxresdefault.jpg', '00:23:34', 0, 0, 0, 99, 4, 2, 'Linear momentum impulse relation derivation', 8, 0, 'impulse_mom_1', 1, 1, '2025-08-29 00:37:00', NOW(), 1010),

(5071, 'Free Body Diagram  || How to solve problems related free body diagram || Grade-11 Physics By CLC Sir', 'https://www.youtube.com/watch?v=vAvy9_wOHFk', 'youtube', 'In this video, we dive deep into one of the most essential tools in Physics — the Free Body Diagram (FBD). Understanding how to draw and use FBDs is key to solving mechanics problems in Grade 11 Physics and beyond.', 'CLC Sir', 'Grade 11 Physics', 'intermediate', 'https://i.ytimg.com/vi/vAvy9_wOHFk/maxresdefault.jpg', '00:36:41', 0, 0, 0, 105, 11, 10, 'Free body diagram concepts and problems', 8, 0, 'fbd_1', 1, 1, '2025-08-31 05:50:26', NOW(), 1010);

-- 11. Add course tags relationships (FIXED - avoiding duplicates)
INSERT INTO `course_tags` (`course_id`, `tag_id`) VALUES
(8, 6),  -- grade11 (tag_id 6)
(8, 9),  -- science (tag_id 9) 
(8, 10), -- physics (tag_id 10)
(8, 8),  -- mathematics (tag_id 8) - physics uses math
(8, 36), -- intermediate (tag_id 36)
(8, 37); -- advanced (tag_id 37)

-- ================================================================
-- TRIGGER FUNCTIONS FOR ENROLLMENT MANAGEMENT
-- ================================================================

-- Drop existing enrollment triggers if they exist to avoid conflicts
DROP TRIGGER IF EXISTS `auto_enroll_free_courses_on_user_signup`;
DROP TRIGGER IF EXISTS `update_course_enrollment_count_on_insert`;
DROP TRIGGER IF EXISTS `update_course_enrollment_count_on_delete`;

-- Auto-enrollment trigger for new users in free courses
DELIMITER $$

CREATE TRIGGER `auto_enroll_free_courses_on_user_signup`
AFTER INSERT ON `user`
FOR EACH ROW
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE course_id_var INT;
    
    DECLARE free_courses_cursor CURSOR FOR 
        SELECT id 
        FROM courses 
        WHERE (price - discount) <= 0 
        AND status = 'active' 
        AND approval_status = 'approved'
        AND is_public = 1;
    
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    IF NEW.user_type = 'student' THEN
        OPEN free_courses_cursor;
        
        read_loop: LOOP
            FETCH free_courses_cursor INTO course_id_var;
            
            IF done THEN
                LEAVE read_loop;
            END IF;
            
            INSERT INTO enrollments (
                course_id, user_id, enrolled_at, progress, is_completed,
                payment_status, payment_amount, notes
            ) VALUES (
                course_id_var, NEW.id, NOW(), 0, 0,
                'free', 0.00, CONCAT('Auto-enrolled in free course on signup at ', NOW())
            );
            
        END LOOP;
        
        CLOSE free_courses_cursor;
    END IF;
END$$

DELIMITER ;

-- Enrollment count update triggers
DELIMITER $$

CREATE TRIGGER `update_course_enrollment_count_on_insert`
AFTER INSERT ON `enrollments`
FOR EACH ROW
BEGIN
    DECLARE new_enrollments_count INT DEFAULT 0;
    
    SELECT COUNT(*) INTO new_enrollments_count
    FROM enrollments WHERE course_id = NEW.course_id;
    
    UPDATE courses 
    SET enrollments_count = new_enrollments_count, updated_at = NOW()
    WHERE id = NEW.course_id;
END$$

CREATE TRIGGER `update_course_enrollment_count_on_delete`
AFTER DELETE ON `enrollments`
FOR EACH ROW
BEGIN
    DECLARE new_enrollments_count INT DEFAULT 0;
    
    SELECT COUNT(*) INTO new_enrollments_count
    FROM enrollments WHERE course_id = OLD.course_id;
    
    UPDATE courses 
    SET enrollments_count = new_enrollments_count, updated_at = NOW()
    WHERE id = OLD.course_id;
END$$

DELIMITER ;

-- Fix enrollment counts for existing courses
UPDATE courses c 
SET enrollments_count = (
    SELECT COUNT(*) FROM enrollments e WHERE e.course_id = c.id
), updated_at = NOW();

-- ================================================================
-- End of Complete Grade 11 Physics Course Insert Commands
-- Total: 89 videos with complete hierarchical structure + Trigger Functions
-- ================================================================
