Full scenario : Base query to be filtered : select src.id, src.name, src.sku_type, src.is_deleted, src.status, src.is_service_configured as is_activatable, src.created_at from (SELECT column_0 AS `id`, column_1 AS `name`, column_2 AS `sku_type`, column_3 AS `is_deleted`, column_4 AS `status`, column_5 AS `is_service_configured`, column_6 AS `created_at` FROM (VALUES row(2,'Ask The Expert','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(3,'Virtual Reality Experience','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(4,'Site Demo For Masonry And Plastering','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(5,'Concrete Compressive Strength Test','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(6,'Roof Slab Concreting Assistance','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(7,'Concrete Mix Proportioning','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(8,'Coarse Aggregates Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(9,'Sand Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(10,'Site Demo for Column and Foundation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(11,'Water Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(13,'Vaastu Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(14,'Rainwater Harvesting','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(15,'Anti Termite Treatment','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(16,'Financial Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(17,'Detailed Estimation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(18,'2D Layout','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(19,'3D Elevation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(20,'Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(21,'Advanced Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(22,'Visualization Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(23,'Additional 2D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(25,'Additional 3D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(28,'Night View','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(104,'Furniture Layout 3D','Add-on',0,1,1,' 2022-12-21 10:10:20 '),row(109,'Same Category Package','Bundle',0,1,1,' 2022-12-23 09:01:13 '),row(207,'Print Delivery','Add-on',0,1,1,' 2023-01-18 08:47:37 '),row(222,'Add on test','Add-on',0,1,1,' 2023-01-19 09:57:23 '),row(230,'2000','Add-on',0,1,1,' 2023-01-20 10:41:29 '),row(231,'Test Add On 1','Add-on',0,1,1,' 2023-01-20 10:57:37 '),row(233,'Add on 3D','Add-on',0,1,1,' 2023-01-21 02:01:40 '),row(236,'AddOn21Jan','Add-on',0,1,1,' 2023-01-21 06:02:28 ')) AS t) AS src WHERE src.is_deleted = 0 AND src.status = 1 ORDER BY src.created_at desc; 1/ Full list without LIMIT (= base query) mysql> select src.id, src.name, src.sku_type, src.is_deleted, src.status, src.is_service_configured as is_activatable, src.created_at from -> (SELECT column_0 AS `id`, column_1 AS `name`, column_2 AS `sku_type`, column_3 AS `is_deleted`, column_4 AS `status`, column_5 AS `is_service_configured`, column_6 AS `created_at` FROM (VALUES row(2,'Ask The Expert','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(3,'Virtual Reality Experience','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(4,'Site Demo For Masonry And Plastering','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(5,'Concrete Compressive Strength Test','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(6,'Roof Slab Concreting Assistance','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(7,'Concrete Mix Proportioning','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(8,'Coarse Aggregates Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(9,'Sand Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(10,'Site Demo for Column and Foundation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(11,'Water Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(13,'Vaastu Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(14,'Rainwater Harvesting','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(15,'Anti Termite Treatment','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(16,'Financial Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(17,'Detailed Estimation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(18,'2D Layout','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(19,'3D Elevation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(20,'Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(21,'Advanced Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(22,'Visualization Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(23,'Additional 2D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(25,'Additional 3D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(28,'Night View','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(104,'Furniture Layout 3D','Add-on',0,1,1,' 2022-12-21 10:10:20 '),row(109,'Same Category Package','Bundle',0,1,1,' 2022-12-23 09:01:13 '),row(207,'Print Delivery','Add-on',0,1,1,' 2023-01-18 08:47:37 '),row(222,'Add on test','Add-on',0,1,1,' 2023-01-19 09:57:23 '),row(230,'2000','Add-on',0,1,1,' 2023-01-20 10:41:29 '),row(231,'Test Add On 1','Add-on',0,1,1,' 2023-01-20 10:57:37 '),row(233,'Add on 3D','Add-on',0,1,1,' 2023-01-21 02:01:40 '),row(236,'AddOn21Jan','Add-on',0,1,1,' 2023-01-21 06:02:28 ')) AS t) AS src -> WHERE src.is_deleted = 0 AND src.status = 1 ORDER BY src.created_at desc; +-----+--------------------------------------+----------+------------+--------+----------------+-----------------------+ | id | name | sku_type | is_deleted | status | is_activatable | created_at | +-----+--------------------------------------+----------+------------+--------+----------------+-----------------------+ | 236 | AddOn21Jan | Add-on | 0 | 1 | 1 | 2023-01-21 06:02:28 | | 233 | Add on 3D | Add-on | 0 | 1 | 1 | 2023-01-21 02:01:40 | | 231 | Test Add On 1 | Add-on | 0 | 1 | 1 | 2023-01-20 10:57:37 | | 230 | 2000 | Add-on | 0 | 1 | 1 | 2023-01-20 10:41:29 | | 222 | Add on test | Add-on | 0 | 1 | 1 | 2023-01-19 09:57:23 | | 207 | Print Delivery | Add-on | 0 | 1 | 1 | 2023-01-18 08:47:37 | | 109 | Same Category Package | Bundle | 0 | 1 | 1 | 2022-12-23 09:01:13 | | 104 | Furniture Layout 3D | Add-on | 0 | 1 | 1 | 2022-12-21 10:10:20 | | 18 | 2D Layout | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 28 | Night View | Add-on | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 25 | Additional 3D design Option | Add-on | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 23 | Additional 2D design Option | Add-on | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 22 | Visualization Package | Bundle | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 21 | Advanced Concept Design Package | Bundle | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 20 | Concept Design Package | Bundle | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 19 | 3D Elevation | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 2 | Ask The Expert | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 17 | Detailed Estimation | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 16 | Financial Service | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 15 | Anti Termite Treatment | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 14 | Rainwater Harvesting | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 13 | Vaastu Service | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 11 | Water Quality Check | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 10 | Site Demo for Column and Foundation | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 9 | Sand Quality Check | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 8 | Coarse Aggregates Quality Check | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 7 | Concrete Mix Proportioning | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 6 | Roof Slab Concreting Assistance | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 5 | Concrete Compressive Strength Test | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 4 | Site Demo For Masonry And Plastering | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 3 | Virtual Reality Experience | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | +-----+--------------------------------------+----------+------------+--------+----------------+-----------------------+ 31 rows in set (0.00 sec) 2/ Exact same list filtered 0,10 = base query + limit 10 offset 0 mysql> select src.id, src.name, src.sku_type, src.is_deleted, src.status, src.is_service_configured as is_activatable, src.created_at from -> (SELECT column_0 AS `id`, column_1 AS `name`, column_2 AS `sku_type`, column_3 AS `is_deleted`, column_4 AS `status`, column_5 AS `is_service_configured`, column_6 AS `created_at` FROM (VALUES row(2,'Ask The Expert','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(3,'Virtual Reality Experience','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(4,'Site Demo For Masonry And Plastering','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(5,'Concrete Compressive Strength Test','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(6,'Roof Slab Concreting Assistance','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(7,'Concrete Mix Proportioning','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(8,'Coarse Aggregates Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(9,'Sand Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(10,'Site Demo for Column and Foundation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(11,'Water Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(13,'Vaastu Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(14,'Rainwater Harvesting','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(15,'Anti Termite Treatment','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(16,'Financial Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(17,'Detailed Estimation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(18,'2D Layout','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(19,'3D Elevation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(20,'Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(21,'Advanced Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(22,'Visualization Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(23,'Additional 2D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(25,'Additional 3D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(28,'Night View','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(104,'Furniture Layout 3D','Add-on',0,1,1,' 2022-12-21 10:10:20 '),row(109,'Same Category Package','Bundle',0,1,1,' 2022-12-23 09:01:13 '),row(207,'Print Delivery','Add-on',0,1,1,' 2023-01-18 08:47:37 '),row(222,'Add on test','Add-on',0,1,1,' 2023-01-19 09:57:23 '),row(230,'2000','Add-on',0,1,1,' 2023-01-20 10:41:29 '),row(231,'Test Add On 1','Add-on',0,1,1,' 2023-01-20 10:57:37 '),row(233,'Add on 3D','Add-on',0,1,1,' 2023-01-21 02:01:40 '),row(236,'AddOn21Jan','Add-on',0,1,1,' 2023-01-21 06:02:28 ')) AS t) AS src -> WHERE src.is_deleted = 0 AND src.status = 1 ORDER BY src.created_at desc limit 10 offset 0; +-----+---------------------------------+----------+------------+--------+----------------+-----------------------+ | id | name | sku_type | is_deleted | status | is_activatable | created_at | +-----+---------------------------------+----------+------------+--------+----------------+-----------------------+ | 236 | AddOn21Jan | Add-on | 0 | 1 | 1 | 2023-01-21 06:02:28 | | 233 | Add on 3D | Add-on | 0 | 1 | 1 | 2023-01-21 02:01:40 | | 231 | Test Add On 1 | Add-on | 0 | 1 | 1 | 2023-01-20 10:57:37 | | 230 | 2000 | Add-on | 0 | 1 | 1 | 2023-01-20 10:41:29 | | 222 | Add on test | Add-on | 0 | 1 | 1 | 2023-01-19 09:57:23 | | 207 | Print Delivery | Add-on | 0 | 1 | 1 | 2023-01-18 08:47:37 | | 109 | Same Category Package | Bundle | 0 | 1 | 1 | 2022-12-23 09:01:13 | | 104 | Furniture Layout 3D | Add-on | 0 | 1 | 1 | 2022-12-21 10:10:20 | | 3 | Virtual Reality Experience | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 6 | Roof Slab Concreting Assistance | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | +-----+---------------------------------+----------+------------+--------+----------------+-----------------------+ 10 rows in set (0.00 sec) Expected : Raw ids 18 and 28 replaced by 3, 6 3/ Exact same list filtered 10,10 = base query + limit 10 offset 10 mysql> select src.id, src.name, src.sku_type, src.is_deleted, src.status, src.is_service_configured as is_activatable, src.created_at from -> (SELECT column_0 AS `id`, column_1 AS `name`, column_2 AS `sku_type`, column_3 AS `is_deleted`, column_4 AS `status`, column_5 AS `is_service_configured`, column_6 AS `created_at` FROM (VALUES row(2,'Ask The Expert','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(3,'Virtual Reality Experience','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(4,'Site Demo For Masonry And Plastering','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(5,'Concrete Compressive Strength Test','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(6,'Roof Slab Concreting Assistance','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(7,'Concrete Mix Proportioning','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(8,'Coarse Aggregates Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(9,'Sand Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(10,'Site Demo for Column and Foundation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(11,'Water Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(13,'Vaastu Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(14,'Rainwater Harvesting','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(15,'Anti Termite Treatment','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(16,'Financial Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(17,'Detailed Estimation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(18,'2D Layout','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(19,'3D Elevation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(20,'Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(21,'Advanced Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(22,'Visualization Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(23,'Additional 2D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(25,'Additional 3D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(28,'Night View','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(104,'Furniture Layout 3D','Add-on',0,1,1,' 2022-12-21 10:10:20 '),row(109,'Same Category Package','Bundle',0,1,1,' 2022-12-23 09:01:13 '),row(207,'Print Delivery','Add-on',0,1,1,' 2023-01-18 08:47:37 '),row(222,'Add on test','Add-on',0,1,1,' 2023-01-19 09:57:23 '),row(230,'2000','Add-on',0,1,1,' 2023-01-20 10:41:29 '),row(231,'Test Add On 1','Add-on',0,1,1,' 2023-01-20 10:57:37 '),row(233,'Add on 3D','Add-on',0,1,1,' 2023-01-21 02:01:40 '),row(236,'AddOn21Jan','Add-on',0,1,1,' 2023-01-21 06:02:28 ')) AS t) AS src -> WHERE src.is_deleted = 0 AND src.status = 1 ORDER BY src.created_at desc limit 10 OFFSET 10; +----+---------------------------------+----------+------------+--------+----------------+-----------------------+ | id | name | sku_type | is_deleted | status | is_activatable | created_at | +----+---------------------------------+----------+------------+--------+----------------+-----------------------+ | 25 | Additional 3D design Option | Add-on | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 23 | Additional 2D design Option | Add-on | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 22 | Visualization Package | Bundle | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 21 | Advanced Concept Design Package | Bundle | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 20 | Concept Design Package | Bundle | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 19 | 3D Elevation | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 2 | Ask The Expert | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 17 | Detailed Estimation | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 16 | Financial Service | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 15 | Anti Termite Treatment | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | +----+---------------------------------+----------+------------+--------+----------------+-----------------------+ 10 rows in set (0.00 sec) 4/ Exact same list filtered 20,10 = base query + limit 10 offset 20 mysql> select src.id, src.name, src.sku_type, src.is_deleted, src.status, src.is_service_configured as is_activatable, src.created_at from -> (SELECT column_0 AS `id`, column_1 AS `name`, column_2 AS `sku_type`, column_3 AS `is_deleted`, column_4 AS `status`, column_5 AS `is_service_configured`, column_6 AS `created_at` FROM (VALUES row(2,'Ask The Expert','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(3,'Virtual Reality Experience','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(4,'Site Demo For Masonry And Plastering','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(5,'Concrete Compressive Strength Test','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(6,'Roof Slab Concreting Assistance','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(7,'Concrete Mix Proportioning','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(8,'Coarse Aggregates Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(9,'Sand Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(10,'Site Demo for Column and Foundation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(11,'Water Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(13,'Vaastu Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(14,'Rainwater Harvesting','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(15,'Anti Termite Treatment','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(16,'Financial Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(17,'Detailed Estimation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(18,'2D Layout','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(19,'3D Elevation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(20,'Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(21,'Advanced Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(22,'Visualization Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(23,'Additional 2D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(25,'Additional 3D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(28,'Night View','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(104,'Furniture Layout 3D','Add-on',0,1,1,' 2022-12-21 10:10:20 '),row(109,'Same Category Package','Bundle',0,1,1,' 2022-12-23 09:01:13 '),row(207,'Print Delivery','Add-on',0,1,1,' 2023-01-18 08:47:37 '),row(222,'Add on test','Add-on',0,1,1,' 2023-01-19 09:57:23 '),row(230,'2000','Add-on',0,1,1,' 2023-01-20 10:41:29 '),row(231,'Test Add On 1','Add-on',0,1,1,' 2023-01-20 10:57:37 '),row(233,'Add on 3D','Add-on',0,1,1,' 2023-01-21 02:01:40 '),row(236,'AddOn21Jan','Add-on',0,1,1,' 2023-01-21 06:02:28 ')) AS t) AS src -> WHERE src.is_deleted = 0 AND src.status = 1 ORDER BY src.created_at desc limit 10 OFFSET 20; +----+--------------------------------------+----------+------------+--------+----------------+-----------------------+ | id | name | sku_type | is_deleted | status | is_activatable | created_at | +----+--------------------------------------+----------+------------+--------+----------------+-----------------------+ | 14 | Rainwater Harvesting | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 13 | Vaastu Service | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 11 | Water Quality Check | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 10 | Site Demo for Column and Foundation | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 9 | Sand Quality Check | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 8 | Coarse Aggregates Quality Check | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 7 | Concrete Mix Proportioning | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 6 | Roof Slab Concreting Assistance | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 5 | Concrete Compressive Strength Test | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | | 4 | Site Demo For Masonry And Plastering | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | +----+--------------------------------------+----------+------------+--------+----------------+-----------------------+ 10 rows in set (0.01 sec) 5/ Exact same list filtered 30,10 = base query + limit 10 offset 30 mysql> select src.id, src.name, src.sku_type, src.is_deleted, src.status, src.is_service_configured as is_activatable, src.created_at from (SELECT column_0 AS `id`, column_1 AS `name`, column_2 AS `sku_type`, column_3 AS `is_deleted`, column_4 AS `status`, column_5 AS `is_service_configured`, column_6 AS `created_at` FROM (VALUES row(2,'Ask The Expert','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(3,'Virtual Reality Experience','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(4,'Site Demo For Masonry And Plastering','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(5,'Concrete Compressive Strength Test','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(6,'Roof Slab Concreting Assistance','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(7,'Concrete Mix Proportioning','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(8,'Coarse Aggregates Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(9,'Sand Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(10,'Site Demo for Column and Foundation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(11,'Water Quality Check','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(13,'Vaastu Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(14,'Rainwater Harvesting','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(15,'Anti Termite Treatment','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(16,'Financial Service','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(17,'Detailed Estimation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(18,'2D Layout','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(19,'3D Elevation','Basic',0,1,1,' 2022-10-26 06:25:06 '),row(20,'Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(21,'Advanced Concept Design Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(22,'Visualization Package','Bundle',0,1,1,' 2022-10-26 06:25:06 '),row(23,'Additional 2D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(25,'Additional 3D design Option','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(28,'Night View','Add-on',0,1,1,' 2022-10-26 06:25:06 '),row(104,'Furniture Layout 3D','Add-on',0,1,1,' 2022-12-21 10:10:20 '),row(109,'Same Category Package','Bundle',0,1,1,' 2022-12-23 09:01:13 '),row(207,'Print Delivery','Add-on',0,1,1,' 2023-01-18 08:47:37 '),row(222,'Add on test','Add-on',0,1,1,' 2023-01-19 09:57:23 '),row(230,'2000','Add-on',0,1,1,' 2023-01-20 10:41:29 '),row(231,'Test Add On 1','Add-on',0,1,1,' 2023-01-20 10:57:37 '),row(233,'Add on 3D','Add-on',0,1,1,' 2023-01-21 02:01:40 '),row(236,'AddOn21Jan','Add-on',0,1,1,' 2023-01-21 06:02:28 ')) AS t) AS src WHERE src.is_deleted = 0 AND src.status = 1 ORDER BY src.created_at desc limit 10 OFFSET 30; +----+----------------------------+----------+------------+--------+----------------+-----------------------+ | id | name | sku_type | is_deleted | status | is_activatable | created_at | +----+----------------------------+----------+------------+--------+----------------+-----------------------+ | 3 | Virtual Reality Experience | Basic | 0 | 1 | 1 | 2022-10-26 06:25:06 | +----+----------------------------+----------+------------+--------+----------------+-----------------------+ 1 row in set (0.00 sec)