Efficient pagination using OFFSET-FETCH on SQL Server.
| ID | Name | Category | Price | Stock | Rating | Reviews | SKU |
|---|---|---|---|---|---|---|---|
| 22360 | Bulk Product d7a48974 | Electronics | $806.94 | 417 | ★ 3.4 | 13 | BULK-311e2c03 |
| 22361 | Bulk Product eba07d7c | Home & Garden | $715.50 | 373 | ★ 1.9 | 26 | BULK-e22a775a |
| 22362 | Bulk Product f7d292b7 | Clothing | $280.41 | 297 | ★ 1.3 | 87 | BULK-a669fb1e |
| 22363 | Bulk Product 8104b873 | Sports & Outdoors | $964.17 | 466 | ★ 4.2 | 15 | BULK-5e8b2572 |
| 22364 | Bulk Product 2c4dc6d8 | Sports & Outdoors | $900.69 | 183 | ★ 4.6 | 88 | BULK-1cff2d26 |
| 22365 | Bulk Product b084bd5e | Toys & Games | $770.50 | 454 | ★ 1.8 | 24 | BULK-25c11e10 |
| 22366 | Bulk Product b60fa777 | Home & Garden | $179.05 | 93 | ★ 0.2 | 6 | BULK-2e816323 |
| 22367 | Bulk Product e75be1e5 | Toys & Games | $247.69 | 377 | ★ 4.7 | 95 | BULK-18c4e8b8 |
| 22368 | Bulk Product 3f5d7481 | Electronics | $114.64 | 264 | ★ 4.0 | 15 | BULK-a60c7fe9 |
| 22369 | Bulk Product ced90a5d | Clothing | $498.92 | 467 | ★ 1.1 | 87 | BULK-dbe2fd74 |
| 22370 | Bulk Product 3f11f047 | Toys & Games | $752.51 | 305 | ★ 0.9 | 47 | BULK-062a591f |
| 22371 | Bulk Product decc3821 | Home & Garden | $368.53 | 463 | ★ 2.5 | 39 | BULK-9e28dc3e |
| 22372 | Bulk Product d504c48f | Sports & Outdoors | $589.88 | 477 | ★ 0.2 | 11 | BULK-39f8f62e |
| 22373 | Bulk Product aa0b361e | Home & Garden | $257.48 | 220 | ★ 1.6 | 65 | BULK-71f72f86 |
| 22374 | Bulk Product 9560d401 | Home & Garden | $321.38 | 59 | ★ 2.9 | 19 | BULK-a1a33785 |
| 22375 | Bulk Product d6492bef | Sports & Outdoors | $707.71 | 318 | ★ 3.3 | 83 | BULK-13f30296 |
| 22376 | Bulk Product e697f2fd | Sports & Outdoors | $785.27 | 400 | ★ 4.5 | 68 | BULK-ad7435ff |
| 22377 | Bulk Product 4367a8ef | Toys & Games | $714.59 | 23 | ★ 1.3 | 58 | BULK-49b45f8f |
| 22378 | Bulk Product 0efd998e | Books | $647.50 | 426 | ★ 0.4 | 91 | BULK-7140bfbc |
| 22379 | Bulk Product 7f9128db | Home & Garden | $940.66 | 33 | ★ 1.0 | 54 | BULK-a4ac4dda |
| 22380 | Bulk Product c55f514f | Clothing | $689.33 | 22 | ★ 4.2 | 13 | BULK-93a39511 |
| 22381 | Bulk Product 0362916c | Toys & Games | $55.83 | 87 | ★ 3.9 | 28 | BULK-db346882 |
| 22382 | Bulk Product a8d84bb8 | Home & Garden | $897.25 | 347 | ★ 4.4 | 6 | BULK-00180108 |
| 22383 | Bulk Product 3d21c610 | Home & Garden | $166.04 | 155 | ★ 2.3 | 31 | BULK-eb733d3f |
| 22384 | Bulk Product 15e848e5 | Sports & Outdoors | $884.11 | 117 | ★ 2.3 | 40 | BULK-e107c991 |
| 22385 | Bulk Product 64671ebb | Home & Garden | $784.72 | 165 | ★ 1.7 | 32 | BULK-66c4cb67 |
| 22386 | Bulk Product e7ea2a20 | Home & Garden | $825.48 | 442 | ★ 1.7 | 13 | BULK-3d725b5c |
| 22387 | Bulk Product 676d7bfb | Sports & Outdoors | $290.28 | 144 | ★ 2.4 | 29 | BULK-77fd1945 |
| 22388 | Bulk Product 7b693645 | Books | $758.35 | 29 | ★ 0.9 | 12 | BULK-3da2a527 |
| 22389 | Bulk Product 02ac81e6 | Sports & Outdoors | $900.17 | 288 | ★ 0.6 | 57 | BULK-70b51967 |
| 22390 | Bulk Product cb0b5386 | Sports & Outdoors | $734.34 | 149 | ★ 5.0 | 19 | BULK-08fa0ee4 |
| 22391 | Bulk Product aeff88b2 | Home & Garden | $535.21 | 315 | ★ 2.7 | 88 | BULK-609730b6 |
| 22392 | Bulk Product 6750bbc1 | Electronics | $791.54 | 344 | ★ 0.2 | 85 | BULK-76b7898d |
| 22393 | Bulk Product c4abcc25 | Toys & Games | $834.16 | 44 | ★ 1.1 | 54 | BULK-074c73d0 |
| 22394 | Bulk Product d40abd27 | Clothing | $163.76 | 68 | ★ 2.0 | 24 | BULK-a7ad3c88 |
| 22395 | Bulk Product 5115310d | Sports & Outdoors | $708.19 | 17 | ★ 1.0 | 95 | BULK-21610bda |
| 22396 | Bulk Product 4176b518 | Books | $477.91 | 174 | ★ 1.9 | 84 | BULK-beb1ae58 |
| 22397 | Bulk Product 956711bb | Electronics | $217.26 | 176 | ★ 2.9 | 93 | BULK-2e064554 |
| 22398 | Bulk Product f66caff0 | Sports & Outdoors | $187.01 | 32 | ★ 4.2 | 8 | BULK-56905712 |
| 22399 | Bulk Product f1db03a0 | Electronics | $685.40 | 460 | ★ 2.3 | 18 | BULK-98208ab6 |
| 22400 | Bulk Product e4385f70 | Books | $534.48 | 215 | ★ 1.1 | 98 | BULK-3a9c3273 |
| 22401 | Bulk Product 3cb876ed | Electronics | $841.49 | 183 | ★ 1.1 | 59 | BULK-02119e6e |
| 22402 | Bulk Product 81a9de46 | Books | $52.26 | 101 | ★ 4.6 | 21 | BULK-2ccd9ece |
| 22403 | Bulk Product 9bacf477 | Electronics | $623.57 | 445 | ★ 0.6 | 22 | BULK-12832faa |
| 22404 | Bulk Product b4bac8b0 | Home & Garden | $903.33 | 263 | ★ 3.3 | 25 | BULK-91e602cb |
| 22405 | Bulk Product ac70a787 | Sports & Outdoors | $34.13 | 179 | ★ 1.1 | 18 | BULK-a131763e |
| 22406 | Bulk Product 9d944e47 | Sports & Outdoors | $615.78 | 455 | ★ 2.0 | 47 | BULK-183df85b |
| 22407 | Bulk Product ab7f4bd0 | Sports & Outdoors | $206.82 | 18 | ★ 2.8 | 31 | BULK-3b3e2c5f |
| 22408 | Bulk Product 8f82adca | Home & Garden | $88.19 | 400 | ★ 5.0 | 64 | BULK-46d44fa4 |
| 22409 | Bulk Product 75047d89 | Books | $48.08 | 67 | ★ 1.1 | 49 | BULK-0b3d66e5 |
| 22410 | Bulk Product 8abc793a | Toys & Games | $869.63 | 294 | ★ 1.3 | 69 | BULK-5c8c4123 |
| 22411 | Bulk Product dc6474e6 | Clothing | $129.52 | 340 | ★ 3.0 | 34 | BULK-c4632216 |
| 22412 | Bulk Product ae1db6a6 | Toys & Games | $773.58 | 269 | ★ 0.8 | 82 | BULK-783d01b4 |
| 22413 | Bulk Product 725bdfb8 | Toys & Games | $423.56 | 129 | ★ 3.4 | 31 | BULK-8f7957b4 |
| 22414 | Bulk Product 6bd89398 | Electronics | $997.26 | 343 | ★ 4.2 | 79 | BULK-a4ff986e |
| 22415 | Bulk Product aabebba9 | Toys & Games | $682.14 | 495 | ★ 2.8 | 47 | BULK-e669d3b0 |
| 22416 | Bulk Product 6313b5b0 | Home & Garden | $90.76 | 310 | ★ 0.1 | 32 | BULK-7dc866dc |
| 22417 | Bulk Product 951a7db0 | Toys & Games | $950.62 | 259 | ★ 1.6 | 52 | BULK-72633642 |
| 22418 | Bulk Product 41bcfd6b | Clothing | $268.13 | 332 | ★ 4.7 | 67 | BULK-f40a7efd |
| 22419 | Bulk Product ff3f1565 | Sports & Outdoors | $588.47 | 408 | ★ 2.1 | 92 | BULK-f1a5219d |
| 22420 | Bulk Product 63d9ba56 | Sports & Outdoors | $914.91 | 227 | ★ 2.3 | 4 | BULK-270f074a |
| 22421 | Bulk Product cfae2024 | Toys & Games | $17.66 | 72 | ★ 3.9 | 70 | BULK-df18810f |
| 22422 | Bulk Product 73f75b0a | Sports & Outdoors | $422.33 | 284 | ★ 4.5 | 72 | BULK-28fa22fe |
| 22423 | Bulk Product d138afa5 | Electronics | $58.33 | 249 | ★ 4.1 | 50 | BULK-f6e8c909 |
| 22424 | Bulk Product 00651363 | Books | $658.68 | 319 | ★ 0.7 | 16 | BULK-f479c442 |
| 22425 | Bulk Product a43f80d3 | Books | $576.61 | 246 | ★ 3.6 | 85 | BULK-b978d985 |
| 22426 | Bulk Product 43a9af24 | Electronics | $279.30 | 432 | ★ 4.2 | 15 | BULK-86454401 |
| 22427 | Bulk Product 43a3a5ee | Electronics | $951.47 | 176 | ★ 2.3 | 64 | BULK-4eaaea17 |
| 22428 | Bulk Product ad9d81bd | Sports & Outdoors | $881.84 | 146 | ★ 0.1 | 64 | BULK-53335e4e |
| 22429 | Bulk Product 96035624 | Clothing | $213.72 | 387 | ★ 1.8 | 62 | BULK-47a94a17 |
| 22430 | Bulk Product 91a3fe26 | Electronics | $275.52 | 67 | ★ 2.8 | 21 | BULK-7f1e87d2 |
| 22431 | Bulk Product cb314e2d | Books | $895.58 | 383 | ★ 1.0 | 7 | BULK-2f555f7f |
| 22432 | Bulk Product 45844c4a | Sports & Outdoors | $406.35 | 187 | ★ 1.9 | 52 | BULK-5b215fec |
| 22433 | Bulk Product d4c01747 | Clothing | $758.15 | 174 | ★ 2.4 | 45 | BULK-325c5b30 |
| 22434 | Bulk Product e4fd8a1d | Home & Garden | $176.30 | 140 | ★ 2.8 | 15 | BULK-4e16ad49 |
| 22435 | Bulk Product 6e3e15c3 | Books | $415.15 | 92 | ★ 1.3 | 75 | BULK-a243ac49 |
| 22436 | Bulk Product da5166e9 | Clothing | $799.59 | 310 | ★ 1.2 | 20 | BULK-2ecd6b20 |
| 22437 | Bulk Product 81be08c7 | Clothing | $66.62 | 1 | ★ 4.4 | 56 | BULK-cb1c0fdd |
| 22438 | Bulk Product 92effe12 | Sports & Outdoors | $870.41 | 344 | ★ 3.4 | 91 | BULK-01c88a96 |
| 22439 | Bulk Product 6062191e | Clothing | $337.38 | 200 | ★ 2.9 | 90 | BULK-8c15be3a |
| 22440 | Bulk Product f62e4db2 | Clothing | $312.54 | 204 | ★ 4.9 | 96 | BULK-d38fbbb6 |
| 22441 | Bulk Product e9182f2b | Toys & Games | $285.70 | 494 | ★ 0.7 | 77 | BULK-035c21da |
| 22442 | Bulk Product 39df0f36 | Electronics | $205.84 | 277 | ★ 3.5 | 97 | BULK-9d511167 |
| 22443 | Bulk Product 813cc140 | Clothing | $140.72 | 481 | ★ 4.6 | 43 | BULK-d0b0908d |
| 22444 | Bulk Product 9d5a4ae6 | Toys & Games | $560.64 | 210 | ★ 3.0 | 85 | BULK-cdb82370 |
| 22445 | Bulk Product 6a016373 | Home & Garden | $733.38 | 116 | ★ 1.0 | 5 | BULK-1d932370 |
| 22446 | Bulk Product 686b84f4 | Toys & Games | $660.29 | 406 | ★ 1.7 | 26 | BULK-6054d924 |
| 22447 | Bulk Product 84c7ce35 | Books | $712.00 | 372 | ★ 4.6 | 31 | BULK-51199d5d |
| 22448 | Bulk Product 68c935a1 | Home & Garden | $19.18 | 270 | ★ 1.5 | 19 | BULK-daec03c8 |
| 22449 | Bulk Product 00e698cb | Clothing | $163.63 | 50 | ★ 0.4 | 99 | BULK-b692200b |
| 22450 | Bulk Product 1b1f86ec | Books | $901.83 | 369 | ★ 0.6 | 86 | BULK-de902dcd |
| 22451 | Bulk Product e1adc00f | Electronics | $643.80 | 394 | ★ 3.4 | 73 | BULK-b1cca378 |
| 22452 | Bulk Product e9f2f602 | Home & Garden | $540.24 | 279 | ★ 1.3 | 32 | BULK-43bfa2e5 |
| 22453 | Bulk Product d29b5b27 | Clothing | $199.28 | 180 | ★ 0.9 | 69 | BULK-eb4c0b3d |
| 22454 | Bulk Product 04bc7b33 | Books | $1,002.93 | 419 | ★ 4.3 | 97 | BULK-42eb249d |
| 22455 | Bulk Product deba7fee | Electronics | $604.25 | 473 | ★ 2.3 | 71 | BULK-6fb48c33 |
| 22456 | Bulk Product 21821dd6 | Clothing | $653.17 | 226 | ★ 0.7 | 78 | BULK-f4b8cdda |
| 22457 | Bulk Product 5f63f4d5 | Sports & Outdoors | $549.05 | 14 | ★ 2.5 | 98 | BULK-1d81725f |
| 22458 | Bulk Product 2f39e399 | Home & Garden | $189.20 | 352 | ★ 2.9 | 16 | BULK-8388f09a |
| 22459 | Bulk Product 51615ce1 | Sports & Outdoors | $72.26 | 383 | ★ 1.2 | 66 | BULK-eb6a0a2d |
| 22460 | Bulk Product 0a944862 | Toys & Games | $157.26 | 169 | ★ 2.2 | 70 | BULK-8913a3e2 |
| 22461 | Bulk Product 661e6c6b | Books | $428.63 | 483 | ★ 1.1 | 91 | BULK-e63d0d99 |
| 22462 | Bulk Product a732a624 | Electronics | $181.64 | 475 | ★ 4.9 | 55 | BULK-6500794c |
| 22463 | Bulk Product cf650fbb | Clothing | $93.56 | 50 | ★ 0.5 | 12 | BULK-ed92327c |
| 22464 | Bulk Product cd3c845c | Books | $169.94 | 143 | ★ 0.3 | 91 | BULK-46b78746 |
| 22465 | Bulk Product fe864817 | Clothing | $246.23 | 329 | ★ 0.6 | 98 | BULK-c9bb98c0 |
| 22466 | Bulk Product a3b15760 | Electronics | $253.59 | 457 | ★ 1.6 | 36 | BULK-2f1b1792 |
| 22467 | Bulk Product c8ff6d75 | Clothing | $834.73 | 8 | ★ 0.0 | 92 | BULK-5b1ecd11 |
| 22468 | Bulk Product e670ee2f | Sports & Outdoors | $992.08 | 426 | ★ 0.5 | 63 | BULK-3dbd93bc |
| 22469 | Bulk Product 8f42b5f5 | Sports & Outdoors | $102.46 | 199 | ★ 0.4 | 44 | BULK-f1005505 |
| 22470 | Bulk Product fcc147c2 | Sports & Outdoors | $351.27 | 91 | ★ 4.3 | 33 | BULK-6d6e00db |
| 22471 | Bulk Product d8dbec45 | Toys & Games | $325.83 | 467 | ★ 0.6 | 16 | BULK-6d9d1609 |
| 22472 | Bulk Product 14ffc4c2 | Books | $968.28 | 201 | ★ 1.3 | 66 | BULK-b7a49469 |
| 22473 | Bulk Product 6195c0fa | Sports & Outdoors | $858.96 | 418 | ★ 4.3 | 75 | BULK-8f8ecbbe |
| 22474 | Bulk Product cab71947 | Books | $569.68 | 372 | ★ 2.2 | 50 | BULK-8ff4186a |
| 22475 | Bulk Product 9a9bbb87 | Books | $338.03 | 427 | ★ 2.4 | 15 | BULK-4b5938e4 |
| 22476 | Bulk Product 12ed070a | Sports & Outdoors | $79.14 | 165 | ★ 3.1 | 14 | BULK-d2886b51 |
| 22477 | Bulk Product 5797f19c | Sports & Outdoors | $146.58 | 373 | ★ 4.0 | 63 | BULK-87ae10b8 |
| 22478 | Bulk Product 07eab261 | Books | $567.42 | 341 | ★ 4.4 | 99 | BULK-218e05d4 |
| 22479 | Bulk Product a4ad83fe | Sports & Outdoors | $644.00 | 175 | ★ 2.7 | 40 | BULK-148bf691 |
| 22480 | Bulk Product b6ce691b | Electronics | $428.92 | 75 | ★ 2.1 | 74 | BULK-ad997565 |
| 22481 | Bulk Product efc4e516 | Electronics | $119.33 | 161 | ★ 4.9 | 8 | BULK-b6f3f3ef |
| 22482 | Bulk Product f6196851 | Sports & Outdoors | $385.41 | 422 | ★ 0.7 | 26 | BULK-f23b91c3 |
| 22483 | Bulk Product 53bb40c3 | Sports & Outdoors | $419.14 | 30 | ★ 3.2 | 73 | BULK-d9c33fe0 |
| 22484 | Bulk Product 6739661a | Clothing | $965.12 | 183 | ★ 1.8 | 60 | BULK-b169dbcc |
| 22485 | Bulk Product 0510fe14 | Home & Garden | $1,000.51 | 309 | ★ 3.3 | 44 | BULK-c73af304 |
| 22486 | Bulk Product c4449c6e | Electronics | $753.02 | 139 | ★ 0.7 | 22 | BULK-5c844d1a |
| 22487 | Bulk Product 812f8904 | Books | $979.88 | 251 | ★ 4.4 | 11 | BULK-91442d45 |
| 22488 | Bulk Product aee5aaae | Clothing | $330.09 | 396 | ★ 3.6 | 21 | BULK-e24b7d00 |
| 22489 | Bulk Product 26d59c39 | Books | $528.25 | 462 | ★ 4.1 | 50 | BULK-e00dc6d5 |
| 22490 | Bulk Product 76f1287e | Home & Garden | $316.46 | 249 | ★ 1.1 | 74 | BULK-7de0244f |
| 22491 | Bulk Product 0d78d888 | Toys & Games | $852.05 | 144 | ★ 4.9 | 81 | BULK-0da96849 |
| 22492 | Bulk Product 56c4bbd1 | Sports & Outdoors | $876.61 | 311 | ★ 3.6 | 38 | BULK-2613472f |
| 22493 | Bulk Product fe42b422 | Clothing | $484.92 | 440 | ★ 1.8 | 73 | BULK-188c23b5 |
| 22494 | Bulk Product ad611f71 | Electronics | $696.12 | 74 | ★ 1.0 | 9 | BULK-964b2a9b |
| 22495 | Bulk Product 55e46121 | Books | $531.16 | 210 | ★ 3.1 | 27 | BULK-a3515547 |
| 22496 | Bulk Product a77d60dd | Toys & Games | $919.74 | 410 | ★ 4.8 | 36 | BULK-4cd33d2f |
| 22497 | Bulk Product 637dc159 | Sports & Outdoors | $735.44 | 457 | ★ 3.4 | 48 | BULK-8999c919 |
| 22498 | Bulk Product 061a6f24 | Toys & Games | $178.83 | 497 | ★ 3.6 | 95 | BULK-5967d761 |
| 22499 | Bulk Product 48a69d22 | Books | $465.93 | 13 | ★ 3.5 | 78 | BULK-9d3b69ff |
| 22500 | Bulk Product c81bb476 | Clothing | $74.89 | 161 | ★ 2.4 | 1 | BULK-fb8109d3 |
| 22501 | Bulk Product 4ad8820f | Books | $558.31 | 205 | ★ 3.2 | 77 | BULK-d055322d |
| 22502 | Bulk Product 93a1b8a3 | Toys & Games | $905.39 | 30 | ★ 1.2 | 66 | BULK-8f13f741 |
| 22503 | Bulk Product 9479ad04 | Toys & Games | $466.13 | 55 | ★ 1.4 | 93 | BULK-13a1f260 |
| 22504 | Bulk Product de03f2b5 | Sports & Outdoors | $905.47 | 27 | ★ 1.8 | 31 | BULK-26784ee1 |
| 22505 | Bulk Product 9d64e144 | Toys & Games | $650.72 | 49 | ★ 4.7 | 79 | BULK-bae2fc55 |
| 22506 | Bulk Product 49a83c49 | Books | $988.00 | 159 | ★ 3.8 | 62 | BULK-dc6232aa |
| 22507 | Bulk Product 26d5a42a | Clothing | $939.70 | 155 | ★ 3.3 | 7 | BULK-8f9afd0f |
| 22508 | Bulk Product ed31149a | Electronics | $841.47 | 394 | ★ 1.1 | 10 | BULK-b071a21b |
| 22509 | Bulk Product 741f4454 | Books | $945.58 | 485 | ★ 0.3 | 69 | BULK-01d80ee4 |
| 22510 | Bulk Product 1585bf32 | Books | $488.96 | 88 | ★ 3.6 | 60 | BULK-27f986fb |
| 22511 | Bulk Product 6212ad4d | Toys & Games | $464.33 | 78 | ★ 2.7 | 21 | BULK-433939eb |
| 22512 | Bulk Product a4be0c60 | Books | $422.93 | 51 | ★ 1.9 | 80 | BULK-6f35a0dd |
| 22513 | Bulk Product 9d882117 | Toys & Games | $713.74 | 254 | ★ 4.2 | 49 | BULK-b6d703d8 |
| 22514 | Bulk Product daa0eb92 | Books | $620.96 | 334 | ★ 2.0 | 12 | BULK-492df9ac |
| 22515 | Bulk Product 0cef680c | Books | $129.66 | 400 | ★ 4.8 | 62 | BULK-aa62f2a6 |
| 22516 | Bulk Product 7c9bb762 | Books | $672.53 | 253 | ★ 2.4 | 52 | BULK-e293c3f9 |
| 22517 | Bulk Product 474a6147 | Clothing | $207.75 | 123 | ★ 1.7 | 53 | BULK-d784a4d3 |
| 22518 | Bulk Product 22013de1 | Home & Garden | $605.40 | 419 | ★ 0.9 | 42 | BULK-cf3e96ad |
| 22519 | Bulk Product 8fda3448 | Sports & Outdoors | $957.37 | 155 | ★ 0.5 | 91 | BULK-c978fa13 |
| 22520 | Bulk Product 32ef11f6 | Toys & Games | $529.85 | 342 | ★ 0.2 | 37 | BULK-ca50d014 |
| 22521 | Bulk Product 5eade75c | Toys & Games | $920.53 | 386 | ★ 0.6 | 37 | BULK-03712cb1 |
| 22522 | Bulk Product f1b5466e | Toys & Games | $847.46 | 68 | ★ 2.8 | 36 | BULK-7607d618 |
| 22523 | Bulk Product fee67d45 | Clothing | $759.58 | 87 | ★ 4.2 | 30 | BULK-b3768001 |
| 22524 | Bulk Product 7d213c63 | Clothing | $208.11 | 59 | ★ 3.4 | 31 | BULK-51327b1f |
| 22525 | Bulk Product 57de703f | Toys & Games | $425.83 | 159 | ★ 4.7 | 36 | BULK-19957af6 |
| 22526 | Bulk Product 77251194 | Toys & Games | $995.06 | 344 | ★ 1.8 | 9 | BULK-8a76dbd3 |
| 22527 | Bulk Product de4e47b9 | Toys & Games | $642.06 | 126 | ★ 3.0 | 51 | BULK-8e1fdbcf |
| 22528 | Bulk Product 19ca8064 | Home & Garden | $120.30 | 195 | ★ 0.4 | 15 | BULK-7e539145 |
| 22529 | Bulk Product 4c1add52 | Home & Garden | $620.79 | 493 | ★ 5.0 | 67 | BULK-e304d423 |
| 22530 | Bulk Product 4f974710 | Electronics | $537.89 | 310 | ★ 1.5 | 39 | BULK-766472f6 |
| 22531 | Bulk Product 709266e9 | Books | $397.29 | 108 | ★ 2.1 | 18 | BULK-89b68946 |
| 22532 | Bulk Product 7f7f8e61 | Electronics | $239.53 | 445 | ★ 0.8 | 77 | BULK-c20625bb |
| 22533 | Bulk Product 1ed61ad3 | Electronics | $81.84 | 452 | ★ 0.2 | 20 | BULK-3c33e6c1 |
| 22534 | Bulk Product b0e82820 | Home & Garden | $372.50 | 491 | ★ 1.7 | 52 | BULK-fe6f5059 |
| 22535 | Bulk Product f9248715 | Sports & Outdoors | $327.17 | 79 | ★ 0.6 | 45 | BULK-987cc5eb |
| 22536 | Bulk Product 04314dd1 | Electronics | $345.71 | 113 | ★ 4.0 | 24 | BULK-62cc033b |
| 22537 | Bulk Product 68dc6f37 | Electronics | $191.34 | 187 | ★ 3.7 | 6 | BULK-95796441 |
| 22538 | Bulk Product eb202149 | Home & Garden | $436.02 | 394 | ★ 1.8 | 62 | BULK-fadb4f2c |
| 22539 | Bulk Product 16328f09 | Books | $331.58 | 83 | ★ 2.5 | 57 | BULK-b09a15b5 |
| 22540 | Bulk Product 8dfb1a0a | Electronics | $526.29 | 470 | ★ 2.9 | 76 | BULK-cd3285fb |
| 22541 | Bulk Product 3eef1d00 | Clothing | $513.32 | 469 | ★ 2.3 | 85 | BULK-a0655e10 |
| 22542 | Bulk Product f63e101a | Electronics | $396.24 | 103 | ★ 0.5 | 62 | BULK-f91f458e |
| 22543 | Bulk Product 9523a9ff | Books | $659.22 | 458 | ★ 4.1 | 66 | BULK-72e6eb97 |
| 22544 | Bulk Product aec3fc92 | Electronics | $346.97 | 64 | ★ 0.1 | 91 | BULK-348ae387 |
| 22545 | Bulk Product 1c85cbfa | Sports & Outdoors | $170.44 | 493 | ★ 2.8 | 34 | BULK-695d5e2c |
| 22546 | Bulk Product 23cc8a33 | Home & Garden | $945.78 | 475 | ★ 4.3 | 75 | BULK-07f95a3a |
| 22547 | Bulk Product 94bb3a51 | Home & Garden | $591.51 | 309 | ★ 2.1 | 24 | BULK-b6bbf033 |
| 22548 | Bulk Product f9e7bfe1 | Books | $875.76 | 401 | ★ 4.7 | 30 | BULK-8c323634 |
| 22549 | Bulk Product 3e6d9638 | Home & Garden | $119.61 | 377 | ★ 4.0 | 92 | BULK-7ac35ed5 |
| 22550 | Bulk Product 9c11dd23 | Home & Garden | $160.07 | 314 | ★ 4.2 | 14 | BULK-f19a2f71 |
| 22551 | Bulk Product 28b971f6 | Books | $457.25 | 194 | ★ 0.4 | 39 | BULK-7d6b4cd0 |
| 22552 | Bulk Product f5c5025b | Home & Garden | $616.09 | 445 | ★ 1.8 | 8 | BULK-597b5c60 |
| 22553 | Bulk Product 465acade | Toys & Games | $420.67 | 117 | ★ 0.0 | 32 | BULK-f9fa5bd9 |
| 22554 | Bulk Product b4e58c68 | Clothing | $772.12 | 477 | ★ 4.6 | 75 | BULK-27f3957d |
| 22555 | Bulk Product 0f37a748 | Sports & Outdoors | $821.00 | 415 | ★ 2.0 | 61 | BULK-61a2bba7 |
| 22556 | Bulk Product 7c8d5f38 | Home & Garden | $38.01 | 57 | ★ 2.5 | 69 | BULK-a531746c |
| 22557 | Bulk Product d5cc170e | Toys & Games | $634.50 | 284 | ★ 3.7 | 96 | BULK-dd6492df |
| 22558 | Bulk Product b00c5edf | Books | $799.64 | 297 | ★ 3.7 | 17 | BULK-eb79aeca |
| 22559 | Bulk Product 5280756b | Toys & Games | $366.45 | 449 | ★ 4.2 | 24 | BULK-78112fd8 |
// Efficient pagination with Skip and Take
public async Task<PaginatedResult<DemoProduct>> GetPaginatedProductsAsync(int page, int pageSize)
{
// Get total count (cached if possible)
var totalCount = await _context.DemoProducts.CountAsync(p => p.IsActive);
// Get page of results
var items = await _context.DemoProducts
.Where(p => p.IsActive)
.OrderBy(p => p.Id) // Important: Must have ORDER BY for consistent paging
.Skip((page - 1) * pageSize) // OFFSET in SQL
.Take(pageSize) // FETCH NEXT in SQL
.AsNoTracking() // No tracking needed for read-only
.ToListAsync();
return new PaginatedResult<DemoProduct>
{
Items = items,
TotalCount = totalCount,
Page = page,
PageSize = pageSize
};
}